set query date criteria to show record 8 days after entry

  • Thread starter Thread starter garry
  • Start date Start date
G

garry

Hi,
I want to be able to put a criteria into a date field in
a query that makes a record appear in a report a specific
number of days after the date it is entered into a
table.This is to be used as a reminder to do it again.
Make sense???
 
do you have a table field where this date will be stored?

if yes try something like the following to update the field in the table for
the specific record

Function nAdddays()
strDate = Format(DateAdd("d", 8, Now()), "dd/mm/yyyy")
End Function

HTH
 
Back
Top