Results 1 to 3 of 3
  1. #1
    shexe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    71

    Data type mismatch in criteria expression

    Hello, looking for some insight to an error I receive after updating an existing query for 2011.



    The query is cumbersome and used to generate an excel report through a data connection. With that said, I only had to update the qry with new Tables(table_2011) and queries(qry_2011). The existing 2010 query works just fine and I have updated other, similarly complex queries without issue.

    How is it that a simple update is prompting this error?

    Please feel free to ask questions for further clarification.

    Thanks everyone.

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Perhaps one of the fields in your new table is not formatted properly. For example, a field of dates formatted as text.

    Cheers,

  3. #3
    shexe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    71
    Thanks - would have been my last resort to look at format.

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

Similar Threads

  1. Type mismatch
    By jgelpi16 in forum Programming
    Replies: 1
    Last Post: 08-07-2010, 06:54 AM
  2. data type mismatch
    By jgelpi16 in forum Programming
    Replies: 5
    Last Post: 08-02-2010, 04:15 PM
  3. Type mismatch in expression /Query
    By Brian62 in forum Queries
    Replies: 4
    Last Post: 04-22-2010, 10:00 AM
  4. Replies: 4
    Last Post: 10-26-2009, 05:27 AM
  5. Type Mismatch - HELP!
    By jgelpi in forum Programming
    Replies: 3
    Last Post: 07-17-2009, 03:53 PM

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