>>Hey all!!
>>Is there a way to do a SQL-SELECT in which I pull all the fields from the database(26 fields) except for 3?
>
>This is one of the few things the Query Designer is good for. Use it to easily select all your fields, then copy the SQL to wherever you need it...

Thanks Bruce,
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:)

Again, thanks for the reply:)