Hi Graham,
Thank you! That worked perfectly!!
Deb
On Sun, Sep 4, 2011 at 4:36 PM, Graham Mandeno <graham@mandeno.com> wrote:
> 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
>
>
[Non-text portions of this message have been removed]
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