Hi I am having a date(text) in one variable.
And the format of date variable in the access database is
m/d/yyyy.
Is the following query correct to do that.

The variable num has got a date of type string sth like 7/1/2003.

And the date format in access is m/d/yyyy

SELECT Sum(Poamount),Buyer FROM stats where Buyer='Brad' and date='&num&'group by Buyer order by Buyer