Another question of mine.



I have an index and a date in a List of submitted reports.
Now I want to do the following:
Every dataset that was changed after the last submitted report should be marked in another color.
The query would be something like get the hightest id, get the corresponding date and compare the date of the dataset with this date.

Does anyone has a hint? I thought about nestled DMax() functions but that didn't work.

Edit:
just solved it myself. Since one can DMax a date I just compare the date of the dataset with the DMax date of the list of submitted reports.