Criteria

[Loi]

Hi,

I would like to have a parameter. when I type in a date,
it will pull out data from two dates before and two dates
after that date.

Fx: if i type in 8/10/04. It will pull out information
from 6/10/04, 7/10/04, 8/10/04, 9/10/04 and 10/10/04.

Thank you very much
Loi Tran

 

[MGFoster]

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

PARAMETER [What date?] Date;
SELECT ...
FROM ...
WHERE date_column BETWEEN DateAdd("m", -2, [What date?])
AND DateAdd("m", 2, [What date?])

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

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

iQA/AwUBQST0SYechKqOuFEgEQLF5ACePggZ9WOk2wxRpD0C0IqNp4AvcO0AoJ8m
guzgw2EJHUi4VDrwkmJI+d9E
=srRq
-----END PGP SIGNATURE-----