Dear all,
I have a single [date of membership] in one table, and multiple [visit date]'s in another table. I have a form in which I want to display the difference between the two dates. I also want the record for that visit in the table to retain that calculated time elapse.
I have tried using a query but don't seem to be able to get it to work. I suspect the one -to-many relationship is a factor.
Any ideas?