3 field criteria search

  • Thread starter Thread starter Toan Chau
  • Start date Start date
T

Toan Chau

Hello everyone.

I have a query that with three fields that I would like to
apply a search to.

OS Equipment Type


Currently I have this in OS criteria.

[What OS?] or [What OS?] ="ALL"

So it prompts me for what OS. I then can select the OS I
want displayed or if I select ALL then it will display all
OS.

Can someone please tell me how I make a criteria that
will...

1. prompt me for the OS field. And I can enter the OS
or "ALL".

2. Then, my next criteria based on Equipment would prompt
me on which equipment. And I can input the equpiment or
input "ALL". But this search criteria would be based on
the results from the first search, the OS field.

3. And lastly, the Type field would filter the same way
but based on the results from Equipment field.

Would this be possible?

Thanks!!!
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Instead of using ALL in the parameter prompt do not enter anything -
just click the OK for each prompt & create an SQL statement something
like this (be sure all the parentheses are in the correct place):

SELECT ...
FROM ...
WHERE ([What OS?] IS NULL
OR (OS = [What OS?] AND [What OS?] IS NOT NULL))
AND ([What Equipment?] IS NULL
OR (Equipment = [What Equipment?] AND [What Equipment?] IS NOT
NULL))
AND ([What Type?] IS NULL
OR (Type = [What Type?] AND [What Type?] IS NOT NULL ))


- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDOlMoechKqOuFEgEQK0LQCgiyqzXoRa8CJDGJlAb+J7ug4T3akAoL6D
MPbnb/r7JaO19psXjERohVDJ
=5vjj
-----END PGP SIGNATURE-----
 
Back
Top