[mso] FW: access subtotals and totals

  • From: "Ann E Fitzmaurice" <a.e.fitzmaurice@xxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Wed, 14 Feb 2007 22:09:18 -0000


To: 'mso@xxxxxxxxxxxxx'
Subject: access subtotals and totals

Hi all

I have set up a simple database with a data sheet with variables, persons id
no name , date, hours, rate

Have set up an overall query to calculate the total for each line of data in
the table

I have also set up individual queries to do the same but for each person

I have also set up a report which produces the information, name, date ,
total for that day , i.e. 1 line per entry in the table

What I would like to do is to add subtotal for each person in the report and
an overall total

I would also like to repeat the report but to produce separate pages for
each person, 

I have searched the web and cannot find out how to do this- can anyone help
or point me in the right direction

Ann E Fitzmaurice

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts:

  • » [mso] FW: access subtotals and totals