Duplicates replacement text

[hnorgaar]

Can anyone give me a hint to catch duplicates in a query where 1 column are different, example
1 record is empty and 1 is "Striped" and my result should be 1 record with this text "For triped and Non striped" and therefore only give me 1 record
There are multiple combinations so the solution is not to just add that as a criteria, but rather a table with the translations I have considered so far with a unique number for them, but cant get empty to be considered as 1. Thx in advance

[isladogs]

Your question isn't very clear but try using the unmatched query wizard on the ribbon.

[orange]

??? Suggest you provide another example to clarify requirement??
Perhaps show us a few records and your current query sql.

[Gicu]

Looks like the OP is looking to concatenate the values in one column, so maybe theDBGuy's function (or any other one) would do the trick:
http://www.accessmvp.com/thedbguy/co...itle=simplecsv

Cheers,