Results 1 to 3 of 3
  1. #1
    elb1999 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    4

    Data Type mismatch in criteria expression

    I have an update query that is giving me the error message in the thread title. I know what field the error is occuring in. The field in the table to be updated has a "text" data type. The criteria I'm using for the field in the update query is as follows: Like "2011A*", becasue I only want to update different types of 2011 Actual data in that field.

    I don't want to change the data type for the field in the base table because it is linked to to many other tables and queries in the database and I fear that messing with it will screw up abunch of other relationships.

    Can anyone help

  2. #2
    elb1999 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    4
    Here is the SQL view of the query

    UPDATE [400_Base Financial Data] SET [400_Base Financial Data].[Business Rule Name] = "Remove FY11 costs not in SMU 908303 - France", [400_Base Financial Data].[Rule Type] = "Country Specific Removal", [400_Base Financial Data].[gHR Location] = ""
    WHERE ((([400_Base Financial Data].[Rule Type])<>"Non Real Estate Cost" Or ([400_Base Financial Data].[Rule Type])<>"") AND (([400_Base Financial Data].Scenario) Like "2011*") AND (([400_Base Financial Data].Country)="France") AND (([400_Base Financial Data].Product)<>"908303"));

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I was just typing in a post to ask for the SQL and there it is!!!

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

Similar Threads

  1. Data type mismatch in criteria expression
    By buienxg in forum Access
    Replies: 2
    Last Post: 11-22-2011, 10:29 AM
  2. Replies: 2
    Last Post: 05-17-2011, 02:40 PM
  3. Data type mismatch in criteria expression
    By Douglasrac in forum Forms
    Replies: 3
    Last Post: 11-23-2010, 10:46 AM
  4. data type mismatch in criteria expression
    By broecher in forum Access
    Replies: 4
    Last Post: 09-10-2010, 08:29 AM
  5. Data type mismatch in criteria expression
    By shexe in forum Queries
    Replies: 2
    Last Post: 09-01-2010, 12:47 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