Kevin-anderson
New member
- Local time
- Today, 02:53
- Joined
- Jun 16, 2009
- Messages
- 6
I am currently trying to compare two tables, one table has current up to date data and the other is a monthly report that i have to reconcile agaist this master list. Normally this is easy as i can simply use an unmatched records query using the employee ID number as a matching field in both tables. However, this report formats the employee ID number differently. Instead of being a 5 digit number it has the letter "E" then i 5 digit number. Changing the format of the table is not within my ability. Is there any way i can set up a query to compare these two nearly identical columns?
I use access 2003
Thank you in advance
Kevin
I use access 2003
Thank you in advance
Kevin