SQL Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to write a code in the Expression Builder of a report text box in
Access 2003. In my table, where the report is pulling from, I have a
Destruction_Date field. I need to pull the destruction dates from 10 years
ago and have that data populate the rest of my text boxes. That's the text
box where I'm trying to use the Expression Builder.

For example, I have text boxes labeled ProjNum and ProjIndexNum along with
the Destruction_Date text box. I want the code to go into the table, look up
all the dates 10 years old or older, based on today's date, and then populate
the text boxes on the report with only that data.
 
Create a query using this table.
In the Criteria row under the Destruction_Date field, enter:
<= DateAdd("yyyy", -10, Date())
Save the query.

You can now build a form based on this query.
 
Back
Top