Query Help Please!

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

fgwiii

I am attempting to create a query that will look for a
study coordinator if one exists in the list of contacts.
If there is no one whose title is a study coordinator,
then I would like to take just one name from the list of
contacts – irregardless of their title.

Any help on this will be greatly appreciated!

Thanks

Fred
 
fgwiii said:
I am attempting to create a query that will look for a
study coordinator if one exists in the list of contacts.
If there is no one whose title is a study coordinator,
then I would like to take just one name from the list of
contacts – irregardless of their title.
Click to expand...

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

Isn't that kinda like going to buy a car, the dealer says "Sorry, we're
out of cars will you take a blimp instead?" and you saying yes.

In SQL queries you look for exactly something (=, <>, >, <, >=, <=) or
similar something (Like "*abc?"), not "if not found - anything else."
To do the last you'd have to run 2 queries: 1 to get the exact thing &
the 2nd, only if the exact thing wasn't found. In the 2nd query you'd
still have to identify what you do or do not want.

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

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

iQA/AwUBQIAi74echKqOuFEgEQIZ6QCgxUPEW1FLjyGRXnT3apokHsaT5zgAoMBG
aH+Wn/Ei51d2W44FqBmU0Y88
=IyM8
-----END PGP SIGNATURE-----
 
Back
Top