> Why are my categories duplicating in access 2010?

Why are my categories duplicating in access 2010?

Posted at: 2014-12-18 
Without seeing the table structure or the query its hard to diagnose.

You may have a cartesian join, for example

You could try adding DISTINCT after the SELECT statement.

Impossible to help you without seeing:

1. Your query.

2. Your table relationships.

need to check your query and e-r diagram

I am trying to create a query but my items keep duplicating when i am only trying to have it appear once, i have primary keys bu they still duplicate, i am trying to take information from two tables for my query, please help i need help asap