Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

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!
0
busbeead
Asked:
busbeead
1 Solution
 
Jokra_the_BarbarianCommented:
Select Yes/No for the data type.
0
 
BillystyxCommented:
how are you making this table?
from the db window, or through code/sql?

Billystyx
0
 
busbeeadAuthor Commented:
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.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
busbeeadAuthor Commented:
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.
0
 
Rey Obrero (Capricorn1)Commented:
you can do it in a separate query after running your make table query.

"Alter Table NameOfTable Add Column NameOfField YesNo"
0
 
busbeeadAuthor Commented:
capricorn1,
   That is what I needed.   Is there any way to define the format as True/False at the same time?
0
 
Rey Obrero (Capricorn1)Commented:
what do you mean?

YesNo is the same as True/False
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now