98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Getting queries to reference other queries | Access forum
Getting queries to reference other queries | Access forum
Resolved · Low Priority · Version 2003
Tue 26 Jan 2010, 11:42Delegate John said...
John has attended:
Access Intermediate course
Access Advanced course
Getting queries to reference other queries
Hello,
I am trying to find a way to get one query to reference another query.
Essentially I have a number of different queries which are designed to become subreports in an overarching report.
Each query has an organisation parameter field, but when creating the report I will be looking up the same organisation for all of the subreports.
Rather than entering the parameter 3 times, I thought one solution might be to create a simple parameter query which just has the organisation field and then get the other queries to reference that lookup.
The problem I am having is that when I run the queries they bring up the parameter entry box, but that doesn't seem to limit the results in the queries themselves.
Apologies for the rambling post, but I hope you can help!
Mon 1 Feb 2010, 10:12Trainer Jacob said...
RE: Getting queries to reference other queries
Hi John
Thanks for your post, we have had to review this with a few of the team to identify the best course of action.
What we can say it that a solution can be found but it is beyond the scope of this forum. In these instances what we ask is for you to send through some example files along with a list of items you wish to solve.
We will then get back to you with a scope of work, duration and any related costs for you to decide if you wish to proceed.
If you would like to discuss any of this further you can reply to my email.
regards
Jacob
Mon 1 Feb 2010, 10:45Delegate John said...
RE: Getting queries to reference other queries
Hi Jacob
Thank you very much for looking into this for me.
I think I have managed a work around by creating a parameter query solely for looking up the organisation.
Then I created a report based on that query and put the rest of the queries that I needed to interrogate in as sub-reports with linked child and master fields tying them to the parameter query.
It's not ideal because it limits how I can manipulate the data but from the sounds of the amount of work involved with my original enquiry, it will be more sensible to stick with the workaround.
All the best
John
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Space marksIt is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names |
