Special Grouping & Subtotal

[Guest]

I have a personalized training report for employees that I need to finish up
and I can really use any help I can get. It's been a frustrating morning. The
report is a master/detail format where I have the empoyee personal info at
the top and a list of their classes below. I need to split the classes into
years and subtotal them. The year is based on their employment anniversary
date. I have already created a query which pulls the current two years
training history. I just need thereport to split it acordingly. For example,
if an employee was hired on 03/22/1993, his anniversary date is 03/22/2006.
My query already pulls the training from 03/22/2004 up through his
anniversary date, but I need the report to group the training from
03/22/2004 through 03/22/2005, subtital that, then do the same for 03/22/2005
through 03/22/2006 and subtotal that. Am I asking too much from MS Access?
Thx in advance

 

[Marshall Barton]

I have a personalized training report for employees that I need to finish up
and I can really use any help I can get. It's been a frustrating morning. The
report is a master/detail format where I have the empoyee personal info at
the top and a list of their classes below. I need to split the classes into
years and subtotal them. The year is based on their employment anniversary
date. I have already created a query which pulls the current two years
training history. I just need thereport to split it acordingly. For example,
if an employee was hired on 03/22/1993, his anniversary date is 03/22/2006.
My query already pulls the training from 03/22/2004 up through his
anniversary date, but I need the report to group the training from
03/22/2004 through 03/22/2005, subtital that, then do the same for 03/22/2005
through 03/22/2006 and subtotal that. Am I asking too much from MS Access?

Add a calculated field to the report's record source query
to calculate the "age" of the person using the expression:

YearsHere: DateDiff("yyyy", [Aniiversary], Date()) +
(Format(Date(), "mmdd") < Format([Aniiversary], "mmdd"))

Then use Sorting and Goruping (View menu) in the report's
design view to create a group with header section on the YIS
field. Add a text box bound to the YIS field in the group
header section.