help with criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mhmaid - 20 Jul 2006 08:21 GMT

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?

Reply to this Message

John Spencer - 20 Jul 2006 13:03 GMT

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

>i have one qry"Expense reports" where there is one field "expense category"
> which is txt field.
[quoted text clipped - 5 lines]
>
> help if this is possible?

Reply to this Message