Format %

[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 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...

 

[Marshall Barton]

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%

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

 

[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

Thanks for your help