Terms in a query

One way could be to create a number of queries:

Q_Null holds the Null record
Q_NullPlus1 finds the Null record plus the next
Q_NullMinus1 finds the Null record plus the previous (actually not the Null record as it is already in Q_NullPlus1)
Q_Null_Result joins the two above mentioned

Q_Null
SELECT NullPassnrResapost.Id
FROM NullPassnrResapost
WHERE (((NullPassnrResapost.Arbpassnr) Is Null));


Q_NullPlus1
SELECT TOP 2 NullPassnrResapost.Id, NullPassnrResapost.Arbpassnr
FROM NullPassnrResapost LEFT JOIN Q_Null ON NullPassnrResapost.Id = Q_Null.Id
WHERE (((NullPassnrResapost.Id)>=DLookUp("ID","Q_Null")));


Q_NullMinus1
SELECT TOP 1 NullPassnrResapost.Id, NullPassnrResapost.Arbpassnr
FROM NullPassnrResapost LEFT JOIN Q_Null ON NullPassnrResapost.Id = Q_Null.Id
WHERE (((NullPassnrResapost.Id)<DLookUp("ID","Q_Null")))
ORDER BY NullPassnrResapost.Id DESC;

Q_Null_Result
SELECT * FROM Q_NullPlus1
UNION
SELECT * FROM Q_NullMinus1

Like it?

Looks all fine to my, but how do i use it? Can you give me some guidance?

You are new to Access? Sorry.

1. Create a new query
2. Click OK
3. Do not select any tables or queries - just click Close
4. Select the SQL button or View/SQL ..
5. Paste the code from my answer
6. Save the query under the name above the code

Repeat this for each query

Thanks a lot.

Anytime  ;o)