Difficult Query Request

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

At the risk of committing spreadsheet (I'm an excell user trying to learn
access)

My database records look like so:

Side Type
Buy A
Sell A
Buy A
Sell B

The records come in sequence with the "matching" buy and sell in adjacement
records.

Is it possible to only the "Buy" were the matching sell has the same Type.
In this example, only the first record would be filtered.

Thank you in advance.
 
!!!!!! Access tables have no defined order like Excel. When you put data into
cells in Excel then save and close the spreadsheet, you can fully expect the
data to be in the same place the next time you open it.

NOT IN ACCESS! The next time that you open the database your records could
be scattered all over the place. The only way that you can ensure the data
will be in the same relative place is if you have something like a sequential
number in another field. Then in a query you could sort on this field.

Besides records in a table should NEVER depend on the placement of another
record. That's just bad database design.
 
Back
Top