No records are displayed

  • Thread starter Thread starter Tina
  • Start date Start date
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.
 
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.
 

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

Similar Threads

Query Returning Multiple Results 1
Access Access Record Order 0
running total of records in query 1
Query to display highest totals 1
Query Not Displaying All Records 4
Combine Duplicates in Query 0
Data Not Displayed in Query 2
Dcount returning no results!!! 0

Back
Top