jiblankman
Registered User.
- Local time
- Today, 15:47
- Joined
- May 27, 2008
- Messages
- 43
I have a database which is the combination of data from tables from several other dbs. The merged database was originally created by importing specific tables from the original databases. The data had to be combined and exported for manipulation by a third party program. After manipulation, the table that is needed has the following columns:
1 Employee Name
2 Employee ID
3 Client Name
4 Client ID
5 Record ID (from the original databases - duplicates may be found)
6 DB Source (refers to which database the data orignated from - these are a three letter code representing the original files)
I need to create a report that will pull the client name and id specifics (ie address, contact info, etc.) from the original files based on the DB Source column. I am relatively new to Access and cannot figure out how best to do this. It needs to be fairly idiot proof in the end because others will be using it.
Thanks for any help.
1 Employee Name
2 Employee ID
3 Client Name
4 Client ID
5 Record ID (from the original databases - duplicates may be found)
6 DB Source (refers to which database the data orignated from - these are a three letter code representing the original files)
I need to create a report that will pull the client name and id specifics (ie address, contact info, etc.) from the original files based on the DB Source column. I am relatively new to Access and cannot figure out how best to do this. It needs to be fairly idiot proof in the end because others will be using it.
Thanks for any help.
