M Mel Dec 29, 2003 #1 I only want a query to return records that are a year or less than a year old Thanks
L Les Dec 29, 2003 #2 Open your query in design mode. Type the following in the criteria for your date field: >=DateAdd("yyyy",-1,Date()) This means that you want all rows where your date is greater than or equal to last year(today's date minus 1 year).
Open your query in design mode. Type the following in the criteria for your date field: >=DateAdd("yyyy",-1,Date()) This means that you want all rows where your date is greater than or equal to last year(today's date minus 1 year).
B Benay Dec 30, 2003 #3 -----Original Message----- I only want a query to return records that are a year or less than a year old Thanks . Click to expand... Use the > or < in front of the date that = the one year mark.
-----Original Message----- I only want a query to return records that are a year or less than a year old Thanks . Click to expand... Use the > or < in front of the date that = the one year mark.
