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

Hi Alan,

If I understand what you're looking to do, I don't think 
it can be done exactly that way. I don't know of a way to 
change the lookup type of a table programatically, and I'm 
as certain as I can be that it can't be done as part of 
the SQL.

I handle this type of situation, usually, by creating the 
table and setting the properties, then using an append 
query instead of a make table.

However, you can resolve the problem easily by just 
changing the "0" to a 0 (converting it or however else 
works for you), which will be saved as a numeric, and 
since booleans are actually numbers (0 or 1) your 
checkboxes on forms will work fine. Unless you're giving 
your user access to the table directly of course...

HTH,

Ron




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