No records are displayed

T

Tina

I have two tables that I want to query. They are
connected by the field "Type of System". However, when I
run the query, nothing is displayed. The weird part is
that yesterday when I was experimenting with the query, 6
out of 500 records were displayed. Now, I can't get
anything to show. Is there something I'm missing??? Any
suggestions would be useful.
 
K

kevin

Tina,

Did you make sure that you have the field that has the
relationship in the query? I have linked tables through a
query before yet forgot to report in the results items
that were in the married fields. then i got no results.
or blank like you are saying. the query will show anyting
that meats all the criteria that you set. I would guess
that you don't have that field in the query.

Hope this is it.
 
Top