Create New Boolean (Yes/No) Field In MakeTable Query

Posted on 2005-04-06
Last Modified: 2011-09-20
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?

Question by:busbeead
    LVL 11

    Expert Comment

    Select Yes/No for the data type.
    LVL 18

    Expert Comment

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


    Author Comment

    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.

    Author Comment

    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.
    LVL 119

    Accepted Solution

    you can do it in a separate query after running your make table query.

    "Alter Table NameOfTable Add Column NameOfField YesNo"

    Author Comment

       That is what I needed.   Is there any way to define the format as True/False at the same time?
    LVL 119

    Expert Comment

    by:Rey Obrero
    what do you mean?

    YesNo is the same as True/False

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now