Query on Table not filtering correctly

  • Thread starter Thread starter Jason
  • Start date Start date
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
 
It turns out the record was in the list - just in the middle due to no
sorting.
 
It turns out the record was in the list - just in the middle due to no
sorting.
 
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

The query cannot be completed. 1
Need combo box to refresh when moving to new record 2017 1
Update multiple record values from form/query 1
Update multiple record values 1
function use with table 6
Highest value for a field 2
Outlook Creating an Outlook form 2
remembering the amount 3

Back
Top