Search results

Thanks. With the two tables TableA OrigNum TableB NameNum OrigNum PrevNum NextNum I want to retrieve the corresponding records from TableB when TableA.OrigNum=TableB.OrigNum and TableB.NextNum is null. Otherwise, I want to retrieve the corresponding records from TableB when...

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...

I found the problem in a calculated field that didn't match the field in the table it was appending to. Still looking for other ways of handling the queryingof 3 different systems. Thanks.

Thanks. I've checked the query, however, I check again. The issue with the 3 different locations is that we recently joined with another company. They maintained 2 separate systems for their 2 types of businesses (thus 2 systems to query over). Then we have our sytem (1 system to query...

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...

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...