Search results

Thank you, for your help. But a colliage of mine found a scprit that will preform combine the dbfs. But in case you were wondering A= bus route

PNGBill, The method that you are discussing will not report the cases where A and B do not match a record in any other table. What I really need is the total of C for each A B pair. Some of the A B pairs, but not all, appear in multiple tables. Gavin

Steve, I do not believe that any of the tables represent a comlpete list all possible A and B combinations, although, I do not know for sure, because there are between 50,000 and 70,000 records in each table. All records have both an A and B. Thanks for your help

I am new to access. I am trying to write a query that will return the values in column "c" for each of 3 tables when column "a" and column "b" match. Access will only return values when there "a" and "b" appear in all tables. How should I write the query so that it will return the value for "a"...