Results 1 to 4 of 4

Thread: Access Help

  1. #1
    Join Date
    Aug 2002
    Posts
    6,223
    Rep Power
    0

    Default Access Help

    This is a minor problem, but has been bugging me a bit. I want to use a wildcard in a record search that uses a range but only for specific numbers in that range. For instance, I want to pick the following number between 175 and 193:

    175, 176, 177, 178, 185, 186, 188, 191, 193

    Basically, I want to get the following:
    [175-178, 185-186, 188, 191, 193]

    Normally to pull up all values between 170 and 199, I could input

    1[7-9]?

    And that would give me all 30 results. Any help would be appreciated.
    .
    PC - Ubuntu 15.04 64bit Desktop
    HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home

    "So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"


    RIP Ramesh ...

  2. #2
    Join Date
    Aug 2002
    Posts
    6,223
    Rep Power
    0

    Default

    Never mind.... I'll try to figure it out myself.
    It's not urgent.
    .
    PC - Ubuntu 15.04 64bit Desktop
    HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home

    "So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"


    RIP Ramesh ...

  3. #3
    Join Date
    Nov 2002
    Posts
    5,713
    Rep Power
    0

    Default

    I'm not sure if I fully understand your question. Is my interpretation accurate given the queries shown below?

    Code:
    Select * FROM Table
    Where Column1 >= 175 AND Column1 <= 178;
    
    Select * FROM Table
    Where Column1 >= 185 AND Column1 <= 186;
    
    Select * FROM Table
    Where Column1 >= 180;
    
    Select * FROM Table
    Where Column1 >= 191;
    
    Select * FROM Table
    Where Column1 >= 193;
    .:] ^ [:.
    .:] Game IDs: xfire_ropy | BC:BC2_ropy | BC: 2142_ropy29 | BF3_ | steam_ropy09 | LoL_ropy09 | Origin_ropy29 [:.

  4. #4
    Join Date
    Aug 2002
    Posts
    6,223
    Rep Power
    0

    Default

    Well I don't want to adjust the query itself. The prompt asks me which records I wish to see, and I want to be able to select multiple records at one shot so they all come up in the resulting report without having to use the same query multiple times.

    For instance:
    If I entered this below:

    79[1-9]A

    it would give me the following (if they exist) in one report

    791A
    792A
    793A
    794A
    795A
    796A

    ....


    799A

    I used to know this.... and it may involve using escape characters....getting old you know.
    .
    PC - Ubuntu 15.04 64bit Desktop
    HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home

    "So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"


    RIP Ramesh ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •