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

first have a subquery to get rid of the "E"

have a column

mykey:mid(normalkey,2)

then you should be able to loin this query to your table on the "mykey"

if you get a type mismatch try

mykey:val(mid(normalkey,2))

Perfect...Ill just figure out what a sub query is and ill be set. Thank you for your guidance!


Kevin

A sub query is a 'in between' query...

I.e.
Table > Query1 > Query2

Query2 draws information from Query1 that draws data from Table. Query1 is a sub-query.