cooldudeattitud
Dec 9th, 2003, 12:52 PM
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
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