Hi All

Just some info ... apologies if this is general knowledge!

For the first time (as far as I can remember) I needed to produce a
report where the data was grouped to produce weekly totals in a report
with monthly or quarterly (or even annual) data. I thought I'd have
to create some date functions and be quite sneaky in order to do
this. I was VERY gratified to find that A2010 reports have built-in
options to group (on an existing date field, naturally) by week,
month, qtr etc. Brilliant! This has saved me having to think ... at
my age a great advance.

I am not aware of this functionality in earlier versions (maybe it was
there and I never saw it). Anyway, it's an excellent feature and I
commend it to the house ...

JB

FYI

That feature has been around since at least Access 97.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 5/26/2011 2:50 PM, jbguernsey wrote:

On May 27, 1:58*pm, John Spencer <JSPEN... (AT) Hilltop (DOT) umbc> wrote:
Hi John

I just had a look at sorting and grouping in A2003 and I couldn't see
how to group on week, month etc. It must be there if you say so but
it's not at all clear how to operate it. Is it the Group On/Group
Interval thing? If so, how do you use it? (I tried putting 'Month' in
the Group Interval - not accepted ...

By the way, your advice to use subforms for the day columns in the
timesheet thing I asked about a while ago was bang on. Timesheet
works very well and client is happy. Thanks again.

JB