Need help in DLookup Query

[Moe]

Hi, I need help in DLookup function. The following tables and fields
are involved
Table ==> SYS_INFO
///////Fields ==> SYS_ID (PK), TESTER_NME_ID (FK),BEGIN_DATE, END_DATE

Table==> TESTER_NME
//////Fields==> TESTER_NME_ID (PK) , TESTER_NME

I want to write a query that gives me all the TESTER_NME. The crateria
is i have to look into table SYS_INFO to see between BEGIN_DATE and
END_DATE if the TESTER_NME_ID is null. If so then give me all the
TESTER_NME.

In other words, i want to know who(TESTER_NME) is availeable between
BEGIN_DATE and END_DATE (user will pass the date parameter).

Your response and suggestions would be greatly appreciated.

Thanks
Moe

 

[MGFoster]

Hi, I need help in DLookup function. The following tables and fields
are involved
Table ==> SYS_INFO
///////Fields ==> SYS_ID (PK), TESTER_NME_ID (FK),BEGIN_DATE, END_DATE

Table==> TESTER_NME
//////Fields==> TESTER_NME_ID (PK) , TESTER_NME

I want to write a query that gives me all the TESTER_NME. The crateria
is i have to look into table SYS_INFO to see between BEGIN_DATE and
END_DATE if the TESTER_NME_ID is null. If so then give me all the
TESTER_NME.

In other words, i want to know who(TESTER_NME) is availeable between
BEGIN_DATE and END_DATE (user will pass the date parameter).

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

Don't use the DLookup function, use a QueryDef (SQL view). Here's one
way:

PARAMETERS [What date?] Date;
SELECT tester_nme
FROM Tester_nme
WHERE tester_nme_id NOT IN
(SELECT tester_nme_id FROM SYS_INFO
WHERE [What date?] BETWEEN Begin_date And End_date)

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

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

iQA/AwUBRE1rgIechKqOuFEgEQIE8wCffI+WVgvq7ZyyT1G74oPT0o8DxVIAn09p
dpa7NRVvJOFkmA1AJz6W+2kv
=wBWw
-----END PGP SIGNATURE-----

 

[Moe]

Thanks Foster that works just fine.

Thanks again

Moe