Really need query help!!

[Cam]

Hello,

I have an appended query that append data to a table based on several
criteria.
The tables include the following data:
Order Oper Status Date
123 80 2 8/17/09
123 90 1 8/17/09
123 100 1 8/17/09
123 110 1 8/17/09
123 120 1 8/17/09
123 130 1 8/17/09
123 130 2 8/21/09
123 140 1 8/17/09
250 10 1 8/17/09
250 20 2 8/17/09
250 30 1 8/17/09

I would like to create a select query to filter data where it will not show
any record where it match the Order then lowest oper number and before the
Status 2. Thanks Results would look like this.

Order Oper Status Date
123 130 2 8/21/09
123 140 1 8/17/09
250 20 2 8/17/09
250 30 1 8/17/09

 

[KARL DEWEY]

Do you have another field like an autonumber to indicate what the record
order is as you have multiple with same date and same Order and Oper?
Or does your date field include time?

 

[Cam]

Hi Karl,

Yes, I do have an autonumber as it is an appended table. How does it affect
the query? Thanks