Mix Expression and criteria in same field

[coasterman]

My query has a number of calculated fields which pass a value down the line and ultimately gives me a date. The final calculated field in the query is

Date()+[DaysLeftToLim] AS LimFilter

what I would like to do is filter the records using a criteria, in this case a number of days before the current date.

If I for instance enter <Date-180 in the criteria for LimFilter a dialog pops up asking for a parameter value for DaysLeftToLim.

I take it it is not possible to add a criteria to a field in a query whose value is determined by an expression?

How would I go about this?

Thanks for looking

 

[coasterman]

Just in case anyone was looking. I now realise I can't use a calculated filed as part of the where clause. I will be creating a second query based on the first, as I write I am wondering if the recordset will still be updateable as this now 2nd query will be the record source of a form?

Will find out soon enough