Hi Deb
You can't use aggregate functions like Sum() on *controls*. You can only
use *fields* (or expressions based on fields).
So, this should work:
=Sum([Quantity]*[Unit_Price])
A better solution would be to add Part_Cost as a calculated field to the
query on which your form is based. Then you can treat it like any other
field (except editing it of course!) - you can bind it to your Part_Cost
textbox and use it in your =Sum([Part_Cost]) expression. It will also avoid
the annoying behaviour of slowing down the painting of your continuous form.
Best wishes,
Graham
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Deb
Sent: Monday, 5 September 2011 10:09
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Retrieving data from a calculated control to
another form.
Thanks Crystal! Another quick question on controls and expressions...
I have a calculated control - Part_Cost, which is -
=[Quantity]*[Unit_Price]
In the footer of the subform I put a new control - Total_Cost
=Sum([Part_Cost])
Essentially I want it to total the Parts Costs for each line.
It's not working, so more than likely I am missing something!
Thanks!
Deb
Minggu, 04 September 2011
RE: [MS_AccessPros] Retrieving data from a calculated control to another form.
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar