Hi I have created a query that produces exactly what I want and from that I then run a report. This is great until I then want to group the report by date.
The table that the info comes from has the date created by the now() command so its in the dd/mm/yyyy hh:mm:ss
If I group on the date field then it does it for every time event. So If I have 500 entries for one day it will group them as individuals as the time is different.
How can I group on dates only and also how can I assure that its using the UK dd/mm/yyyy format.
Cheers
The table that the info comes from has the date created by the now() command so its in the dd/mm/yyyy hh:mm:ss
If I group on the date field then it does it for every time event. So If I have 500 entries for one day it will group them as individuals as the time is different.
How can I group on dates only and also how can I assure that its using the UK dd/mm/yyyy format.
Cheers
