View Single Post
Old November 21st, 2005, 12:20 PM
yikchin yikchin is offline
Authorized User
Join Date: Nov 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help! Date query Problem

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.