Posted 17 May 2006 - 10:01 PM
Design view looks like a table.
Underneath the field names you can write expressions on the same line (AND) or on different lines (OR).
Otherwise, do it in a formula writing window where you can select tables, fields and operators. Basically what you want to write would come looking something like NOT ([table.COST]<[table.PAID])
Use Access Help for details about formulas or expressions in a query. I can't recall how to get there, but I think double click on the criteria rows will get you there. If not, well, there's always the SQL window to write it in the hard way.