Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    29

    Unanswered: Type Mismatch in Expression

    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

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    It would be easier to help you if you would post the SQL expression of the query as well as relevant information about the table(s).
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •