Hi all,
I have an MS Access 365 database with a table that stores ID Numbers, Facilitator ID Numbers, Dates, etc.
When the user captures the data, each student can have more that 1 date (one to many), so the data is stored in the table as follows:
StudID, Course, StartDate, Enddate
1234, 123, 02-01-2023, 02-01-2023
1234, 123, 07-01-2023, 07-01-2023
1234, 123, 16-01-2023, 16-01-2023
1111, 123, 02-01-2023, 02-01-2023
1111, 123, 07-01-2023, 07-01-2023
1111, 123, 16-01-2023, 16-01-2023
2222, 123, 02-01-2023, 02-01-2023
2222, 123, 07-01-2023, 07-01-2023
2222, 123, 16-01-2023, 16-01-2023
All 9 records are being written to the table. All that differs, is the StudID numbers.
Using SQL statement "SELECT * FROM Tbl_Transaction.... WHERE Course = '123'" results all 9 records to be retrieved.
All data I require, is the 3 different startdates and the 3 different enddates. I am sorting the data by StudID and then by EndDate.
Is there perhaps a SQL statement that I can use just to retrieve the 3 dates from the table? Maybe a conditional statement?
As always, much appreciated.
Thanks
Deon