Type Mismatch in Expression

[MTSPEER]

HI,

Im trying to make a query so that I can view certain fields accross 3 tables. And I get the expression "Type Mismatch in Expression". I thought it was because my one ID Number is a text datatype. SO when I tried to fix it(change it to number) it said "you are switching to a smaller datatype and information may get lost" so then i hit continue, and it says all my records in that field would get deleted? HELP

[Dal Jeanis]

Please post the original query, that gave you the type mismatch.

[euanl]

I assume you mean that you have a text field that you are trying to link to a numeric field in a query. Can you change the numeric one to text? You would not lose data as long as the text size is larger than the largest number.

[June7]

The warning means data MIGHT be lost. If the text field really has only numbers then converting to number type should not be an issue. Make a copy of table and test.