Help with a query

[twuncher]

I have a query with a column destruction date which is a date...
i want another column which compares the destruction date with the currant date and puts a Yes or No as to wether it can be destroyed or not..

eventualy id prolly like to make it so it will alert the user when a file can be destroyed but i think my skills arent quite up to that yet.

thx for your time

 

[SydneyGeek]

In your query, in a blank field to the right of [DestructionDate], create this calculation --

DestructionDue:Iif([DestructionDate]>Date(),"No","Yes")

Save the query and run it to check the logic. If OK, you're in business. If reversed, change the Yes and No around.

Further option:
In the Criteria row below the new field, type "yes"
Now when you run the query you will ONLY see the list of files ready for destruction.

HTH

Denis

 

[twuncher]

cheers that worked great

thanks i really appreciate it