Matching account numbers

[CAM]

Hello,

I have a table that is a chart of accounts called "ChartOfAccounts"
Another table called "MonthlyExpense" containing expenses for the month by
department. What I want is to match the table from the "MonthlyExpense"
with "ChartOAccounts. Example: I have a expense from "MonthlyExpense"
account number "AT2543050509" with the corresponding account number from the
"chartOfAccount" called "Dues and subscription" account number
"ATXX43050509" the XX in the "ChartOfAccounts" is for the department
number, which varies. I want to somehow match "AT2543050509" from the
"MonthlyExpense" table with "ATXX43050509" from the "ChartOfAccount" table.
How do I do that? Any tips will be appreciated. I am using Access 2002.
Thank you in advance.

Cheers

 

[bhicks11 via AccessMonster.com]

Maybe the easiest way would be to create two queries that have the field from
the tables but add a field that is the last 8 digits of the ID #. Then
create a third query, include the first two queries and relate them on the
calcuated 8 digit field.

To pull out the 8 digits, in your query, your field would be:

CalcID: mid(ID,5,8)

Bonnie
http://www.dataplus-svc.com