Is this query correct??/

[cooldudeattitud]

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

[Memnoch1207]

Try this

SELECT Sum(Poamount), Buyer 
FROM stats 
WHERE Buyer='Brad' AND [date] = #" & num &"# 
GROUP BY Buyer
ORDER BY Buyer