RE: Running Total

Hi

[X] and [Y] are already in the table. Add these to the report where you
need them and add an unbound textbox also to the report ( [Z] ). Use
=[Y]+[Y] as the control source for this.
Or
[X] and [Y] are already in the table. Add a calculated coloum to the query
Z:[Y]+[Y] and run the report from this query includeing [Z] where you need it

Hope this helps

--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo :-)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.



"Chipmunk" wrote:

How do I add Z to the quiery if I can't add it to the Table? I can add X & Y
to the quiery because I can pull that from the table but I don't see how to
add the Z to the quiery?

Thanks

"Klatuu" wrote:

You should not store z in a table. If you want to present it in a report,
you do the calculation there. Calculated values should not be stored in
tables. They waste space, take more time, and are likely to become
inaccurate. You can also present it on a form the same way; however, z
should be in an unbound control that is NOT saved it a table, it is only
there for the user's convenience.

Me.txtTot = Me.txtY + Me.txtZ

"Chipmunk" wrote:

Hello, my question is how can I automatically populate a few different
fields. Let me better explain by example:

i have a field (X) that is multiplied by anothyer field (Y) and I want it to
automatically give the answer for (Z) and Z should be kept in a table for a
report.

So someone enters in (X) and then (Y) and Z is automatically calculated.

I don't know how to start, do I need a quiery? or can I do this right from
the form? Thank You.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=6a3b35dd-cafc-4eac-a762-7ef2dfbb3258&dg=microsoft.public.access.gettingstarted
.