1) Sum of Calculated Cost 2) Dollar Sign/Decimals?

[Heatshiver]

I have a report where there is a cost calculated from price multiplied against quantity. This expression works perfect.

1) I am trying to sum the total of all the costs on the report as there are multiple items with varying costs.

a. I thought that I could at first place it in the query that populates the record, but I can't use the cost box as it is not a field in the table.

b. I then thought I could add it to the table as a calculated field, but I cannot use the cost box there since it does not already exist in the table (and I can't seem to use the Sum function for the calculation...?).

c. I tried to add a box to the report that had the expression "=Sum([Cost])" as I named the cost box "Cost". But this did nothing when I previewed the report.

What am I doing wrong, and how should I go about this? I thought this would be so much easier.

2) I also can't seem to get a dollar sign ($) or decimal places for my cost.

a. I thought that maybe I could use an Input Mask, but there is nothing preset for currency, just dates and telephone numbers.

b. I tried to add a box with just a $ sign in it, but it acts as code and hinders the report from working.



Is there a simple way that I can show the dollar sign along with commas and decimals on my report?

Sorry for the hassle as I'm sure this is simple and I'm overlooking some item. Thank you for the help!

[bcofie]

To solve (2), go in design view, double click control with cost to open up properties and format as currency.
To solve (1), in design view, use "Total" in the Groupings & Totals ribbon.

[Heatshiver]

@bcofie Thank you so much! I knew the 2nd one was something easy.

As for the 1st one, when I click on Total, it only allows for "Count Records" as an option, I can't seem to total all the amounts for my cost box.

[Heatshiver]

I think I got the first part working. Building on =SUM([Cost]), I realized that I could just instead put in the calculation of cost rather than use its name: =SUM([Sum of Quantity]*[Price])

This seems to be working. Thanks for the help!