Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2002
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parameter query (XPSP1)

    Parameter Query works fine in a crosstab query.

    [Enter Beginning Date]
    [Enter Ending Date]

    as criteria for date field with queries parameter properties set to same

    Upon running report, I am getting each parameter a second time, for a total of four prompts

    Had this issue some time ago, and I forget resolution.

    TIA.

  2. #2
    Lounger
    Join Date
    Oct 2002
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter qr solved

    Well, I checked everything.

    I was receiving Error 3070 related to crosstab query

    The Microsoft database engine does not recognize

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Parameter qr solved

    It's pretty much a given that if you want to use a crosstab query as the recordsource for a report, you need to name the columns. That will also give you columns for all names, even if there is no data for that column for the particular instance of the crosstab.
    Charlotte

Posting Permissions

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