lmossolle said:
I have a Query that has an Exp Date. I would like to have it pull overdue
items, for example if there was a date of 1/31/2007 I would like to see if it
was equal to or greater than the date or over due period....
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Kinda sketchy definition of your problem. My guess is you'd put the
over due date in the query's criteria:
PARAMETERS [Date over due?] Date;
SELECT *
FROM table_name
WHERE exp_date >= [Date over due?]
--
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/AwUBR74BvoechKqOuFEgEQIu9QCgvv3LIqVFwKnzgTqXu5CaR1giFYgAoK3A
qCsQ6ftWVkfYwJHffZJrDUkE
=U58M
-----END PGP SIGNATURE-----