Prev: produce random results in a report
Next: prient preview okay but actual printing causes #name? error
From: Caryn on 15 Dec 2009 13:00
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?
From: golfinray on 15 Dec 2009 13:49
Sum it in the footer.
controlsource=sum([patient])
--
Milton Purdy
ACCESS
State of Arkansas


"Caryn" wrote:

> 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?
From: Caryn on 15 Dec 2009 14:49
It didn't work. It's still mutiplying the fee against the dependants instead
of the patient.

"golfinray" wrote:

> Sum it in the footer.
> controlsource=sum([patient])
> --
> Milton Purdy
> ACCESS
> State of Arkansas
>
>
> "Caryn" wrote:
>
> > 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?
From: Duane Hookom on 15 Dec 2009 18:11
If your report displays only a single patient then you just bind the field to
a text box with no summing. If you need to sum multiple values from a "group"
of records, I would suggest you create a query that sums the value by group
and then add the totals query to the report's record source query.

--
Duane Hookom
Microsoft Access MVP


"Caryn" wrote:

> 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?
From: Jeff Boyce on 15 Dec 2009 19:52
Please post the SQL statement you are using to "feed" your report.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"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?


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