But this is a place where I'm using a dynamic SQL statement, depending on what fields are entered, etc...
>Actually, what I did do was use DISPLAY STRUCTURE to a txt file, then used that to make a nice little list depending on the table accessed and then insert the text with macro sub:)
Okay, I see...that sounds fine. Another technique is using ALTER TABLE to remove unwanted columns if your result set is read/write...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.