Recent content by derekd99

I have the same problem

Many thanks for your help. It worked perfectly. Sub queries are new to me. I don't know SQL and thought you needed that for sub queries.

Hi, I am missing something here. I have used Access for years but taught myself how to use it. I have a table with name, club members details ID etc. This is linked by a 1 to many link (ID) to a table containing details of membership subscription payments. One entry/row per membership period...