Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    filter query based on calendar control (2002)

    Hi All, I am trying to open a report (which is based on a qry), but would like to first filter the query based on a calendar control's year and month values.....the calendar control is on a separte form. So, the end result would be....a command button on the calendar form would open the report based on the filtered query. I have been trying to design this report and query etc w/o any success. Could you please help me out with some suggestions as to the best way to work this would be? thanks muchly, Van

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: filter query based on calendar control (2002)

    Please tell us:
    - The name of the form
    - The name of the calendar control on the form
    - The name of the command button on the form
    - The name and type of the field or fields in the query on which you want to filter - do you have a date/time field or do you have separate year and month fields?
    - The name of the report.

  3. #3
    Star Lounger
    Join Date
    Nov 2002
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filter query based on calendar control (2002)

    Thanks Hans, I've managed to work it out. The command btn opens a report (based on a qry which has been filtered for the selected dates on the calendar control)...seems to work great. :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •