include yes/no boolean as expression field in queriy

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

is it possible to add a yes/no boolean expression field to a query that can
be used to filter records by another query?
if so, syntax please.

thanks much,
mcnews
 
NewBooleanField: True

or

NewBooleanField: False

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
guess you answered what you thought was my question.

i need to know how (syntax) to create the boolean field expression in the
first query.

thanks,
mcnews
 
I did. :D

Put it in the field row of a blank column.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top