Make table query to add blank columns

[Tlewman]

I have a make table query that I update weekly. It creates a table with three columns. I need to have one blank column to come across so that I can run a module adding some info. Is this possible?

 

[dk]

Sure is! In the query design view, add another column and add something like Dummy:Null in the field row. The SQL looks like this:-

SELECT tblPayments.PaymentReference, Null AS Dummy, tblPayments.GrossChequeAmount INTO MyTable FROM tblPayments;