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.

Orders
OrderID PK
Date
Total

Registrations
RegistrationID PK
OrderID FK
Fullname


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

EG: OUTPUT

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.