Filter a formula

[jxbeeman]

Hi,
I'm new to Access and am looking to filter a query?
What I've done is this, I have a column which contains a formula that
references another column. I'm trying to add a Criteria of say "0" in this
formula column so i only have those rows that result in a 0 in that column.
I know i can filter it in the table view but i want to have the criteria
hardcoded into the query.

Thanks,
Josh

 

[Arvin Meyer [MVP]]

In the design view of the query (the query grid or QBE), add a 0 as the
criteria.