Help!

nutra

New Member
Joined
May 23, 2005
Messages
35
I have a very simple database with about 400,000 records with purchasing information.

There are some item numbers that do not show up in my query when I know they should. They are in the table (along with hundreds of other items that show up in the query just fine) but no matter how I tweak the query, they do not show up.

I know I'm not giving a whole lot of information to go off of, but does anyone know of any bugs in access 97 that might cause something like this?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,288
Don't know of any bugs that could cause this.

Perhaps you could give some more information.
 

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
Hi

Often these situations arise through incorrectly specified query criteria - in particular incorrect field format assumptions, incorrectly specified criteria or the use of 'And' in place of 'Or', or vice versa.

As Norie suggested, some info would be useful so how about posting the query SQL? You can get to that when in the query design screen by clicking View -> SQL View.

Andrew :)
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,288
Andrew

The OP PM'd me and I think the problem was along the lines of what you say.:)
 

Forum statistics

Threads
1,078,400
Messages
5,339,991
Members
399,346
Latest member
t0land

Some videos you may like

This Week's Hot Topics

Top