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

Converting text to display as currency in Report

P: 15
I have based a report on a crosstab query. This query has eliminated all formats, i.e. all fields including those containing numbers are now stored as text.

Is there a way that i can get Access to reformat these 'text' fields as currency or standard 1,234,567 notation on the final report?

Thanks.
Oct 26 '06 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,343
Either code in the TextBoxes of the Report as
Expand|Select|Wrap|Line Numbers
  1. =Format(Val([FieldName]),"#,##0.00")
or, possibly neater, create a query using the results of the CrossTab Query and create fields in the form
Expand|Select|Wrap|Line Numbers
  1. Val(qryCrossTab.FieldName) AS FieldName
The results of such a query would be able to be used in the normal way in your report.
Oct 26 '06 #2

pks00
Expert 100+
P: 280
Try formatting the field using Currency
e.g.

Format(myfield,"Currency")
Oct 26 '06 #3

P: 15
Either code in the TextBoxes of the Report as
Expand|Select|Wrap|Line Numbers
  1. =Format(Val([FieldName]),"#,##0.00")
or, possibly neater, create a query using the results of the CrossTab Query and create fields in the form
Expand|Select|Wrap|Line Numbers
  1. Val(qryCrossTab.FieldName) AS FieldName
The results of such a query would be able to be used in the normal way in your report.
Hi NeoPa,

If I was using your first suggestion (i.e. code in the TextBoxes of the Report as
[code]=Format(Val([FieldName]),"#,##0.00"), where/how do i input this code?

Thanks.
Nov 10 '06 #4

NeoPa
Expert Mod 15k+
P: 31,343
When you're designing your report, there are TextBoxes that display all the data - in the detail section.
Copy and Paste this (including the '=') into the 'Control Source' property (of the TextBox you want to display the value).
Nov 10 '06 #5

Post your reply

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