I've created a recordset to determine a recordcount. Here is my SQL string:
SELECT PC_Log.ReportDate FROM PC_Log
GROUP BY PC_Log.ReportDate, Left([Request Number],4)
HAVING (((Left([Request Number], 4)) = 'FY14'))
Is it possible to use DCount instead? I can't figure out how to use the "GROUP" within the DCount statement.
Thank you in advance!!