what is wrong with this query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
Back
Top