duplicates missing

T

Tim

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
 
J

John Spencer

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.
 
Top