Hi,
I have a table with members in it, and within that a sub-table that I can enter multiple shows, their dates and points earned for each show.
I have put together a query on this table that includes a sum of all points by member.
I would like to be able to include a 'Set Start Date and Finish Date' so I can do an annual query to see who has earned the most points in a 12 month period but when I add the date to the query I lose the 'Sum of all points' and each date has it's own entry (so I get the same member multiple times instead of one single total entry).
Is there any way to get a total of all entry's by date range?
Happy to share the database with anyone who might be able to assist.
Cheers.