Hi folks.
I'm trying to create a table with races across the top and club members down the side.
The results from each race should display in the corresponding columns.
The problem is - some members will not compete in some events.
How can I create this from a table of members and a table of events?
I'm stuck!

It should be as simple as specifying the join in the query...

You're probably looking at a left join so that in the query your from clause looks like

FROM tblmembers LEFT JOIN tblevents on (tblmembers.member=tblevents.winner)