help with criteria

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

Guest

i have one qry"Expense reports" where there is one field "expense category"
which is txt field.
i want to filter this qry by putting criteria.
one of the exp categories is "allowance" .i want to filter like this

if expense category is "allowance" then , for this category , show only
amounts less than 200 (there is one field for amount "amount")

help if this is possible?
 
WHERE ([Expense Category] = "Allowance" and Amount < 200) OR [Expense
Category] <> "Allowance"

If you are doing this in the query grid use two lines of criteria
Criteria line 1: under Expense Category enter <> "Allowance"
Criteria line 2: under Expense Category enter "Allowance" under Amount
enter <200
 
Back
Top