In my previous message, I should have also included the following information:
After each main SELECT (whatever table).RecID, I should have said "and any other fields you want to pick for your output".
( Actually, I *did* have that in the code, but I surrounded them with brackets which didn't come over when I copied the code from Notepad *sigh* )
My bad...sorry
Evan Pauley
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?