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 *************************************************************