sammybee77
Technical User
Hi,
Please help!
I need to retrieve the comments from the most recent date. If for example Table1 contains the id, firstname, lastname and Table2 contains id date and comments. Table1 id = table2 id. Table 2 has the following data:
01/01/01 test comments 1
12/03/01 test comments2
12/02/01 test commments3
I want to be able to retrieve the comments with the most recent date everytime e.g. test comments2. How would you write a formula that would only ever bring up the data entered last?
Many thanks
Sam
Please help!
I need to retrieve the comments from the most recent date. If for example Table1 contains the id, firstname, lastname and Table2 contains id date and comments. Table1 id = table2 id. Table 2 has the following data:
01/01/01 test comments 1
12/03/01 test comments2
12/02/01 test commments3
I want to be able to retrieve the comments with the most recent date everytime e.g. test comments2. How would you write a formula that would only ever bring up the data entered last?
Many thanks
Sam