Running Queries to retrieve data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I ran a simple query and retrieved all the necessary records, but felt
that one needed to be cut from the query because it didn't quite fit the
protocol for the report, but to change the query would have eliminated other
important records. I later learned that it did need to be included, but now
no matter what I do, I can't get any queries to retrieve the original data
set. The record and all it's data still exists in the table. I've even tried
to do a brand new design for a query and start from scratch, but it still
eliminates that one record. Any suggestions?
 
Check the data in the table for the field you set criteria for in the query.
It sounds like the data changed.
 
Thanks!

PC Datasheet said:
Check the data in the table for the field you set criteria for in the query.
It sounds like the data changed.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Click to expand...
 
You must log in or register to reply here.

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

Retrieve "up to #" records in a select query 9
Delete Query: Could not delete from specified tables 0
Query lacks Specific Criteria 1
Access #Error & Excel Pivot 0
Combine Duplicates in Query 0
Query Problem 13
VBA - retrieve data on last create named range from previous inserted named range 0
Run a Query from a Form 6

Back
Top