Join text & numeric field in query without losing decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Can you post the SQL you are using?
Did you converted the number to Long, clng([fieldName]) that will remove the
decimal places.
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Number to Number "Data Type Mismatch in Expression" in Join 1
Format query result as Data Type Number, Field Size Decimal 3
Decimal places in calculated fields 6
convert per cent text to number 6
Decimal Field's Precision Too Small to accept the numeric you ... 3
How do I get Access to append the exact amount with decimals? 2
How to Reduce Decimal Places? 2

Back
Top