formatting in query

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hi. I am not sure of the syntax so here it goes.
I have a query that pulls data from a table. The data is
in text format. Another query pulls data from a diff
table that is numeric. I want to do a FindUnmatched query
but keep getting 'type mismatch error'. How can I change
the data in that text field to numeric during the query
operation? The data in the text field is numeric, so it
shouldn't affect it when converted or formatted.

Thanks,
 
Sure that the text data can/should be made numeric? Why not be safer and
make the number data text? Just change the query that has the numeric data
to use a calculated field instead of the numeric field:

TextNumber: Format([NumericField], "@")

Then join the first query to the second on this calculated field.
 

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

Can rich text format (memo) carry over in a make table query? 1
Format DATETIME to Date in query on linked table 4
Format query result as Data Type Number, Field Size Decimal 3
Query field size quandry 2
Combine Duplicates in Query 0
Append Query not pulling all Data from spreadsheet 2
Control Select Query Output Field Type 8
Number to Number "Data Type Mismatch in Expression" in Join 1

Back
Top