If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Matching account numbers
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 |
#2
|
|||
|
|||
Matching account numbers
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 CAM wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200807/1 |
Thread Tools | |
Display Modes | |
|
|