what is wrong with this query?

M

mscertified

It gives me a 'data type mismatch'

SELECT count(*), opdate
FROM qryticketsperday1
group by opdate
order by opdate desc;

qryticketsperday1 just gives me back a single date column (more specifically
a datevalue(datetime) value)
 
Top