IIF Function for Queries?

[Guest]

Hi!

I want to create a query that pulls records by team number (1-10). Team 10
has two supervisors so if the team number = 10, I want to prompt for the
supervisor's initials so the accompanying report can be grouped by supervisor.

Is this possible?

Please reply to this forum and not my e-mail.

Thanks!

 

[MGFoster]

Hi!

I want to create a query that pulls records by team number (1-10). Team 10
has two supervisors so if the team number = 10, I want to prompt for the
supervisor's initials so the accompanying report can be grouped by supervisor.

Is this possible?

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

Set up the query to always group by the supervisors.

SELECT supervisor, team_nbr
FROM table_name
WHERE team_nbr = [Enter the team number]
ORDER BY supervisor, team_nbr


OR

You'll have to use a form to provide the criteria. Then dynamically
create the SQL using the criteria in the form's controls. Then push it
into an existing, blank query. Then run the query.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBRKmOHYechKqOuFEgEQLRUACfWEIZZFjdTc90TTySBnu41SocToAAoJdX
4n6sddktI5zxjzkw7QN0ThSX
=+WR8
-----END PGP SIGNATURE-----