table data does not appear in query

T

Tricia

Recently I have data that has been entered by form into a
database. The data shows up in the table, but does not
show up in the query. I have removed all criteria from
the query, deleted the entered data, and tried again. It
doesn't work. I even tried just entering the data into
the table, it still doesn't show up in the query.

I have had this database running for almost two years
without this problem. I have not had any problems
before. How do I fix this without having to totally start
over from scratch?
Tricia
 
V

Van T. Dinh

Just do a quick Query with SQL String:

SELECT *
FROM YourTable

and see if the data appears. I am fairly the data would.

Most likely, the problem is in your Query, e.g. the required Field is not
included or the number of rows is restricted.

Please post relevant Table details and the SQL String of your Query.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
Adding data to MS Access from csv file 0
Some mail merge fields not pulling into document 2
Excel does not accept text format! 0
Access Query to import from Sharepoint 0
Report Query Works 2nd Time, But Not 1st 14
Solved Disk Full error message when exporting PDF 0

Top