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

Reports by choosing date

P: n/a
My database has the data from events that happened in several dates
this is different event happening in the same day. this database manage
a Help Desk where calls happened often.

how to create a report that allows the user pick or select a specific
date to print?

ex. I want to print all the events that happend on 08/17-2006, but
later I want to print a report of all the events that happend on August
15 2006.

again, thank you guys!..

Aug 17 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
One way is to create an unbound form with two textboxes formatted as
dates and then
build your filter in the click event of a button and then open the
report, passing the filter you just built in the Open event.

Aug 17 '06 #2

P: n/a
On 17 Aug 2006 07:37:30 -0700, pe******@gmail.com wrote:
My database has the data from events that happened in several dates
this is different event happening in the same day. this database manage
a Help Desk where calls happened often.

how to create a report that allows the user pick or select a specific
date to print?

ex. I want to print all the events that happend on 08/17-2006, but
later I want to print a report of all the events that happend on August
15 2006.

again, thank you guys!..
Create a query that will become the record source for the report.
On the DateField's criteria line, write:
[Enter Date]

The query will prompt for the wanted date.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 17 '06 #3

P: n/a
Fred right to the point, thanks a lot.
Question: Can I modify this prompt? I mean like add a label for Input
Date? like: remember to use the format: MM/DD/YYYY

thanks again,

fredg wrote:
On 17 Aug 2006 07:37:30 -0700, pe******@gmail.com wrote:
My database has the data from events that happened in several dates
this is different event happening in the same day. this database manage
a Help Desk where calls happened often.

how to create a report that allows the user pick or select a specific
date to print?

ex. I want to print all the events that happend on 08/17-2006, but
later I want to print a report of all the events that happend on August
15 2006.

again, thank you guys!..

Create a query that will become the record source for the report.
On the DateField's criteria line, write:
[Enter Date]

The query will prompt for the wanted date.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 21 '06 #4

P: n/a
On 21 Aug 2006 06:48:13 -0700, pe******@gmail.com wrote:
Fred right to the point, thanks a lot.
Question: Can I modify this prompt? I mean like add a label for Input
Date? like: remember to use the format: MM/DD/YYYY

thanks again,

fredg wrote:
>On 17 Aug 2006 07:37:30 -0700, pe******@gmail.com wrote:
>>My database has the data from events that happened in several dates
this is different event happening in the same day. this database manage
a Help Desk where calls happened often.

how to create a report that allows the user pick or select a specific
date to print?

ex. I want to print all the events that happend on 08/17-2006, but
later I want to print a report of all the events that happend on August
15 2006.

again, thank you guys!..

Create a query that will become the record source for the report.
On the DateField's criteria line, write:
[Enter Date]

The query will prompt for the wanted date.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
You can add any text you like... as long as it is inside the brackets:
[Enter Date: Use mm/dd/yyyy format]
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 21 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.