[mso] Re: FW: access subtotals and totals :VSMail mx2

Ann,

You can do a lot of this in your Report design.  Bring in your quesry =
with the totals that you want.  Create a report that shows all the data =
you want.  Click on the Sorting and Grouping button.  Add a header and =
footer for the name field.  Add a calculated field to total your total =
hours, copy that formula down to the footer to get an overall total.=20

If you want to break it down to a single page per person, put a page =
break in the Name footer.  This will also put your overall totals on =
their own page.

I know I kind of rushed through this, so if you have more questions, =
please feel free to ask.

Thank You,
James

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Ann E Fitzmaurice
Sent: Wednesday, February 14, 2007 2:09 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] FW: access subtotals and totals :VSMail mx2




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,=20

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).
http://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
*************************************************************
This message contains information that may be confidential and is =
intended only for the use of the=20
person/persons identified and intended as the recipient. If you are not =
the intended recipient, any=20
disclosure, copying, distribution or use of this information by anyone =
else is strictly prohibited.
If you have received this in error, please contact the sender =
immediately and delete the message=20
from your computer.
*************************************************************
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).
http://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: