Hi Mark,
Your close enough to the problem. Now you can see why I need to get rid of any refrence to the table name because It will be not available. I will have recreate the alias with only the fields that are need for comparison, but I still need to be able to a query on the recreated alias, but I can not. Any help is very much appreciate.
Carl
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°`°º¤ø¤º°¤º°
Carl Evans
CEO & President
System Answers Consulting, Inc.
MCSD .NET, ASP.NET, C#.NET, VB.NET,