Getting queries to reference other queries

The UK's most regular instructor-led training courses.
Training information: access advanced courses · Microsoft access courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

2 posts

ReplyTue 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!

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

210 posts

ReplyMon 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

2 posts

ReplyMon 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

· User-Proofing Your Access Database: Part 2
· User-Level Security In Access
· So You Still Haven't Learned How To Use Access Yet?
· Practice Microsoft Access Database Decorum To Reap The Rewards
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps

Please browse our web site to find out more about
access advanced courses and other Microsoft training courses.

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips