Create a field for text when making a table in a query

[Cpreston]

Hi

I have a make table query which is linked to several tables from SQl and this works fine.
I want to be able to add a field when running the query (like a memo field, where I can add data into.
This data will then go under the relevant row in a report (will access It through a form

What I cannot figure out is how to create the text field when running the memo query (if it is possible)
Maybe it could be done through a form and then updated to the row number.
Any ideas how to achieve this please (without to much code if possible, still learning)

Thanks

 

[PWise]

how about
select Field1,field2, null as field3
into newtable
from oldtable

 

[Cpreston]

I ended up adding this into the query in the end

Lineinfo: (" ")

All working now, thanks for the reply