By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 2,203 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Using a Query field in a form

P: n/a
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

Aug 30 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Aug 30, 4:00 pm, sbit...@gmail.com 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.

Aug 31 '07 #2

P: n/a
On Aug 30, 4:00 pm, sbit...@gmail.com 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).

Aug 31 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.