Results 1 to 2 of 2
  1. #1
    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.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    do a simple calcualtion
    test for Non numeric values isnumeric(mycolumn) and if so don't calcuatle the percentage
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts