convert to percentage

[psimon88]

Hello

I am having a problem with the following:

SELECT date, contacts, [contact pct], sales, elig, [elig pct], telco, badphone, fedex, inelig, dials, [sales pct], [fedex pct], [bad phone pct], [telco err pct]
FROM dbo.qry_8_master

I'd like the [contact pct] field to have two decimal points only. I tried left([contact pct]),4 but that didn't work.

Thanks. ADP in Access 2003.

ps

 

[Golom]

What's the data type of [contact pct]?

if it's a numeric type then

Val ( Format ( [contact pct], "0.00" ) ) should do it.

 

[psimon88]

Thanks, but 'format' was not a recognized function name.

 

[psimon88]

Yes, that works in an MDB file.

Expr1: Val(Format([calc1],"Fixed"))

Unfortunately, I was working with an ADP.