Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    East Coast(USA)
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    crosstab query (Access 2002)

    Greetings,
    I designed a fiscal year report based on a crosstab query. When you click the FY begining date and FY ending date, the report should give you the result. Lately, I keep getting "Enter Parameter Value...." once clicked ok, another window appears to ask 'enter parameter value' etc. Can you please help?

    Thanks,
    OCM

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

    Re: crosstab query (Access 2002)

    Have you declared the parameters explicitly (Query | Parameters in design view)?

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    East Coast(USA)
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: crosstab query (Access 2002)

    The two dates are controls on a form. As you can see on the attached screenshots, the query part works fine. However, on the report, only the total appears and the other data are missing.

    As you suggested, I also tried declaring the parameters explicitly as follows:
    [07/01/2004] DateTime
    [06/30/2005] DateTime
    When I run the query, I get : Enter Parameter 07/01/2004 , Enter parameter 06/30/2005 etc.

    Thanks,
    OCM

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

    Re: crosstab query (Access 2002)

    The parameters should be named [Forms]![NameOfForm]![BeginningDate] and [Forms]![NameOfForm]![EndingDate] where NameOfForm is the name of the Fiscal Year Dialog form, not [07/01/2004] and [06/30/2005].

Posting Permissions

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