Thread: text and percentages in a report
07-07-09, 13:49 #1Registered User
- Join Date
- Jul 2009
Unanswered: text and percentages in a report
I need my Access report to be able to post both a percentage and text (N/A or N/R). How can I either tell my query to convert the numbers to percentages (123.45%) AND still be ble to keep my text portion to those that do not apply such as the N/A and N/R. These will change will every report. I was thinking i could run a query that would allow me to change the text into integers, but how can I tell it to do that and drop the excess numbers after the two decimal places and have it also keep the text? Is this possible? If not in a query, is there something i could use in the Report writer that would post the data this way? The end users of this report are not very access savy and need to do as little as possible to the database after loading their data.
Last edited by gingerslovensky; 07-07-09 at 13:53.
07-07-09, 14:19 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
do a simple calcualtion
test for Non numeric values isnumeric(mycolumn) and if so don't calcuatle the percentageI'd rather be riding on the Tiger 800 or the Norton