being the date a number, a summary field ( result date ) : Max ( cartesianSelfJoin::yourDateField )
could do the job.
Sorry, raybaudi, but I do not understand your answer at all. The date field is not a summary field nor a number field. And, I don't understand the cartesianselfjoin statement. In short, I'm thoroughly lost on your answer. But I do appreciate your taking the time to give it to me.
1) Duplicate your current table into the relationship graph
2) If the name of your table is ABC, you'll see a new one, named ABC 2
3) Connect two fields ( certainly not empty ) of both tables ( Normally it is used the ID field )
4) Doble click the = symbol between the two TO ( Table Occurencies ) and change it to "x"
You have just created a cartesian self join
Now, in the original table, create a new SUMMARY field ( result date ):
Max ( ABC 2::yourDateField )
That is all.
OK. I think I've gotten a little more understanding. And . . . it's actually doing what needs to be done. Now, the question is, will I remember what and why I did what I did the next time I do something to change the structure of my database? Time will tell.
Thank you for your patience and help. It's appreciated a lot!