Results 1 to 2 of 2
  1. #1
    MdHaziq is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    Singapore
    Posts
    124

    Type Expression Missmatch

    Hello Forum.



    I am trying to immitate template Inventory 2007.

    I am currently using Microsoft Access 2016 for this database.


    When I try to open Inventory Transactions Extended Query I get a warning saying Expression Type Missmatch.

    I check my Actual Quantity but I cannot find the problem.

    Can someone debug for me please?

    TIA

    Haziq
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Type Missmatch. means: the 2 field types do not match....
    1 is a string..( Inventory Transactions.Transaction Item)
    1 is a number.

    they both must be the same.

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

Similar Threads

  1. Error 13 (Type Missmatch) problem
    By sdel_nevo in forum Programming
    Replies: 4
    Last Post: 01-31-2016, 06:54 AM
  2. Type Mismatch in Expression
    By MTSPEER in forum Queries
    Replies: 3
    Last Post: 06-12-2013, 04:29 AM
  3. Replies: 3
    Last Post: 11-19-2012, 11:55 AM
  4. Type mismatch in expression
    By valerie in forum Forms
    Replies: 1
    Last Post: 03-13-2012, 06:23 PM
  5. type mismatch in expression
    By lilg1924 in forum Database Design
    Replies: 3
    Last Post: 10-06-2010, 01:37 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