Missing duplicate records in query

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

Guest

I am running a query to select all payment and payment reversal records for a
corporation based on company name. When I do this I lose seven records
because they match similar records. I want these records included in my
query. What am I doing wrong to not see these records in my query.

P.S. The duplicate records exist in my table.
 
I am running a query to select all payment and payment reversal records for a
corporation based on company name. When I do this I lose seven records
because they match similar records. I want these records included in my
query. What am I doing wrong to not see these records in my query.

P.S. The duplicate records exist in my table.
Click to expand...

Correct the error (which might be a Group By, a Join, a criterion, or
some other error) in your query.

Since we cannot see the query, it's more than a bit hard to suggest
what to change. Please open the query in SQL view and post the SQL
text here, and we'll be able to do so.

Note that the webpage often seems to be giving bogus error messages -
you posted several times already. Please ignore the message, at least
for an hour or so until someone has a chance to respond.

John W. Vinson[MVP]
 
Back
Top