[AccessD] (Simple?) Problem Creating a "Yes/No" [Data Type] Field in a MakeTable Query

Can you specify True / false instead of 0?

False AS [Record_Select_Flag] INTO <table-name>

The quotes around the 0 make it a string which needs a text field.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Lawhon, Alan C
Contractor/Morgan Research
Sent: Thursday, September 11, 2003 12:35 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] (Simple?) Problem Creating a "Yes/No" [Data Type]
Field in a MakeTable Query


Susan, Arthur, Rocky, William, Jim, John, Doris, Jim Lawrence, et al:

I need help with an (easy?) Access problem - and I just know that somebody
on
this list knows the answer.

I am working on a "Make Table" query which will have to be used (and reused)
repeatedly to create the same table from scratch.  One of the field cells in
this query is created (in the QBE pane) from an expression.  The expression
is
as follows:

      Record_Select_Flag: "0"

The corresponding phrase/clause for this expression (in SQL view) is:

      "0" AS [Record_Select_Flag] INTO <table-name>

Here's my problem.  The data type of the field created by this expression is
a
"Text" field.  I would like to create a "Yes/No" checkbox field rather than
a
"Text" field.  (Actually, a "Yes/No" field will work just fine.)  Can anyone
tell me how to modify the expression to create a "Yes/No" field?

I've been searching the Access "Help" library, but so far I haven't found
the
answer ...


Alan C. Lawhon


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com