Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access courses in london - 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
Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.
Using the Sum function gives the total for the whole group, not a running total.
Access provides an easy method of achieving a running total.
Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
