Using Criteria in an Expression

[Scottie31]

I am running a query which returns daily sales numbers a also calculates a percentage increase. The query works fine until I try entering criteria to give any percentages that are >150 or <50, when running this no results are returned. Any help on this would be greatly appreciated.

Thanks.

 

[wazz]

i think you have to create a new query with the first query as the source (instead of a table).