K
K
Good day,
I am not sure how to do this but here is what I would like to do based on a
query.
I have a table with the following information and field names
CNTRNUM CNTRDESC LastOfSTATUS DATE APPEND_TS MaxOfTIME_STAMP NOTE
321 CBIN 3230 Available 5/6/2008 5/7/2008 8:34:14 AM 5/6/2008 11:00:36 AM
322 CBIN 3230 Available 5/6/2008 5/7/2008 8:34:14 AM 5/6/2008 11:00:36 AM
323 CBIN 3231 Available 5/6/2008 5/7/2008 8:34:14 AM 5/6/2008 11:44:58 AM
323 CBIN 3230 Available 5/7/2008 5/7/2008 8:34:14 AM 5/7/2008 8:29:57 AM
323 CBIN 3230 Out 5/6/2008 5/7/2008 8:34:14 AM 5/6/2008 11:00:44 AM Delphi
So to summarize this information CBIN 3230 has a few records however the
last known status is "Available" as dictated by the Append Time Stamp
(APPEND_TS) how do I filter this record out to be showing in a report.
Basically I want to only show the latest status of a contianer by the
APPEND_TS.
Any help would be appreciated.
Thanks for your time.
I am not sure how to do this but here is what I would like to do based on a
query.
I have a table with the following information and field names
CNTRNUM CNTRDESC LastOfSTATUS DATE APPEND_TS MaxOfTIME_STAMP NOTE
321 CBIN 3230 Available 5/6/2008 5/7/2008 8:34:14 AM 5/6/2008 11:00:36 AM
322 CBIN 3230 Available 5/6/2008 5/7/2008 8:34:14 AM 5/6/2008 11:00:36 AM
323 CBIN 3231 Available 5/6/2008 5/7/2008 8:34:14 AM 5/6/2008 11:44:58 AM
323 CBIN 3230 Available 5/7/2008 5/7/2008 8:34:14 AM 5/7/2008 8:29:57 AM
323 CBIN 3230 Out 5/6/2008 5/7/2008 8:34:14 AM 5/6/2008 11:00:44 AM Delphi
So to summarize this information CBIN 3230 has a few records however the
last known status is "Available" as dictated by the Append Time Stamp
(APPEND_TS) how do I filter this record out to be showing in a report.
Basically I want to only show the latest status of a contianer by the
APPEND_TS.
Any help would be appreciated.
Thanks for your time.