report

[lakshmi]

Need to create a report which will take the current date and add 35 days to it and then run a query that selects all records whose expiration dates fall within 35 days of the date you calculated. Does this make sense?????

Do I need VBA to create this report or can I just use a function???

Thanks!

 

[Rich]

Just base the report on a query with the criteria of Between DateAdd("d",35,Date()) And Date() on your Date field