Good morning.

I have a complex SQL select statement that has unions and parameters and have successfully created the query using VBA and can output the data but I want to duplicate the table output that the MS Query editor provides due to the need for calculated fields once the data is presented and it needs to be updated when I rerun the query from time to time.

I did a small query in the MS Query editor and then added fields and it works great but I needed more information.

Any help would be greatly appreciated.

Thank you