formatting in query

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,
 
K

Ken Snell

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