By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

TRANSFORM (Crosstab) Query

P: 16
Hi I am having the following problem I a running a query off a table. I am using the following sql code

Expand|Select|Wrap|Line Numbers
  1. TRANSFORM Sum([Intake Branch Banking and BAS].loanamount/1000000) AS SumOfloanamount
  2. SELECT [Intake Branch Banking and BAS].Region
  3. FROM [Intake Branch Banking and BAS]
  4. GROUP BY [Intake Branch Banking and BAS].Region
  5. PIVOT [Intake Branch Banking and BAS].measure;
When i run this I lose the decimal Places and the Currency Indicator (R) Rands in the loanamount column which is in the table.Need Zero decimal places

Eg it brings up 18.47 instread of R18

What am i doing wrong

Thanks for your assistance
Oct 5 '07 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,488
I'm afraid I don't know David.
What I can do though is change the title of the thread to better match the question, then those members with that experience will find it.
Oct 5 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Try this ...

Expand|Select|Wrap|Line Numbers
  1. TRANSFORM Sum(Format([Intake Branch Banking and BAS].loanamount/1000000, "R###,##0")) AS SumOfloanamount
  2. SELECT [Intake Branch Banking and BAS].Region
  3. FROM [Intake Branch Banking and BAS]
  4. GROUP BY [Intake Branch Banking and BAS].Region
  5. PIVOT [Intake Branch Banking and BAS].measure;
  6.  
Oct 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.