Percent Sign

[Golfinray]

In a query, how do I get a percent sign to appear after a number. I have a
column of numbers and would like percent signs after each number. Thanks!

 

[KARL DEWEY]

If the number is a percent then in design view click at the top of the field
in the grid to highlight the column. Click on menu VIEW - Properties. In
Format enter 'Percent' without quotes.

NOTE - Remember that a percent is a decimal fraction of a whole so if you
are now displaying 55 then adding percent format will display 5500%.

Also not that format is just for display and will not carry into a form or
report.

 

[Golfinray]

Thanks! I have already multiplied the decimal x 100 and used md function to
cut off some of the decimals I did't want. (ie, 12.3784565859 I cut down to
12.378 and then used ROUND function to get 12.38). I would just like to put a
percent sign after the number. I do have to have the percent show on a
report. If I just go back and change the format of the decimal, will it show

 

[KARL DEWEY]

Or you can use this --
My Percent: [YourField] & " %"

 

[Golfinray]

Thanks, Karl, that worked like a champ! Golfinray, aka Milton Purdy,
decidedly poor state employee.

Or you can use this --
My Percent: [YourField] & " %"
--
KARL DEWEY
Build a little - Test a little

Thanks! I have already multiplied the decimal x 100 and used md function to
cut off some of the decimals I did't want. (ie, 12.3784565859 I cut down to
12.378 and then used ROUND function to get 12.38). I would just like to put a
percent sign after the number. I do have to have the percent show on a
report. If I just go back and change the format of the decimal, will it show

 

[Conan Kelly]

Golfinray,

You seem to be doing more work than necessary. You mention that multiplied
by 100, used md function (I'm assuming you meant MID() function), used Round
function.

In your example (12.3784565859), is that the value before or after
multiplying by 100? Is the original value 0.123784565859? I would just
format that as a percent. It looks like Access's Percent format defaults to
2 decimal places (but it can be set to any number), so 0.123784565859 would
DISPLAY AS 12.38 % (I say DISPLAY AS because it will show 12.38 %, but the
value will still be 0.123784565859).

If, for some reason, you need the value rounded, then I would just use
ROUND([PercentField],4) or ROUND(0.123784565859,4) and then format as a
percent.
0.123784565859 would become...
0.1238 when rounded to 4 places, which would display as...
12.38 % when formatted as a percent.

If you are using MID() to cut off extra decimal places, that just seems like
an unnecessary step.

If you need this stuff in the report only and not in the query, then you
could use the round function in the query, if needed, and then format the
control on the report as a percent with 2 decimal places.

HTH,

Conan