I have a table called Mileage that allows users to record their daily start and stop odometer reading. I created a virtual column called MostRecent that grabs the last entry based in a timestamp: MAXROW(Mileage, Timestamp)
This is so I can set the initial value of the odometer start with MostRecent (yesterday’s end reading) It’s working but I need it to look for the current user’s last entry… not just the last entry. Is there some kind of WHERE clause I can use when setting my initial value = MostRecent?
My Mileage table has an email field so I like to specify WHERE UserEmail() = Email