Search results

  1. H

    Conditional Join

    Windows 7, Access 2007: I have really been struggling with this problem. I understand what I need to do, I just don't know how to do it. In joining two tables together: TableA OrigNum TableB NameNum OrigNum PrevNum NextNum I want to join TableA.OrigNum to TableB.OrigNum where...
  2. H

    Datatype mismatch error 3464

    I've been struggling with putting together this code and have run into another problem. This whole project revolves around the fact that I have to query 3 separate linked tables to find one record. Given a claim number, the record could be in one of 3 linked tables. I have set up 3 queries...
  3. H

    Previous Record

    Access 2007 on XP - I have a table that has: claim trans date examiner 1 1/2/08 MB 1 1/2/08 MB 1 2/9/08 MB 1 5/21/08 DG 1 7/18/08 DG 2 1/5/08 KY 2...
Back
Top Bottom