duplicates missing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a table which contains costs where some records are the same (not
duplicates but the lines contain exactly the same info). I then have a simple
query based on this table but it is only showing one of the lines which have
the same info in them. How do I get the query to show ALL the records
including lines that contain the same info?
thanks
Tim
 
As a guess, you have the query property Unique Values set to Yes.

Open the query in SQL view and if the query starts with "SELECT Distinct
....", delete the word "Distinct".

In the query grid view, right click in the grey area at the top and select
Properties. In the property dialog, set the Unique values property to No.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
Compare/Hide Dupliactes based on one field 5
append query question in Access97 1
Selecting unique record from duplicate 2
Duplicates in union query 3
Want to edit a table based on a query of a query of several querie 2
Multiple records in a query 4
challenging query 3

Back
Top