Format number as text

  • Thread starter Thread starter JeffH
  • Start date Start date
J

JeffH

I'm attempting to append a number in one table to a text field in another.
Is there any way in which I can format the number in the query so I don't get
the mismatch error?
 

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

change a text format to number format 6
Data Mismatch in Excel 2010 4
text conversion to number on select query 5
External field in a query 5
Query - Convery Text to Number in a group by 3
Number Format in Chart Datasheet 1
Access 2000 Question 1
Link Tables 5

Back
Top