Variation on Dupe query

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

I need to return records that contain dupes on Field1 AND
non-dupes on Field2.

The dupe query wizard will satisfy first requirement, but
how can I alter it to meet second requirement too?

Thanks!

Regards,
Razor
 
Dear Razor:

I would suggest you use a cross product with filtering. This is an
alternative to using joins that supports more types of filtering.

SELECT *
FROM Table1, Table2
WHERE Table1.Field1 = Table2.Field1
AND Table1.Field2 <> Table2.Field2

Using a construction like the above, it may be more obvious how to add
additional criteria such as you propose.

Note that this is an "ancient" form of joining two table from before
there were JOINs. It still works.

Hi,

I need to return records that contain dupes on Field1 AND
non-dupes on Field2.

The dupe query wizard will satisfy first requirement, but
how can I alter it to meet second requirement too?

Thanks!

Regards,
Razor
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Tom:
Thanks for your help so far.
I have only one table I am trying to filter.
Would you recommend the SQL for this?
Regards,
Razor
 
Back
Top