Results 1 to 7 of 7
Thread: Access Sub Query
Feb 2, 2010, 06:31 #1
- Join Date
- Oct 2003
- Tenerife, Spain / UK
- 0 Post(s)
- 0 Thread(s)
Access Sub Query
Going around in circles again with Access SQL
I have a database that lets people register themselves and their friends for a working holiday. There is a registration fee to be paid for each person signing up to join.
I have an Orders Table and a Registrations table.
I need to do a report that shows a list of orders by date, but imports the Fullname from the first registration found connected to this order to give a LEAD NAME
Order ID | Date | Lead Name | Total
This should be fairly simple nested sub-query (right?) but I'm getting tied in knots with Access.
Any help appreciated.