Totalling quandry

[benniesanders]

Hi there,

I have a report based on a query. The report is grouped by job #. The query is one table and one query, the table has all of the job info and query is the grouped tasks and hours spent on those tasks. I need a total of those hours by job # on the report but have tried and tried and can't figure out how. If I do a text box with =sum([hours]) in the job # footer, I only get the first hours of the first task instead of the sum of all of the task hours for that job #. I'm just stumped. Any ideas would be greatly appreciated. Is there a way to write a query to sum the hours by job # and base the text box on that? Thanks!

 

[CosmoKramer]

Bennie,

Based on what you said, it should be working. Can you send me a zipped copy of your db so I can take a look at it??

sw3540@yahoo.com

 

[benniesanders]

Thanks Cosmo. It's huge with 115 meg of linked tables. I'll try to condense it and send it your way. Thanks again.

 

[benniesanders]

Hello Cosmo,

I worked with it some more and voila, it's working properly now. I don't know what happens from one day to the next with Access sometimes, but I'll swear I did the same thing yesterday that I tried today and it's working now. Thanks for your offer of help.