> I want a query to only return the
> record where a specific field is
> equal to zero.
In the Query Builder, in the Criteria line under the specific Field, enter 0
or =0. You can also add a clause to an SQL Statement WHERE
[yourspecificfieldname] = 0. Look at the SQL view of the Query you create in
Query Builder.
> Would I use a filter or an expression?
Your question does not make sense to me. Filters are similar to query
criteria, used with Forms or Reports to limit the Records displayed or
printed. Expressions are math or logic statements -- they may be used in
many situations in Access but they do not, in themselves, act as a "filter"
to limit the Records.
Question
Reply
Top
Answer
Notify me of replies