Kissi Asiedu wrote:
I have a table with a del_date and mem_address fields. I need help in
running a querry that will list all mem_address that have del_date 30
days from current date. Please help.
Thanks.
30 days in the past or in the future?
Exactly 30 days or (30 or more) days?
Assuming exactly 30 days in the past the basic query would be...
SELECT mem_address
FROM TableName
WHERE del_date = DateAdd("d", -30, Date())
This also assumes that the del_date values in the table have no time component
(time is midnight).
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com