G
Guest
Is there a way to select a record with the most recent date? On our server
(SQL2000) we want to use Access to select records from a View base on a Job
Number (which is a text field). Of those records, we are looking for the most
recent/latest recorded operation by date on each Work Order (basically, a Job
number can have many, possibly hundreds, of operations that are recorded by
date and location). Each operation for each Work order number has a record,
one for each operation. Of course we can feed it the Job or Work order
number, but it still requires us to manually sift thru all date fields for
each Job or Work order to see if they are complete; or no date, which is
incomplete.
Any direction on this would be greatly appreciated.
(SQL2000) we want to use Access to select records from a View base on a Job
Number (which is a text field). Of those records, we are looking for the most
recent/latest recorded operation by date on each Work Order (basically, a Job
number can have many, possibly hundreds, of operations that are recorded by
date and location). Each operation for each Work order number has a record,
one for each operation. Of course we can feed it the Job or Work order
number, but it still requires us to manually sift thru all date fields for
each Job or Work order to see if they are complete; or no date, which is
incomplete.
Any direction on this would be greatly appreciated.