I have a database and a spreadsheet. The spreadsheet contains a customer list. I need to make a report with other data. This data comes from the database. I have imported the spreadsheet into the database as a table. I link the first and last name to eachother and run the new query. I get various duplicates. The only other field I can think of linking is the purchase date. The only problem is that the purchase date is written as, 4/18/2006 in the spreadsheet, and the database has 3 different tables for the date, ex. date1=month, date2=day, date3=year. Other than manually looking up each account, is there a way I can make my search easier?