Hello,

I am writing a program that has an MDB database and I would like to be able to sort two tables using SQL. I am pretty sure it would be the most efficient way to do it.

basically, there are two tables. Both tables have a list of dates. I am looking to sort table2 by table1 so that if a date in table 1 matches taht in table 2 it doesn't display that date.

Basically the dates in table2 are a list of test. The dates in table1 is a list of test that have already been taken.

If anyone has any info, please post.

Thanks,
Mark