Is this query correct??/

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

Try this

Code:

---

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

---