How do i???

[Lhuffst]

I have a table with many fields such as
MT_Size
MT_Manu
MT_tested
RM_size
RM_passed
Fh_issued
FH_Returned

If I am trying to do a report that breaks out each of these into groups based on the first 2 letters of the field, how would I do that?

the report the customer wants has several sections. The first show new meters tested (MT above). I need to list the info and have a summary.
the section section is for Returned Meters (RM)

report is supposed to look something like

1. New Meters Tested
Date Size Manu Number tested
totals go here
2. Meters Returned
Date size passed
totals go here

grand totals at end of report

How do I make the groups?
Thanks
Lhuffst

 

[dhookom]

I don't totally understand your requirements but expect you can use multiple subreports that have their own records sources.

Duane
Hook'D on Access
MS Access MVP