PC Review


Reply
Thread Tools Rate Thread

Creating report by selecting date from calendar

 
 
=?Utf-8?B?SnVzc2Nh?=
Guest
Posts: n/a
 
      30th Jan 2006
I'm wondering if its possible to click a date on a calendar and have it
generate a report for that date.

I currently have a very functional transportation database running. I would
like to be able to select a date and have all of the rides booked on that day
displayed in a report in their corresponding time slot. I've already tried
looking at some of the suggestions in the other postings and some of the
links I want will not allow me to view the samples.

Any suggestions would be greatly appreciated.
 
Reply With Quote
 
 
 
 
Al Camp
Guest
Posts: n/a
 
      30th Jan 2006
Jussca,
If your using the Access Calendar Control, you can filter your report by
the value indicated in the calendar on your form.
This should work as a criteria in your report query...
=Forms!frmYourFormName!calYourCalendareName.Value
Didn't test, but it should fly...
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Jussca" <(E-Mail Removed)> wrote in message
news:B7566FED-4EB2-4383-BCDE-(E-Mail Removed)...
> I'm wondering if its possible to click a date on a calendar and have it
> generate a report for that date.
>
> I currently have a very functional transportation database running. I
> would
> like to be able to select a date and have all of the rides booked on that
> day
> displayed in a report in their corresponding time slot. I've already tried
> looking at some of the suggestions in the other postings and some of the
> links I want will not allow me to view the samples.
>
> Any suggestions would be greatly appreciated.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting a Start and End Date on a Form to Get to a Report Conor Microsoft Access Macros 4 22nd Jul 2009 03:52 PM
Selecting a Date from a Calendar in a Form Cesar Microsoft Access Form Coding 1 9th Mar 2009 06:11 AM
Selecting Date from Calendar to text box =?Utf-8?B?S2Vu?= Microsoft Access Form Coding 3 15th Jun 2007 03:36 PM
Selecting a Date Range For a REport =?Utf-8?B?am9lcm9ja2V0?= Microsoft Access Getting Started 5 4th Nov 2006 10:18 PM
Selecting a date in a report =?Utf-8?B?Si1F?= Microsoft Access Reports 1 2nd Nov 2004 02:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:31 AM.