Needle in a haystack

[PtotheC]

We are faced with a problem where we have a table and need to find “the last log” (From Table1.Field3):

[Please see Excel attachment for Table example] - Although we are using MS Access.

We need to:
1) Find “Log5 05/01/2008” from Field3 (we already have an idea what the date we are searching for)
2) Then return all text after that into a table or query

Please can you help?
Thank you

 

[s1police]

Can you use a query and using "*05/01/2008*", then txn(s) for the date will show up.