By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

Access data through MS query in Excel.

P: n/a

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...
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
-----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:
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...


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.