I'ts been a long time since I've created Access reports hence the problem.

I'm trying to create a simple multi-column report where the data is grouped by country, but I'm getting duplicate records. See attachment.

Any help appreciated.

- you're not getting a duplicate record, you are getting one product, distributed to two countries - two records.

- if you want to group by country, put the country field first in the query.
- your query is quite complex. you might (or might not) have to approach it again starting with only one or two tables and make sure you get the results you expect then slowly add criteria.
- experiment with outer joins if necessary.

Thanks. I will try that and come back if I still have a problem.