Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    31

    Unanswered: Report issue from 2003 to 2007

    I have a parameter query which prompts user for start date and end date. The query is "called" from a report so when the user wants the report they are prompted for start date and end date.

    Has worked correctly in 2003 for years.

    When the app is put in a 2007 enviroment the prompt is asked for numerous times before it finally generates a report.

    I have run the underlying query alone - and user is prompted once.

    I have changed the underlying query to hard coded values and the report runs though without a hitch.

    Report does include some subreports which link to the "base" data but those reports and supporting queries when run alone do not prompt the user (nor should they)

    And ideas???

    Thanks!

  2. #2
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by IMAcoolClassic View Post
    I have a parameter query which prompts user for start date and end date. The query is "called" from a report so when the user wants the report they are prompted for start date and end date.

    Has worked correctly in 2003 for years.

    When the app is put in a 2007 enviroment the prompt is asked for numerous times before it finally generates a report.

    I have run the underlying query alone - and user is prompted once.

    I have changed the underlying query to hard coded values and the report runs though without a hitch.

    Report does include some subreports which link to the "base" data but those reports and supporting queries when run alone do not prompt the user (nor should they)

    And ideas???

    Thanks!
    I find it better to use a form to collect the parameters.

    Check out

    Report Dialog Examples
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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