Aliases
Need to change the name look at this video and let me know if this helped out.

You need to make it an Or condition. Move 2024 down to the first Or row.
From your image you are saying the MembershipYear has to equal 2023 AND 2024. It can't equal both years.
Also, I am assuming the data type is a number so you don't need the quotes.

Do you really need to column for MembershipYear?
Could you add MembershipYear once and make the criteria 2023 Or 2024?

Hi all and thanks for the suggestions. To expand: I have a 'MembershipPaymentsT' in which is recorded any payments made by members during any given year. One of the fields is 'MembershipYear' - currently 2023 or 2024 but this will change as years are added in the future.
What I am trying to achieve is an easy to read report that shows a member's name and then a series of columns showing in which year they were a member:
FirstName  |  LastName  |  2023  |  2024   etc.

I can run a query that will show this with the information BUT the membership year is shown in a single column. I can sort on any of the columns of course but none of the sort options give me the single line result I'm trying to achieve.

Eventually I would like to replace the 'year' with text that shows 'Paid' but that's the next step!

FYI aliases do not seem to work either.

Have you considered using Grouping in the report?