Create a unbound text box on your form. Name it numdays.
In the query that will feed your report you need something like the following in
the criteria of the relevant date field.
Between Date() and (DateAdd("d", -([Forms]![yourformname]![numdays]), Date()))
Havn`t tested this but should get you going. (The form needs to be open when
you run this so the query can "see" the number in the text box
HTH
David B
Jaycee66 <Ja******@jumpy.it> wrote in message
news:af*************************@posting.google.co m...
I am new to MS Access 2000 and I am trying to create a report that
would produce the last seven/any number days of data input through a
form?
In addition, recommendations of any good Access books that would
explain how to create various forms and reports.
thanks
jaycee66