Stephen and Dan,
Thanks for your help. After many long hours, I have finally gotten the
results I needed! I never could get the UNION SELECT to work properly, kept
getting error messages. What I ended up doing was using both of your
solutions in a way! I create my 3 views, then create a temp table, append
the first view to the temp table, delete duplicates, then update the temp
table with the values I need from the 3 views! Ain't the prettiest
programming you may have seen, but it works! Thanks again for your help!
Jan Barley
