Format %

  • Thread starter Thread starter If
  • Start date Start date
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
 
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...
 
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%")
 
----- 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
 
Back
Top