jeimen said:
add for this...
i want them to be like that when i enter the start and end date of there
contract to that site...
that information is coming from tblProjAssign from my database...
the table look like this... with example data
ProjID ProjectName Principal PrincipalAddress Place of Work
Position Start EndDate
1 Toshiba khhkkjjhj jhjkhjhjkhjkhjj
philippines installer 02/1/08 03/14/08
i want that when i enter the startdate and enddate in will reproduce the
first example i show on the top...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Perhaps this:
PARAMETERS [Enter Start Date] Date, [Enter End Date] Date;
SELECT ProjectName As site, position, COUNT(*)
FROM tblProjAssign
WHERE [Start]>=[Enter Start Date] And [EndDate]<=[Enter End Date]
You could have just one date that the [Start] and [EndDate] bracket.
IOW, the parameter would be "The date when the work was occurring."
Then you could have a criteria like this:
PARAMETERS [The date when the work occurred] Date;
SELECT ...
FROM ...
WHERE [The date when the work occurred] BETWEEN [Start] And EndDate
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBSaQlF4echKqOuFEgEQIIdQCgzlI3ojjI3MJBg2x3qropz0HjB/cAmwbr
G67AZjghmm9A065fDnvmOE5w
=cIo6
-----END PGP SIGNATURE-----
