How do you create a Report or query for the # last days?

[Jaycee66]

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

[David B]

Re: How do you create a Report or query for the # last days?

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 <Jaycee66@jumpy .it> wrote in message
news:af5077cd.0 312160505.6541c 6e@posting.goog le.com...[color=blue]
> 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[/color]

[Tony Toews]

Re: How do you create a Report or query for the # last days?

U N Me <unme@together. com> wrote:
[color=blue]
>Comments: This message probably did not originate from the above address.
> It was automatically remailed by one or more anonymous mail services.
> You should NEVER trust ANY address on Usenet ANYWAYS: use PGP !!!
> Get information about complaints from the URL below[/color]

Ignore the URL in the above posting.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

[Patrick Finucane]

The above post is a forgery by a pornographer