assuring 2 zeros after decimal point 1

[guyphil]

Hi,

If I have the number "1.00" in a database (Data Type:Number)

How do I have show up as "1.00" on a web page and not "1"

Ive tried changing the different parameters in Access(Field Size, Format, Position) but nothing has worked yet.

Can this even be done through Access or will I have to add the zero's to the end of the string in ASP?

Thanks,

GuyPhil

 

[ChrisHirst]

FormatNumber(Number,2)

FormatNumber



Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[guyphil]

Thanks Chris!

 

[guyphil]

BTW,

How would I implement this in the following:

<%= rs.(FormatNumber(Fields("MyNum").Value),4)%>--This doesn't work.

<%= rs.(Fields(FormatNumber("MyNum"),4).Value%>-- Neither does this.


Thanks

Guyphil

 

[ChrisHirst]

it's in the wrong order. you need to format the value of the field in the recordset.

FormatNumber(rs.fields("column"),4)



Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[guyphil]

It works now, Thank you.


Guyphil