Variation on Dupe query

[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

 

[Tom Ellison]

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

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Razor]

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