Query Criteria - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Query Criteria

Robert Freeman

15 months ago

Hi. I have a simple membership database that show, amongst many things, the membership year. I need to set a up a query but I'm struggling to get the correct criteria working.

The query must just show a list of members names that WERE members in 2024 but HAVE NOT renewed for 2025.

The members names are held in table 1 and the membership year is held in table 2.

Can anyone point me in the right direction please.

	Sami Shamma @Reply 15 months ago
Please be more specific. See Rule #2. Table design screenshots will help

	Alex Hedley @Reply 15 months ago
Does Membership have a Foreign Key that links back to Members? To start you off you'll need to join the Tables together: `SELECT m.Name FROM Members m LEFT JOIN Memberships ms ON ms.MemberID = m.MemberID` Then you'll need some way to filter it by the Years `WHERE ms.Year = 2024 ...` See how you get on from there

	Robert Freeman OP @Reply 15 months ago

	Alex Hedley @Reply 15 months ago
Year Month Day

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View