I created a query to show the countdown of expiry date for membership
I drag "RenewDate" field From tblMember. then i define "ExpiryDate" and "Countdown" field in the query like following:

ExpiryDate: DateSerial(Year([RenewDate])+1,Month([RenewDate]),Day([RenewDate])-1)

Countdown: (DateDiff("m",Date(),[ExpiryDate]))

I run the query, everything is ok like can calculate the "ExpiryDate" and show how many month is left.

However, when i put ">=12" in Countdown's criteria. and run the query, the message popup and want me to enter "ExpiryDate" parameter.

Can anyone help me to solve the probl. thank you very much.

Try using:
instead. Put the entire expression in the column rather than referencing a separate calculated column




I am a loud man with a very large hat. This means I am in charge

Thank you very much for your valuable help .....it works !

Say, I am curious about this expression:

DateSerial(Year([RenewDate])+1,Month([RenewDate]),Day([RenewDate])-1)

What if the Renew Date is December 1, 2005? Your expression will evaluate to:

December 0, 2006

How does that get resolved in Access? Do you get any errors? Wouldn't a safer expression be:

DateAdd("d", -1, DateAdd("yyyy", 1, [RenewDate]))


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division