Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2007

Tip: Looking for answers? Try searching our database.

Logical criteria in query option

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ramesh - 10 Mar 2007 15:30 GMT
HI,

How do i specify the query options for a logical field?  I tried Equal to
True like we use in an access query but doesnt work.

any help please.

Thanks
ramesh
Peter Jamieson - 10 Mar 2007 16:32 GMT
In Word 2003, True and False seem to work in the Query options however you
connect to the Access data source (OLE DB, ODBC or DDE). However, if you
look at what Word displays for the True and False values, it depends on the
connection method

         True    False
DDE    -1    0
ODBC    1    0
OLE DB    True False

In query options, you appear to be able to use -1 for True with DDE or OLE
DB, 1 for True with ODBC, and 0 for False with all of them.

However, it would not surprise me if some versions of Word behave
differently, perhaps generating the wrong SQL if you use True or False (e.g.
if it generates myfield = 'True' it probably won't work properly). So I
would try the numeric values and see if that works for you.

Peter Jamieson

> HI,
>
[quoted text clipped - 5 lines]
> Thanks
> ramesh
Ramesh - 11 Mar 2007 09:47 GMT
Thanks Peter.

Ramesh

> In Word 2003, True and False seem to work in the Query options however you
> connect to the Access data source (OLE DB, ODBC or DDE). However, if you
[quoted text clipped - 25 lines]
>> Thanks
>> ramesh

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.