Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    error caused by too many records (97)

    error caused by too many records
    The query I

  2. #2
    Star Lounger
    Join Date
    Oct 2001
    Location
    Western Massachusetts, USA
    Posts
    99
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error caused by too many records (97)

    Not sure why a million records would bomb, but do you have any other qualifiers that would allow you to split the query into 2 seperate queries? For example, if you could put a Date parameter in the queries and split it Before xx/xx/xx and after xx/xx/xx that should help some.
    Paul

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Illinois, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error caused by too many records (97)

    If there any null values in the field and your criteria expression is trying to perform a string operation, I think that can give a type mismatch. Maybe you could try excluding nulls from the selection. Just suggesting this, because I have been "Nullified" a number of times in Access query expressions.

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

    Re: error caused by too many records (97)

    That's by far the likeliest reason for the error. I've certainly run headlong into it many times, although never with a million records to wade through.
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: error caused by too many records (97)

    Checking with a NULL criteria gives a ODBC SQL Driver timeout error
    Checking for an

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: error caused by too many records (97)

    Hi,
    I'm not sure why it's bombing if you don't use any criteria, but Access will often give the type-mismatch error if you specify text criteria on a count field (I think it tries to evaluate the count against the criteria rather than filtering what it actually counts!). Have you tried adding the field as another column using Where and putting the criteria in that column rather than in the same column you're doing the count in?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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