Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Query on a Query Problem (Access 2000)

    I have a report based on a query that, in turn, is based upon another query. The underlying query is set up with parameters to supply a location. I want to open the report and be prompted for a location. Instead, the parameter is not passed through and I get all records for all locations. Help?

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

    Re: Query on a Query Problem (Access 2000)

    Is there a crosstab query involved in this pair of queries? If so, do you have the parameter actually set as a saved parameter and not just put in the criteria line? If not, try that.
    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
  •