Thank you for the insight Duane.
Have a great day,
Sincerely,
David
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Thursday, December 01, 2011 11:43 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] How to display figures from a subreport to the
report
Usually when you see this type of prompt it is because txtNoCharge is a
control in another section of the report and is not a field name in the
report's (subreport's) record source. I have never been prompted for a field
name from the Record Source. There is an issue attempting to use a field in
the report's code if the field isn't bound to a control.
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: drtolson@verizon.net
Date: Thu, 1 Dec 2011 10:52:03 -0500
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]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar