concantinate number with decimal places

D

deb

TL: [TLNoPrefix] & "-" & [TLNo] is a field in my query.

TLNoPrefix is text and TLNo is a number.
How can I show TLNo with 4 decimal places?
 
J

Jerry Whittle

TL: [TLNoPrefix] & "-" & Format([TLNo], "0.0000")

However if TLNo has more than 4 decimal places, it might get rounded up or
down.
 
B

Brendan Reynolds

deb said:
TL: [TLNoPrefix] & "-" & [TLNo] is a field in my query.

TLNoPrefix is text and TLNo is a number.
How can I show TLNo with 4 decimal places?
Click to expand...


The Format$() function should do it. Something like ...

TL:[TlNoPrefix] & "-" & Format$([TlNo], "0.0000")
 
Top