Filter a formula

  • Thread starter Thread starter jxbeeman
  • Start date Start date
J

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
 
In the design view of the query (the query grid or QBE), add a 0 as the
criteria.
 
Back
Top