A
AndreasO
Subrecords contain a date and location field, (dates are entered in the
future, projected), meaning that the location can change many times for main
record items.
I try to filter the mainrecords by the current location, the last one
entered prior date().
When I sort them by date first and use <date() it will not only return the
main record in the current locations but I also find the main record again in
all prior locations, which are not current since they moved.
I can't find the correct expression.
Try run a macro to do this.
Thanks for your help.
Andreas
future, projected), meaning that the location can change many times for main
record items.
I try to filter the mainrecords by the current location, the last one
entered prior date().
When I sort them by date first and use <date() it will not only return the
main record in the current locations but I also find the main record again in
all prior locations, which are not current since they moved.
I can't find the correct expression.
Try run a macro to do this.
Thanks for your help.
Andreas