Is this query correct???

[cooldudeattitud]

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

[RichardAtherton]

replace the &num& with #num#, assuming num is a valid date format in the format of MM/d/yyyy

[kovan]

here you goo

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

[sw_is_great]

or use something like

to_date function