True and False in queries

[NWTrust]

I'm trying to create a make-table query using True and False in the fields. Simply using True and False doesn't seem to be the answer. Using =True and =False only results in the = disappearing. Can anyone help me, please.

 

[randy700]

What are you trying to accomplish?

Create a yes/no field?
The TRUE or FALSE would be saved as -1 and 0.

Create a text field?
Put quotes around the text -- "True" or "False".


Randy

 

[NWTrust]

I'm trying to create a table containing only the TRUE fields from another table.

 

[randy700]

Post the SQL you're using for your make table query.


Randy

 

[PWise]

how about

SELECT     *
INTO            newtablename
FROM         oldtablename
where truefieldname=-1