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.
 
Back
Top