I only want to show records with the latest date?

L

Lainy @ SAS

I have 2 tables. One has Member ID, Name, Date joined Club. The second has
record ID, Member ID, Date attendance valid from, and tick box fields for
Monday, Tuesday, Wednesday, Thursday, Friday. Members sometimes change the
dates they will be attending sessions and therefore subscription fees change.
How do I create a query that shows all members and the days they currently
attend? I do not want to show their attendance history!
 
D

doco

It seems to me given this description, the latest date would be the latest
record ID as well? If a date change would instance a new record? So sort
by member Id AND record ID descending.

doco
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Date and corresponding weekday to pull amounts 1
Search closest day in the past from today 2
Including multiple records in Mailmerge Doc 1
Working Days of Week and DUE DATE for PAYMENT 4
How do I change the sort order of days of the week? 2
How to check for missing required daily entries (records) 10
Count the number of times the date is a Monday, Tuesday, etc 5
Date Calculation 1

Top