Results 1 to 5 of 5
  1. #1
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147

    Type mismatch in expression /Query

    I have a from the has two sub-form tables that share StudyID in link child and link master. The form works perfectly. But the information stored in the tables is creating problem when I need to create a report off of that information.



    I have a query that runs off of three tables. Each have their own unique ID such as EntryID and Entry2ID and the main ID is StudyID. All three tables share the the main table StudyID. Since the information is coming from the form which keeps a history and in the query I have to use the last set of information. In the total I entered Last which works if I only link two tables. When I link the three tables is where I have the problem. It will pull the unique Entry2ID with information from a different record set to include with the other table information.

    I hope I explained it correctly.

  2. #2
    starhannes is offline Novice
    Windows 7 Access 2007
    Join Date
    Apr 2010
    Posts
    15
    sorry wrong thread

  3. #3
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    It all depends on the relationship between the 3 tables. Also, make sure your joined datatypes are all correct. you cannot join a Number type to a Text type. If the latter is not the issue, please explain the relationship of your tables (a screenshot of your relationships window would be helpful)

  4. #4
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147
    I had one of the studyID's as Text and not a number. Good catch. Thanks!

  5. #5
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Yea anytime you get that "type mismatch" error, that should be the first thing you should check. That is your fix 99% of the time. Glad it wasnt anything big.

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

Similar Threads

  1. mismatch type compare help needed
    By techexpressinc in forum Queries
    Replies: 3
    Last Post: 02-23-2010, 03:27 PM
  2. Replies: 4
    Last Post: 10-26-2009, 05:27 AM
  3. Type Mismatch - HELP!
    By jgelpi in forum Programming
    Replies: 3
    Last Post: 07-17-2009, 03:53 PM
  4. Replies: 4
    Last Post: 05-16-2009, 09:17 PM
  5. Replies: 2
    Last Post: 03-23-2009, 05:39 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