A CrossTab & Currancy Issue

[djclntn]

This is a CrossTab Query involving Currency.

In the Total/sum column I’m getting the totals in currency values, yet in my Months columns across the values aren’t currency. I set the Format in month columns to Currency which doesn’t help. I can’t illustrate exactly what I mean because tabs/columns never seem to work when posting.

Eg. These are ALL Columns
- TotalOfErngs $20.00
- EmployeeID (Mrk_Walker)
- Jun (I want to see $5.00) but I’m just getting 5
- Jul (I want to see $4.00) but I’m just getting 4.88
- Aug (I want to see $11.00) b ut I’m just getting wacky #

Here’s the SQL
TRANSFORM Sum([Monthly Employees Sums].SumOfErngs) AS SumOfSumOfErngs
SELECT [Monthly Employees Sums].EmployeeID, Sum([Monthly Employees Sums].SumOfErngs) AS [Total Of SumOfErngs]
FROM [Monthly Employees Sums]
GROUP BY [Monthly Employees Sums].EmployeeID


PIVOT [Monthly Employees Sums].Mnth;

[ajetrumpet]

Here’s the SQL
TRANSFORM Sum([Monthly Employees Sums].SumOfErngs) AS SumOfSumOfErngs
SELECT [Monthly Employees Sums].EmployeeID, Sum([Monthly Employees Sums].SumOfErngs) AS [Total Of SumOfErngs]
FROM [Monthly Employees Sums]
GROUP BY [Monthly Employees Sums].EmployeeID
PIVOT [Monthly Employees Sums].Mnth;

I absolutely hate crosstabs. Such easy stuff, but yet they're never worked with. So which field is it that is the issue? the "Mnth" field for pivoting, right? Try wrapping it in CCUR(). Or you can combo that with ROUND() to get a numeric with 2 dec. places.

[djclntn]

I'm sorry but I don't follow -- might you show me the SQL? Yes, the "Mnth" field is the issue.

Is using a pivoting Query, which I've never tackled before sort of like a Cross Tab Quey?e

[djclntn]

Can u show me in a sql, maybe?