qry aggregation + criteria

[matrixknow]

I have a query that won't run, I find out why :

one field is a aggregation and another is a criteria field, these to won't go together. How to solve this.

Total Annual :([monthly_gross]*[Multiplier])

this is the aggregation

 period : with criteria #01/04/2007#

How do I let them work together ?

thanks in advance

 

[Remou]

It is usually better to post all the SQL.