ms access courses in london - Subquery?

Resolved · Low Priority · Version Standard

Wed 7 Mar 2007, 09:37 Delegate Sabrina said...

Sabrina has attended:
Access Advanced course

Subquery?

How can I create a Subquery?

Wed 7 Mar 2007, 12:59 Trainer David said...

RE: Subquery?

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

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips

ms access courses in london - Subquery?

Subquery?

RE: Subquery?

Access articles

Access tip:

Combo box for finding records