Question about Access query

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

When I do a query on an Access table, it only returns the
first 99 matching records. Has anyone else seen this?
I'm running Microsoft Access 97 SR-2.
 
In the Query-By-Example window, right mouse click on the area where the
graphical tables/relationship reside. This will show the Query Properties
window. What does the "Top Values" field indicate? Does it say "All" or,
your case, 99?

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top