page footer totals & grouping

[may1hem]

I have a database which shows our company's clients and jobs done for those clients. So there are 3 tables:
Clients---[1-many]---Callouts---[1-many]---Jobs.
To make it clear, a client can call our company for several jobs to be done in 1 callout.

I need a report that shows jobs for each client. I need each client's jobs to be displayed on a separate page, so that this report can be printed directly onto our company's invoice paper.

I grouped by the client's Address, and in the 'ADDRESS footer' I set the 'Force New Page' property to 'After Section'. This does pretty much what I need.

The problem comes when I try to sum the cost of the jobs for each client.

I use this formula: =Sum([NetCost])

Placing this formula in the 'ADDRESS footer' does give the correct answer, but the position of this sum does not always print out in the same place on the invoice paper. It depends on how many works there are.

So I tried to place the formula in the 'Page Footer' but it just give me '#Error' when I view the report.

Any ideas on how to get the sum to appear on the same place on every page?

Thanks!

May

 

[CosmoKramer]

May,

Check out this thread:

thread703-326104