Addition of two fields in the same record

[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

 

[Marshall Barton]

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?

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??