Query Expiry

[syedadnan]

Regards

need to know is there any way to make the query expired after a defined period but it must remain with that query only not for other queries. Also the query expires should have an option to be alive again or redated for next period after updation means expiry means stop working but not corupption or anythinng else.

any idea !!

 

[bob fitz]

Can you tell us more about what you are trying to do.

 

[syedadnan]

Can you tell us more about what you are trying to do.

Thanks for replying, i have a query which is almost performing 80% of my DB work. what i need is to setup a expiry date in or out side the query which may control the accessbility of the query .. i do not need query to be corrupted but want to stop working till i open the query in design view and increase expiry date then again it must start working.. i think yoou got it now..

 

[Mihail]

An easy solution:
Create one more field: ShowRecord: (Date() <= #31.12.2013#) with the Criteria = True

 

[syedadnan]

An easy solution:
Create one more field: ShowRecord: (Date() <= #31.12.2013#) with the Criteria = True

Thanks a lot will try and hopefully will be as per requirement

 

[MSAccessRookie]

An easy solution:
Create one more field: ShowRecord: (Date() <= #31.12.2013#) with the Criteria = True

This should be an excellent way to do what you want. Condiser also the possibility of not using a hard coded Date, and instead, having a Table to store the date (and others like it) in. Two distinct advantages to this approach include the fact that you do not need to edit Queries to update the date, and the fact that you can create a common control date for multiple Queries following the same rule.

-- Rookie