Sum in Crosstab Quesry or Report

[Regi]

I have a Table that I used to create a Crosstabe Query.

Table Ex: Job# Task Suffix Amount
A028 01A 40 100.00
A028 01A 41 350.00
A028 02B 43 225.00

In the Crosstab Query the Suffix is a Column heading that has 5 columns.

Ex: Job# Task 40 41 43 44 45
46
A028 01A 100.00
A028 01A 350.00
A028 02B 225.00

I entered a an expression to take care of the Null Values, and make it into
currency.

I can't get a total of the amounts in the Suffix Columns (40, 41 etc) to
work in the query.( I get parameter prompts) I was able to get it to work in
the report. Is that the best way to go in this case?

I'm self taught, Thanks

 

[Duane Hookom]

Please share your SQL view. I can't understand what you mean by not getting
something to work in a query by getting it to work in a report.