Where did my criteria table go in query design?

S

Strasser

I created a new query and all was OK: tables and joins in top of
design window.
Table showing fields to display and criteria in bottom of same query
design window.

When I returned later to the saved query, I bottom table is nowhere to
be found.
I scroll down and scroll to right and can’t find the table (my
criteria or fields to display).
Thank you in advance!
 
J

John W. Vinson

I created a new query and all was OK: tables and joins in top of
design window.
Table showing fields to display and criteria in bottom of same query
design window.

When I returned later to the saved query, I bottom table is nowhere to
be found.
I scroll down and scroll to right and can’t find the table (my
criteria or fields to display).
Thank you in advance!

The query design window will delete a table if you a) don't display any fields
from that table and b) don't apply any criteria or sorts to any field in that
table. Try re-adding the table and select at least one field to display (you
don't need to do anything with that field on your form or report, but it
should be in the fields list).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top