table data does not appear in query

[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

 

[Kevin3NF]

Please go into SQL view of the query and paste the SQL here....

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[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.