Query Criteria Problem

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

Guest

I have a query based off of table "Withdrawal" with a field called
"withstatus" which is a combo box where you can select "Posted" or "Not
Posted". When I run the query without any criterias everything shows up but
when I try to type "Not Posted" in the criteria for the "withstatus" field
nothing shows up (Even though there are records with "Not Posted" for the
"withstatus" field). Thanks for your help.
 
Michael

Sorry to say, you've probably been "bit" by a "lookup" datatype. When you
use the "lookup" data type, Access stores one thing, and displays another.
Check the tablesdbdesign newsgroup and/or mvps.org/access website for the
dangers of using lookup-type fields.

Instead, change the data type of the field to match the data type of
whatever the underlying table's primary key is. Then, use a query to join
your main table and this lookup table.

For parameters like "Not Posted", you'd use the corresponding field in the
lookup table, not in the main table.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top