Results 1 to 4 of 4
  1. #1
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58

    mismatch error

    I have a query as below. Both SOLSONO and SOLLINE in each table are data type number, but I get the data mismatch error.



    This is the SQL from the query.

    SELECT tblPrintedJobsheets.SOLSONO, tblPrintedJobsheets.SOLLINE, tblPrintedJobsheets.SOHCREF, tblPrintedJobsheets.SOLCUSC, tblPrintedJobsheets.SOLBAL, tblPrintedJobsheets.SOLDATO, tblPrintedJobsheets.PTM1CD, tblPrintedJobsheets.JOBPRINTEDFROM tblPrintedJobsheets, tblSalesOrderRptNo
    WHERE (((tblPrintedJobsheets.SOLSONO)=[tblSalesOrderRptNo].[SOLSONO]) AND ((tblPrintedJobsheets.SOLLINE)=[tblSalesOrderRptNo].[SOLLINE]));

    Cheers

    Bill
    Attached Thumbnails Attached Thumbnails access error.png  

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    are they both the same type of number? long/integer/double etc?

    Why not just join the two tables on the two fields?

    But looks like your error is referring to a different object, not this query

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi
    Can you upload your database?
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    An observation from your graphic ---Every table should have a primary key. I agree with ajax's questions.
    Readers need to see the table designs and a description of what you are trying to do.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 07-24-2013, 02:01 PM
  2. Error: Run-time error '13' Type mismatch
    By uronmapu in forum Access
    Replies: 1
    Last Post: 09-07-2012, 05:38 AM
  3. type mismatch error 13
    By Compufreak in forum Access
    Replies: 3
    Last Post: 08-10-2012, 03:48 AM
  4. Replies: 1
    Last Post: 05-11-2012, 10:59 AM
  5. Error 13 Type Mismatch error
    By GlennBurg in forum Programming
    Replies: 1
    Last Post: 06-21-2011, 03:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums