chacamasur
Registered User.
- Local time
- Today, 09:19
- Joined
- Oct 8, 2010
- Messages
- 18
I've looked around and have found: running sum =1 ,(Over group and/or Over All) produces ALMOST what I am hoping to achieve.
I think based on my HEADINGS I am hoping to RESET the running sum (If possible)
HEADING AREA
--HEADING CATEGORY
[Text box] --Detail (RECORDS)
running sum =1 ,(Over All) produces:
A100
Furniture
1,2,3
Lighting
4
E200
Furniture
5,6,7,8, etc, 22,
Lighting
23,24, etc
**************************
**************************
I I would like to do is:
A100
Furniture
1,2,3
Lighting
4
E200 ß RESET based on AREA Change
Furniture
1,2,3,4,5 etc, 18,
Lighting
19,20, etc
I am hoping this can be done on the report... if not thinking query.. but a little unsure what might be ideal.
Thank you to all that read
Cheers,
I think based on my HEADINGS I am hoping to RESET the running sum (If possible)
HEADING AREA
--HEADING CATEGORY
[Text box] --Detail (RECORDS)
running sum =1 ,(Over All) produces:
A100
Furniture
1,2,3
Lighting
4
E200
Furniture
5,6,7,8, etc, 22,
Lighting
23,24, etc
**************************
**************************
I I would like to do is:
A100
Furniture
1,2,3
Lighting
4
E200 ß RESET based on AREA Change
Furniture
1,2,3,4,5 etc, 18,
Lighting
19,20, etc
I am hoping this can be done on the report... if not thinking query.. but a little unsure what might be ideal.
Thank you to all that read
Cheers,