Access 97 Calculating both Month and YTD totals on a report
Posted on 2003-12-02
I need to generate both YTD and Monthly totals on a report.
YTD - Works fine: Need Totals For Clients, Other Hours, Counseling Hours and Total Hours.
I Calculate The Year To date As Follows:
Calculate Other Hours (Textbox39)
Calculate Total Hours (Textbox41)
Calculate Counseling Hours
Now I Need to Calculate The Current Month for:
Clients, Other Hours, Total Hours and Counseling Hours
I need to setup a varriable that I can change each month
for the current month I want on the report. In the format
MM/YYYY. I have a field in each record called Fmonth in the same format MM/YYYY.
In a nut shell I need the following:
Calculate Clients If the varriable = the Fmonth I want to count Fname like I do above in the year todate section above
Calculate Other Hours If the varriable = Fmonth I want to Sum Hours like I do above in the year to date section.
Calculate Total Hours If the Varriable = Fmonth I want to sum Hours like I do above in the year to date section
If I can get the above three totals I can get the forth total
Counseling Hours by Subtracting Other Hours From Total Hours.
I can't seem to setup the varriable or work with Fmonth in a calculation.