Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Orange Park, Florida, United Arab Emirates
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query criteria (Access2000)

    Am working with a fairly large DB, 50MB, and need to select groups of records based upon the value of one field. This field is a text field which contains only numbers. Normally I merely enter the value I want to extract and the query works fine, except on this one field. Nothing I've read in any of several manuals indicates a problem but when I enter a value in the criteria row, I get a blank datasheet. If I use any of the comparison operators, I get the complete listing. I tried to convert the field to a numeric field but receive an error message that insufficient disk space or memory exists. System has 20 GB hard drive and 384 MB RAM. Am at a loss as to how to proceed. Suggestions gratefully accepted.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Query criteria (Access2000)

    Since your field is a text field, you need to put quotes (") around your criteria to make it work. As to changing the field to numeric, you may need to create a new empty table and run an append query to convert the data. Also, do you know what service release your Access is at - there were some weird things that happened with large tables that were fixed in SR-1.
    Wendell

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Query criteria (Access2000)

    I have not got SR-1 yet, how do I get it? Can I just download it from MS?
    TIA
    Pat

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Query criteria (Access2000)

    Yes, it can be downloaded from the MS site, thought it is something on the order of 50MB or more, so you will want to use a high speed connection. Make sure you have your original 2000 CD available when you try to install it. In fact there is a great deal of info about how to install the SR on the MS web site as well.
    Wendell

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query criteria (Access2000)

    I don't think SR1 for Office 2000 was that large, Wendell, but my memory may be slipping. <img src=/S/granny.gif border=0 alt=granny width=20 height=20>
    Charlotte

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query criteria (Access2000)

    Francois

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Query criteria (Access2000)

    You are correct - I looked at the site Francois found twice last night and couldn't find the size. But it's there now 26 to 40MB - if you are using Access it will be closer to 40MB.
    Wendell

  8. #8
    New Lounger
    Join Date
    Aug 2002
    Location
    Orange Park, Florida, United Arab Emirates
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query criteria (Access2000)

    I tried using double quotes but was unsuccessful. I finally did create another table and modified the contents of that field from text to numeric which enabled me to filter on that field. Thank you for your assistance. By the way, I had updated Access 2000 last week.

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Query criteria (Access2000)

    Thanks Francois, Wendell and Charlotte

Posting Permissions

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