Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Manchester, NH
    Posts
    57

    Unanswered: Open a report based on 2 form fields!

    I have a form that has name and date on it. I want to open a report that displays the entire months data for that persons name based on the name field and the date field. Thanks for your help!

    Kevin

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: Open a report based on 2 form fields!

    Originally posted by dalynching
    I have a form that has name and date on it. I want to open a report that displays the entire months data for that persons name based on the name field and the date field. Thanks for your help!

    Kevin
    provide the report by a query that has 3 filters

    1- >= start date of the month (you may use DATESERIAL() function)
    2- <= end date of the month (you may use DATESERIAL() function)
    3- all names equals name field on the form

    pls try
    qha_vn

Posting Permissions

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