ms access courses in london - Subquery?

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

Resolved · Low Priority · Version Standard

Subquery?

Sabrina has attended:
Access Advanced course

by - delegate Sabrina [3 posts] (2007 Mar 7 Wed, 09:37) Reply

How can I create a Subquery?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Subquery?

by - trainer David gold contributer [428 posts] (2007 Mar 7 Wed, 12:59) Reply

Hi Sabrina

Basically a subquery is query inside a query. If you want to write the SQL for this yourself, you can go into SQL view within the query. The code you need will be something very similar to this:

SELECT * FROM Yourtab1 WHERE YourName IN (SELECT YourName FROM Yourtab2 WHERE Yourtab2.SurnameName=Yourtab1.SurnameName);

Hope this helps

David

· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Get More Out of MS Access Courses
· Three Myths About Microsoft Access

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips