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

Try

Format(DateField, "short date")

Rather than formatting dates, it is better to use the correct date function so that the field retains its date-like properties. Use DateValue() to get just the date part and TimeValue() to get just the time part of a date/time field.

Cheers Pat, that sorted it.