adding fields in Make-Table query

  • Thread starter Thread starter Lim Heng Sin
  • Start date Start date
L

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
 
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)
 
Back
Top