Query based on Query

S

Sharon

I have a query that returns my patent records. I used that query, Query1,
and created a new query using another table, Assignment Information, Query2.
The primary key for both tables is PatentID. The join is all records from
Query1 and those from Assignment Information where the fields are equal. The
problem is that the first query shows the appropriate number of patents, but
the second query shows the same patent 10 times. There don't appear to be
any duplicate fields, so I am not sure why there are so many duplicate
records.
 
D

Dorian

It would help if you posted the SQL of your queries.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 

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

Query Based on Another Query 7
Append Crosstab Query to Existing Table 0
Crosstab query totals 3
loop though records in a query? 5
Make query headings just contain field names? 1
Query keeps looking for Query1 field 3
QBF & Query Malfunction 0
Many to Many/lnktable/query 2

Top