filtering records

[guest]

see the query1 which gicu send. if you filter first year to 2021 then doc number 19 you will see each record has duplicate.

Year Searching	Doc number	Transfer	Subnumber	Date of receivng
2021	19	489/2020	1	15.01.2021
2021	19	489/2020	1	15.01.2021

something like this not to paste all duplicate records here.

[Welshgasman]

I was looking at qryDelovodnikForumAll ?

Perhaps try Select Distinct

[Gicu]

Yes, SELECT DISTINCT (in Query1) should eliminate the duplicates.

SELECT DISTINCT qryDelovodnikForumAll.[Year Searching], qryDelovodnikForumAll.[Doc number], qryDelovodnikForumAll.Transfer, qryDelovodnikForumAll.Subnumber, qryDelovodnikForumAll.DateofReceivng
FROM qryDelovodnikForumAll INNER JOIN [DelovodnikForum Query1] ON (qryDelovodnikForumAll.[Year Searching] = [DelovodnikForum Query1].[Year Searching]) AND (qryDelovodnikForumAll.[Doc number] = [DelovodnikForum Query1].[Doc number])
ORDER BY qryDelovodnikForumAll.[Doc number], qryDelovodnikForumAll.Subnumber;

Cheers,

[guest]

Yes you are right. they disappeared. now is fine. thanks again.