General Date Query

[Thepieman]

I have a database that records IT Incidents for a major company, when an incident is recorded the date is automatically input in "General date" format. I now need to produce figures that summarises how many faults occur each day, but can't get my query to work. Can anyone help ?

 

[Brianwarnock]

You don't say how your query failed, about as useful as Microsoft's error messages, but I'll guess that you grouped on your date field, but as this contains a time you effectively would summaries on date and time.
Create another field in the query say flddateftd:Format([yourfield],"dd/mm/yyyy") and groupby that

Brian