Unanswered: Access 2007: Records duplicated in query results
I have a simple database which is basically a list of company documentation. One of the fields is a drop down menu for the document status as in: published (on the intranet), archived etc. There is also an autonumber field so that each record can be uniquely identified.
I want to make a report to show all 'published' documents, however duplicate data has appeared in the query and is therefore showing in my report. It is definitely duplicated at the query level because the autonumber appears in duplicate (and triplicate) for various records, but not all and not in the table. I did also try deleting the duplicate record but this only deleted the original record from the table.
I have only basic knowledge of Access and I do not know any SQL. Please can someone tell me how to fix this or what I am doing wrong!
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
I just have the table with all the data in it ("Document Database"), then a very simple query to find all records from that table where the "status" field is marked "published" that is it! No queries on queries. I used the query wizzard and have also tried making one from scratch. Same result with some random duplications here and there....
I have made other similar queries to separate out single fields, some work with no duplication and others dont. I am stuck as to why this is happening.