Please Help!! How can I set a parameter in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a parameter set in my query that ask what individual compound would you like to query by? But how can I make one of my choices be all of them, no set compound? Do I have to create a new query form? or can I ask this within the same query?
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Set up a WHERE clause like this:

PARAMETERS [Compound?] Text;
SELECT...
FROM...
WHERE [Compound?] Is Null
OR ([Compound?] Is Not Null And Compound=[Compound?])

If the PARAMETER [Compound?] is null, all records are returned. If
there is a value in the PARAMETER [Compound?], records w/ that value are
returned.

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

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

iQA/AwUBQJhp9oechKqOuFEgEQJKfACeISG9Exax6TTSxNiC0DM9B5TKbKoAoL+I
1qE9Xh8qzi08WTsIRG3YpAL2
=L5BY
-----END PGP SIGNATURE-----
 
Back
Top