Re: date range issues in reports
From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 09/17/04
- Next message: Fons Ponsioen: "re: field not printing dilemma"
- Previous message: Duane Hookom: "Re: Update Report"
- In reply to: Christina Barnett: "Re: date range issues in reports"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 17 Sep 2004 09:53:32 -0700
Excellent, glad to help.
Come back any time; we're open every day.
-- Jeff Conrad Access Junkie Bend, Oregon "Christina Barnett" <cbarnett@aigannuity.com> wrote in message news:19dd01c49cd3$f04ff160$a301280a@phx.gbl... > Jeff~ > > That worked well. Thanks for your help. I'm sure I will > have more questions in the future. > > ~Christina > > > >-----Original Message----- > >Hi Christina, > > > >That helps a lot thank you. I think I understand > everything, but I'm making a assumption that you > >simply want to see a total for all items completed each > day as well as a total for all items > >completed during whatever time span you would like. My > instructions below will NOT total the number > >of items processed by EACH individual item for the time > frame specified. That is something > >different. > > > >Doing a quick test with some sample data I *believe* I > was able to get the results you desire by > >just using the report wizard. Open the Sorting and > Grouping dialog box ( View | Sorting and > >Grouping ) and tell me what you see there. In my report > I have the following item: > > > >Field/Expression: Sort Order: > >ProcessDate Ascending > > > >(I named my field ProcessDate) > > > >In the lower half of this sorting box I have this: > >Group Header: Yes > >Group Footer: Yes > >Group On: Day > >Group Interval: 1 > >Keep Together: No > > > >What this is doing is telling Access to sort the date by > each day and create a section Header and > >Footer for this particular group. This is the first step. > > > >The next step is to create an unbound text box in the > ProcessDate Footer section of the report. Here > >we will total all the items completed. I used this as > the Control Source for the text box: > >=Nz(Sum([ItemsCompleted])) > > > >This gives me a count of all the items completed for > that day. (My field was called ItemsCompleted) > > > >Next, I put another text box in the Report Footer > section of the report. Here we will total all the > >items completed for the time period specified. I use the > same Control Source: > >=Nz(Sum([ItemsCompleted])) > > > >When I run the report I see each day's processes listed, > followed by a total for that day. At the > >end of the report I see a total for all the days > specified. > > > >Is this what you are looking for? > > > >-- > >Jeff Conrad > >Access Junkie > >Bend, Oregon > > > ><anonymous@discussions.microsoft.com> wrote in message > >news:000101c49c0e$e299c520$a501280a@phx.gbl... > >> Jeff, > >> > >> Here it is again. Sample report: > >> > >> DATE 09/01/2004 > >> COMPANY TOTAL > >> AIGA Telephone 5 > >> AIGA Emails/Notescreens 0 > >> AIGA Pays/Completes 0 > >> AIGA Partial 0 > >> AIGA Correspondence 2 > >> AIGA Misc Items 0 > >> AIGA 2nd Request Letters 0 > >> AIGA 5 Year Expiration Open 2 > >> AIGA Return DC Letters 0 > >> AIGA Initial 2 > >> AIGA Spousal 0 > >> AIGA Open Claims 0 > >> > >> The same data is repeated for 9/2/2004, 9/3/2004, and > >> 9/4/2004 (with different totals). I would like the date > >> to show 9/1/2004 - 9/4/2004, and total the TOTALS > columns > >> for each day into one overall total. > >> > >> If this is not enough, let me know. Thanks for your > help! > >> ~Christina
- Next message: Fons Ponsioen: "re: field not printing dilemma"
- Previous message: Duane Hookom: "Re: Update Report"
- In reply to: Christina Barnett: "Re: date range issues in reports"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
