busbeead
asked on
Create New Boolean (Yes/No) Field In MakeTable Query
I can create a new field using
Fieldname: "Data"
How would I say that I want to create a new fieldname with data as a boolean (Yes/No). What would I add to this or change?
Thanks!
Fieldname: "Data"
How would I say that I want to create a new fieldname with data as a boolean (Yes/No). What would I add to this or change?
Thanks!
Select Yes/No for the data type.
how are you making this table?
from the db window, or through code/sql?
Billystyx
from the db window, or through code/sql?
Billystyx
ASKER
I can do that when I make a new table, but I am using the Make Table Query to make a new table from two separate tables. I need to have a field that is a Yes/No in addition to the fields that are brought in from the two tables.
ASKER
I am doing it through the Design View since I am not great at SQL, but if I can modify the SQL I will go into that view.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
capricorn1,
That is what I needed. Is there any way to define the format as True/False at the same time?
That is what I needed. Is there any way to define the format as True/False at the same time?
what do you mean?
YesNo is the same as True/False
YesNo is the same as True/False