what is wrong with this query?

[Guest]

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)

 

[Guest]

This works fine for me.
Can you post qryticketsperday1?