Thx Ian - I understand now. I have never used that - simple things you somehow miss on the way... :w00t:

For a few fields, drag and drop is fine but if you have a lot of fields and want all of them you have to drag, drop and then click...

I simply do a "select top 1 * from table" and return the results in text. Then copy the first row which is the fieldnames, paste it into the query...