Jill,
>So now I do a sql select statement on key and date/time field and it doesn't work! I can manually link and browse the matches in the command window so I know the key+date/time link is valid. Why doesn't sql select match them????
Please post the SQL SELECT statement and tell us the names of the key and date/time fields and their type and lengths in both tables.