Prev: produce random results in a report
Next: prient preview okay but actual printing causes #name? error
From: Adam Simpson on 17 Dec 2009 08:45
You could put a new text box called RS in the the patient header section of
the report and make it a running summ and make it =Fee. Then in the report
footer put a text box called say RST and make the control source =RS. Then
in the report header the controle source of your total field should be =RST.

Alternatively you could create a second query that just summs the fees for
the patients and reference that in the report header. This could be a DSum
if the criteria needed are simple.

Adam

"Caryn" <Caryn(a)discussions.microsoft.com> wrote in message
news:29464B47-1A09-4488-A613-0A251D83DEE3(a)microsoft.com...
>I have a database with a few relationships in it. The patient and their
> dependants are in two separate tables and a rate of Fee is in another. I
> have a report which lists the patient and fee with their dependants listed
> underneath. However, when try to put a sum field in the report header it
> adds the fee for each dependant. How do set it up to add the fee once per
> patient?


First  |  Prev  | 
Pages: 1 2
Prev: produce random results in a report
Next: prient preview okay but actual printing causes #name? error