Join text & numeric field in query without losing decimal places

B

barbiegril

I've been trying to join a text field & numberic field in a query, but every
thing I try I lose the decimal places. Can anyone help?
 
O

Ofer

Can you post the SQL you are using?
Did you converted the number to Long, clng([fieldName]) that will remove the
decimal places.
 
F

fredg

I've been trying to join a text field & numberic field in a query, but every
thing I try I lose the decimal places. Can anyone help?
Click to expand...

Combined:[TextField] & " " & Format([Numberfield],"#,#0.00")
 
Top