To filter or not to filter?

F

Frank

I want a query to only return the record where a specific field is equal to
zero. Would I use a filter or an expression?
 
L

Larry Linson

I want a query to only return the
record where a specific field is
equal to zero.
Click to expand...

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?
Click to expand...

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.
 
Top