Apply filter to one record and the following record

[Pinas]

Hello all,

i have one question concerning those filters in access (the one that are usable without writing code).

Is it possible to apply the filter for two records e.g., Record A: Table Age -> 20, Record B: Table Age -> 30.

So I have a list of Couples (A is partner 1, A+1 is partner 2) and I want to get all couples with a age difference of >= 10.

Thank you very much

[Rabbit]

No, you can't apply different filters in different rows. You'll have to create a query that joins the two people and filter for the difference in age there.