Recent content by Waterfly

Hi Ridders, Thanks, I've taken this approach as it seems the easiest at the moment!

Hi Ypma,, Thanks, just had a look at query1 but it still shows Jack and Justin twice? It should only show Jack's ordinary membership and Justin's life membership. Thanks for all your help!

Hi Ypma, I've updated the database, main things I've done is add an ID field to Memberstatus and linked this to the ID in Person Details. (It's a one to many relationship, e.g. one person can have many memberships). I've also created a form which will show you more easily what record I want to...

Sure, unfortunately my data is structured slightly differently, in that I have "Membership" which holds the type of membership and has an associated start and end date. Your query seems to work, but I would also like to be able to pull the last record for a person even if that last record is...

Hi, Yeah, the post went for moderation but has now been published above.

Hi, afraid this is my first time doing subqueries so a little confused. I've created this query looking to get the latest expiration date: SELECT Membership.MembershipID, Max(Membership.MembershipExpiry) AS MaxOfMembershipExpiry FROM Person_Details INNER JOIN Membership ON...

Thanks for the response, I have tried putting in something similar to the above, but it shows me the entire membership history as just opposed to the last membership record.

Attached is the form that is used to enter in data if that helps.

Hi, I am currently building a database that requires each person to have a membership, now they can be a "non-member", "ordinary" member which is a 1 year membership or a "life" member during different phases of time, what I want to do is be able to generate a report which shows me all the...