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

you're welcome, David, and thank you ;) happy to help

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Sun, 8/28/11, David Tolson wrote:

> 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: Crystal
>
> 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
> >
> >
>