adding fields in Make-Table query

[Lim Heng Sin]

i am writing one make-table query. I want to add another
two fields on the new table. Match (Yes/No) and Comment
(Text field). Is it possible?

Thanks

 

[JohnFol]

If you are using a MakeTable I can't find a way of specifying the Yes/No as
it always comes through as a number. I have found a way of doing it as a SQL
specific. Thry this . ..

create table NewTable (Comment text, Match YesNo)