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!

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.
-- 
KARL DEWEY
Build a little - Test a little


"Golfinray" wrote:

> 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!

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 
on the report? Thanks!

"KARL DEWEY" wrote:

> 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.
> -- 
> KARL DEWEY
> Build a little - Test a little
> 
> 
> "Golfinray" wrote:
> 
> > 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!

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


"Golfinray" wrote:

> 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 
> on the report? Thanks!
> 
> "KARL DEWEY" wrote:
> 
> > 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.
> > -- 
> > KARL DEWEY
> > Build a little - Test a little
> > 
> > 
> > "Golfinray" wrote:
> > 
> > > 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!

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

"KARL DEWEY" wrote:

> Or you can use this --
>    My Percent: [YourField] & " %"
> -- 
> KARL DEWEY
> Build a little - Test a little
> 
> 
> "Golfinray" wrote:
> 
> > 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 
> > on the report? Thanks!
> > 
> > "KARL DEWEY" wrote:
> > 
> > > 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.
> > > -- 
> > > KARL DEWEY
> > > Build a little - Test a little
> > > 
> > > 
> > > "Golfinray" wrote:
> > > 
> > > > 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!

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





"Golfinray" <Golfinray@discussions.microsoft.com> wrote in message 
news:15D44EFF-AF3C-44C5-B724-F4E80EA4661F@microsoft.com...
> 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
> on the report? Thanks!
>
> "KARL DEWEY" wrote:
>
>> 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.
>> -- 
>> KARL DEWEY
>> Build a little - Test a little
>>
>>
>> "Golfinray" wrote:
>>
>> > 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!