Find order record where unit number is only after unit #3 1

[Louise99]

I have a table where there are many customer numbers. There could be more than one order for each on any given day. I only want to know the records where a customer orders unit #3 and THEN orders something else.

So, my query output would show
Customer Date Unit
AAA 1/1/07 3
AAA 1/1/07 6

So, I just want to see the actual "3" (with the date) and the next unit.

I obviously don't have a clue! Any ideas?

Thanks!

 

[lameid]

Query1:

Select Customer, [Date]
From Table1
Where Unit = 3

Query2:

Select Customer, [Date], Unit
From Table1 Inner Join Query1 ON Table1.Customer = Query1.Customer and Table1.Date and query1.Date