Creating Yes/No Field Using Make Table

[orcinus]

I want to be able to create a table using a make table query that has a field with a Yes/No data type..



For example, if I want to create a Currency type field using a make table query, in the query field field I would enter:

NameOfField: Ccur(0)

Is there something similar I can do to create a Yes/No Data Type?

Thanks for any assistance..

[maximus]

I have used this to Create a Table8 with Field ppY as a Yes/No Field. I have used the datatype BIT.
Hope this helps.
Dim strSQL as string
strSQL = "Create Table Table8 (Id Number, FirstName Text, ppY BIT)"
currentdb.execute strSQL, dbfailonerror

[orcinus]

I have used this to Create a Table8 with Field ppY as a Yes/No Field. I have used the datatype BIT.
Hope this helps.
Dim strSQL as string
strSQL = "Create Table Table8 (Id Number, FirstName Text, ppY BIT)"
currentdb.execute strSQL, dbfailonerror

Thanks, I believe that will work in code, but was looking for if this can be done directly in a make table-query..

[TheShabz]

...that IS a Make Table query...

create a new query in SQL view instead of design view. paste in:
Create Table Table8 (Id Number, FirstName Text, ppY BIT)

[orcinus]

...that IS a Make Table query...

create a new query in SQL view instead of design view. paste in:
Create Table Table8 (Id Number, FirstName Text, ppY BIT)

OK, my bad, I see this now, thanks..

[maximus]

Thanks TheShabaz for explaining.

[maximus]

Please mark this thread solved