Query Criteria error

[WiReLaD]

I have a query field which I have named Indate:



After which I have then continued the line as follows: Indate: IIf([ExpireDate]>Date(),"Live","Expired")

ExpireDate is a populated cell thats calculated by way of adding years from a test date textbox. eg, I enter a test date 01/01/2013 and ExpireDate populates by adding 5 years = 01/01/2018

This works fine.

My problem comes - When I run the query, I only want to see anything with "Live" status

I've tried all the normal criteria: options) "Live" or Like "Live" or "*live*" etc...

The problem is, when I enter this into the criteria line, the query then doesn't seem to see the field ExpireDate: and asks me to enter the parameter value for ExireDate.

Any help is much appreciated
Thanks
Mike

[alansidman]

ExpireDate is a populated cell thats calculated by way of adding years from a test date textbox. eg, I enter a test date 01/01/2013 and ExpireDate populates by adding 5 years = 01/01/2018

Is this expression in your query? I don't understand what you are referring to by a cell. That is a spreadsheet term and is meaningless in Access. Are you referring to a field in a table or query or are you referring to a control in a form?

Usually you will get a parameter request as indicated when Access cannot identify a field in the table or query. Have you double checked your spelling to ensure it is exactly the same in your expression as in your field. No leading or trailing spaces? Spelled correctly?

[WiReLaD]

Its alright, its fixed.