Link to home
Start Free TrialLog in
Avatar of busbeead
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!
Avatar of Jokra_the_Barbarian
Jokra_the_Barbarian
Flag of United States of America image

Select Yes/No for the data type.
Avatar of Billystyx
Billystyx

how are you making this table?
from the db window, or through code/sql?

Billystyx
Avatar of busbeead

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.
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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
capricorn1,
   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