Format %

I

If

Hello

With this line

Format(DCount("[Type]","Datas","[Type] like
'*100*'")/DCount("[Type]","Datas"),"Percent") AS [% Type 2],

I have the result 33,33%

How to have 33%


Thanks in advance

Yves
 
T

t t via AccessMonster.com

this is your code line

Format(DCount("[Type]","Datas","[Type] like
'*100*'")/DCount("[Type]","Datas"),"Percent") AS [% Type 2],

change "percent" as "#"&"%"

new code line

Format(DCount("[Type]","Datas","[Type] like
'*100*'")/DCount("[Type]","Datas"),"#"&"%") AS [% Type 2],

gives the result as you want...
 
M

Marshall Barton

If said:
With this line

Format(DCount("[Type]","Datas","[Type] like
'*100*'")/DCount("[Type]","Datas"),"Percent") AS [% Type 2],

I have the result 33,33%

How to have 33%
Click to expand...


This will round the value to zero decimal places:
Format( . . .,"0%")
 
I

If

----- Original Message -----
From If
, Sent 19/05/2005 22:13:
Hello

With this line

Format(DCount("[Type]","Datas","[Type] like
'*100*'")/DCount("[Type]","Datas"),"Percent") AS [% Type 2],

I have the result 33,33%

How to have 33%


Thanks in advance

Yves
Click to expand...


Thanks for your help
 
Top