-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I believe the proper format should be:
WHERE [Whatever] IS NULL OR ([Whatever] = "some string" AND [Whatever]
Is NOT NULL)
But this only works on Access Parameter queries - 'cuz "[Whatever]" is
the parameter. MS Query doesn't recognize Parameter queries.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP9ufkoechKqOuFEgEQKfFACgzYNSVu3OeKW0Tl4p9JaKpC OhlbYAnRUP
tplZlmbkPdkbHrYJt5Th2wdN
=+xsO
-----END PGP SIGNATURE-----
GERALD SHAW wrote:
[color=blue]
> ACC97...
>
>
> I have a database which is connected to an excel spread sheet using MS
> query..
>
> Using Access, I am used to setting up within a queries criteria, the
> following
>
> [Whatever] is Null Or [Whatever] this allows me the option to either pick
> an item or select the whole lot!
>
> but when using MS query in Excel.... I can't make it work???
>
> it just keeps telling me that the string is wrong!!!
>
> Can any one show me what the MS query ...equivalent is..
>
> Thanks...
>
>[/color]
