Using a Query field in a form

[sbitaxi]

I have a query that performs a simple sum, a running total
essentially. I want to be able to use that in a calculation in a form
but I can't seem to get it to display anything beyond #Name?

Structure -

Table A feeds the primary form, recording particulars about a mailing
and calculating costs
Table B feeds a sub-form, line items to track individual expenses in
the mailing

Table B query sums the expenses based on their relationship to the
records in Table A

I want to use that sum in the primary form on a few other
calculations, for example adding it to the total costs of the other
expenses and dividing it by the number of recipients for a mailing to
provide a per-package cost.
Can someone advise me on the best method of doing this? I understand
that this is likely not a new problem or revolutionary, but I am
teaching myself Access and am having trouble determining what exactly
to search for in groups.
Thank you!

Steven

[OldPro]

On Aug 30, 4:00 pm, [e-mail] wrote:

I have a query that performs a simple sum, a running total
essentially. I want to be able to use that in a calculation in a form
but I can't seem to get it to display anything beyond #Name?

Structure -

Table A feeds the primary form, recording particulars about a mailing
and calculating costs
Table B feeds a sub-form, line items to track individual expenses in
the mailing

Table B query sums the expenses based on their relationship to the
records in Table A

I want to use that sum in the primary form on a few other
calculations, for example adding it to the total costs of the other
expenses and dividing it by the number of recipients for a mailing to
provide a per-package cost.

Can someone advise me on the best method of doing this? I understand
that this is likely not a new problem or revolutionary, but I am
teaching myself Access and am having trouble determining what exactly
to search for in groups.

Thank you!

Steven

You haven't included your query, or a detailed description of your
table structure, so the best I can do is recommend that you test the
query out as an actual query first, before assigning it to a screen
control.

[OldPro]

On Aug 30, 4:00 pm, [e-mail] wrote:

I have a query that performs a simple sum, a running total
essentially. I want to be able to use that in a calculation in a form
but I can't seem to get it to display anything beyond #Name?

Structure -

Table A feeds the primary form, recording particulars about a mailing
and calculating costs
Table B feeds a sub-form, line items to track individual expenses in
the mailing

Table B query sums the expenses based on their relationship to the
records in Table A

I want to use that sum in the primary form on a few other
calculations, for example adding it to the total costs of the other
expenses and dividing it by the number of recipients for a mailing to
provide a per-package cost.

Can someone advise me on the best method of doing this? I understand
that this is likely not a new problem or revolutionary, but I am
teaching myself Access and am having trouble determining what exactly
to search for in groups.

Thank you!

Steven

BTW, since you are new, you may not know that DLOOKUP( ) does the same
thing (a little slower though).