Format subquery as percent

[shift2076]

hi all,

i normally just go into design view in my query to change the format type, but some of my subqueries are quite large, so i'm getting 'the expression exceeds the 1,024 character limit for the query design grid.

i figured i could just multiply the subquery by 100, but the results are still calculated out to about ten decimal places.

so... how do i format a subquery directly in sql to be a percentage with two decimal places?

thank you,
mj

 

[shift2076]

ok...

i've been through access 2000's useless help index twice now. i've also spent over three hours looking for a solution online. i'm all googled out. there has to be a solution somewhere.

someone please help!!!

mj

 

[shift2076]

solution found!

for anyone who is facing the same problem, it is very easy -

Format(Insert your subquery here), "Percent")AS NameOfSubQuery

too easy.

mj