TheCleaner
Technical User
1st let me thank everyone for the help I have received here just from reading. Now I am faced with on that I have yet to find the answer in any privious post. Quick brief:
I have a form that I use to imput new records. When placing the information in the form I need a search to occur from the data that I place in the form as I go along. In the [Name] field I place a value of "John Doe" the search then begins looking for a record that has already been created several times with the same name. However I need data from his latest(most recent) record to calculate information for this new record. I'm thinking a sort/search query that will find the same name as the record I'm putting in with the latest date (or even greatest record #). Grab the data out of that records [EndTime] and use it in my calculation for [RestTime] in the new record. I have the module for the getelapsed time funtion, so in short I'm asking; What would I have to do to get the info from that field ([endtim]), from an old record with the same value (in [name] of the new record), with the latest date. Sorry so long and drawn out. I am NOT a programmer, but after this endevor I want to be.
I have a form that I use to imput new records. When placing the information in the form I need a search to occur from the data that I place in the form as I go along. In the [Name] field I place a value of "John Doe" the search then begins looking for a record that has already been created several times with the same name. However I need data from his latest(most recent) record to calculate information for this new record. I'm thinking a sort/search query that will find the same name as the record I'm putting in with the latest date (or even greatest record #). Grab the data out of that records [EndTime] and use it in my calculation for [RestTime] in the new record. I have the module for the getelapsed time funtion, so in short I'm asking; What would I have to do to get the info from that field ([endtim]), from an old record with the same value (in [name] of the new record), with the latest date. Sorry so long and drawn out. I am NOT a programmer, but after this endevor I want to be.