Query on Table not filtering correctly

J

Jason

I have a query where Select * from ApprovedList where ApprovedFld =
"Approved"
However even thought the record does contain "Approved" the record only
shows up if I change the code to "Select * from ApprovedList where
ApprovedFld is not null"
or "Select * from ApprovedList".

This is reqlly wierd
 

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
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
QBF & Query Malfunction 0
Update multiple record values in form/query 0
Update multiple record values from form/query 0
Update multiple record values 1
Adding data to MS Access from csv file 0
Update multiple record values from form/query 1

Top