ACCESS FEED: RE: [MS_AccessPros] Trying to add two calculated fields in a form

Minggu, 28 Agustus 2011

RE: [MS_AccessPros] Trying to add two calculated fields in a form

Thanks Crystal, I just love it when I understand what the experts say and I
get it to work the first time J. Have a great day today and an even finer
one tomorrow.

r/David

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Sunday, August 28, 2011 5:59 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Trying to add two calculated fields in a form

don't put Format in the ControlSource* -- it converts to a string. Instead,
set the Format property for the control (right-click in design view, choose
Properties)

* RecordSource is the source of records for a form or report

warm regards,
Crystal

* have an awesome day :)

--- On Sun, 8/28/11, djsdaddy531 wrote:

> Great Day, I have a subform that adds
> auto parts to a particular repair. I placed a text box
> (txtPartsSubTotal) in the footer of the subform. the record
> source for txtPartsSubTotal is
>
> =Format(Sum([PartTotal]),"$#,###.00")
>
> PartTotal is a field in the table that permits the user to
> enter the price of a particular part.
>
> Then I add sales tax with the following line in the record
> source:
>
> =Format(([txtPartsSubTotal]*0.06),"$#,###.00")
>
> After this I want the form to add the two fields to give
> the grand total in a field named txtPartsTotalCost, and the
> Record source is
>
> =Format(([txtPartsSubTotal]+[txtPartsSalesTax]),"$#,###.00")
>
> this code treats txtPartsSubTotal and txtPartsSalesTax like
> a string and simply connects the two numbers into a string.
> I have formatted both text boxes to Currency.
>
> thanks in advance
>
>

[Non-text portions of this message have been removed]