Hi David,
try using the fieldname in your equation instead of the controlname (txtNoCharge). Best if the field is in a control on the report in the detail section even if Visible is No.
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: David Tolson <drtolson@verizon.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, December 1, 2011 8:52 AM
Subject: RE: [MS_AccessPros] How to display figures from a subreport to the report
Thanks John, this is what I placed in the report footer of the subreport:
=Sum(IIf([txtNoCharge],[WorkRequestedCost],0))
And "txtNoCharge" is the Yes/No field (forgive my poor naming convention
here); and "Requested Cost" is the field where the cost of the service is
stored, but when I open the report I am prompted to give a value for
"txtNoCharge"
r/David
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Thursday, December 01, 2011 10:27 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] How to display figures from a subreport to the
report
David-
A text box in the Report Footer of the subreport like this:
=Sum(IIf([txtNoCharge], [Cost], 0))
.. should give you the sum of the items not charged. Of course, you'll have
to
provide the correct name of the field that contains the cost.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of David
Tolson
Sent: Thursday, December 01, 2011 4:17 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] How to display figures from a subreport to the
report
Great Day, I have an Report that prints an invoice, and the Report has a
subreport that displays repair items and costs. There could be more than
one repair item with the associated cost, and then I sum the total of all
repair items. There may be an instance where one (or more) of the repair
items is marked as "N/C" for No Charge. There is a Yes/No field that marks a
repair item as N/C in the form that creates the repair order (Invoice). I
load that field in the report as unseen, and I have a text box next to the
cost of the repair item that says..
=IIf([txtNoCharge]=-1,"N/C"," ")
Now jumping back to the report, I show the totals of the repair service:
Cost of Labor
Cost of Parts
Tax
Misc.
Total cost of job (adds to above)
What I would like to do is add a field after Misc. that sums all of the
fields in the subreport where the service item was provided at no charge,
and this figure will be subtracted from the other costs to show the
discount. It would seem that I could filter the form to sum only NoCharge
items, but the form is already filtered for RepairItems.
Any suggestions will be greatly appreciated.
r/David
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar