concantinate number with decimal places

[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?

 

[Jerry Whittle]

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

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

 

[Brendan Reynolds]

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?

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

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