Display Correct As Of Column

[messier]

I have 2 tables

Table 1: Student Name: Registered Date: Index Number
Table 2: Index Number: Address: Mobile


My Query
Correct As At Date: Registered Date: Student Name: Index No: Mobile


For the above 5 columns, while the Registered date will be different in each row based on the student, i want the correct as at date to display the Max of Registered date.

in excel - it would be =Max(Registered Date) for each row.
How do I do this?

[kd2017]

https://www.techonthenet.com/access/...omain/dmax.php

[Gicu]

You could create another totals query in which you group by student number and get the max of registration date, then join that into your original (by student number). Or you could use a subgueery. Or domain aggregate (the slowest option) like dMax.

Cheers,

[messier]

Thank you!