I have a query based on a non updateable linked table. In the table the date format is Date/time (06/08/2004 10:07:07). I have a report based on the query. In the report, I would like to group and subtotal by date. Unfortunately, it is looking at each date/time as a separate group. How can I make the report group and subtotal based on the date alone, without being able to change the format of the table's field?
Thanks so much for your help, these date formats get me every time.
Thanks again
Stacey
Thanks so much for your help, these date formats get me every time.
Thanks again
Stacey