Duplicates appearing

[Thompyt]

Why do I get duplicates for "ZIBFC32 (TO'd frm FA BN)" in qryRadios?



If I look at data, there are 4 Rows where [Row Type] are 3 that = "MEQUIP" and 1 = "DISMEQUIP"

When I rune rptMtdRadios I get 6 Lines where there should be 3, thus ea line is duplicated.

Please do not comment on the naming conventions. The table named data is an imported Excel not developed by me.

Test.zip

[ranman256]

some queries will produce 'duplicates' depending on the joins and/or the fields in the query.

you can set the query property UNIQUE RECORDS = TRUE, to not see them.

[June7]

You get 6 records in query because there are two T37588 in tbllcons and 3 in Data associated with "ZIBFC32 (TO'd frm FA BN)" -- 2 times 3 = 6. Without the filter criteria there would be 10 records in query for T37588.

Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention.

[Thompyt]

Thanks June7 and Ranman. The duplicates in the tbleIcon explain a lot. Plus I used Ranmans tip.

Appreciate it.