Addition of two fields in the same record

  • Thread starter Thread starter JPR
  • Start date Start date
J

JPR

I am trying to add service1cost and service2cost, which are two currency
fields in my database.

The field in my report is total.

to do this I have used the =service1cost+service2cost parameter, but the
total is not expressesd in dollars and cents.

How do I get Access to do the math and express it for me?

Any help is appreciated.

Jeff
 
JPR said:
I am trying to add service1cost and service2cost, which are two currency
fields in my database.

The field in my report is total.

to do this I have used the =service1cost+service2cost parameter, but the
total is not expressesd in dollars and cents.

How do I get Access to do the math and express it for me?
Click to expand...


That looks like a vaild expression and Access should do the
math. To format it as currency, set the text box's Format
property to Currency.

Are you sure the fields are included in the report's record
source table/query??
 
Back
Top