Minggu, 04 September 2011

RE: [MS_AccessPros] Retrieving data from a calculated control to another form.

 

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

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.
.

__,_._,___

Tidak ada komentar:

Posting Komentar