Query Question

  • Thread starter Thread starter lmossolle
  • Start date Start date
L

lmossolle

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....

Thanks,

Lee
 
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....
Click to expand...

-----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-----
 
Back
Top