Access report features question

[jvargas]

The database I am running this report on is not very nicely done, but i have to work with it. I have a list of records that include multiple records of a given person. All the records will be grouped by the persons name and then by a sum of an 'hours' column. At the end of each persons record, i want to sum all of the different 'hours' values. How can i do this and still use the query that shows each record i need?

Hope this isn't too confusing.

 

[bat17]

look up "Grouping Records in Reports" in help you should find what you need for this.
peter

 

[jvargas]

I think this better explains what I am looking for....

I am building a report that prints a pages for records of a single person (ie, each page only contains records for one person). Records consist of a location column with only 3 possible values. I would like my page footer to display a total of a numeric colum based on the location value. How can i keep a count of the records for each page/person?


The page looks like this:

Name - SSN
-------------------------------------
job#...hours.....location
-------------------------------------
135......22........A
130......14........A
335.......6.........B
-------------------------------------

The bottom should look like this

Total Hrs Location A: 36
Total Hrs Location B: 6
Total Hrs Location C: 0

Thanks in advance for any help!

 

[jobb]

try going to

View >> Sorting and Grouping

Group on *Name* or *SSN*

Yes for Group Header and Footer

Paste this into your Group Footer with appropriate labels
=Sum(IIf([location]="A",[SumOfHours],0))
=Sum(IIf([location]="B",[SumOfHours],0))
=Sum(IIf([location]="C",[SumOfHours],0))

Under your Footer properties, select Force New Page - After Section

 

[jvargas]

great, thatnks... it worked out. I was trying that code but it wasnt working because I was in the page footer rather than the sectional footer.

THanks!!!