Queries not running

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

What does it mean when you run a query and do not get results? However, if I
create a new query it runs. I have had this db for awhile. Recently I had
to replace data in the main table. Checked all fields are there but when I
try to run queries it is not generating any data. But there is data in the
Main table. Can someone help? Thank you in advance for any help.
 
There are many reasons why a query could yield no results even when there
are records in the table.

A simple example would be that none of the record match the criteria of the
query, or the query has something in its Filter property. Alternatively, it
might have to do with the joins in the query. For an example, see:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

If none of these things apply, you might try running a repair on the
database. Follow the sequence here:
http://allenbrowne.com/recover.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top