By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 994 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
U N Me <un**@together.com> wrote:
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


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
Nov 12 '05 #3

P: n/a


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.