Any Access wizards in here?

find the primary key in both databases (i.e. product ID), then you will use a left join based on that primary key. From there you should have a table with duplicate product IDs (i.e. rows) for equipment with multiple failures. From there, you can do a couple of things do query out products IDs listed more than 2 times.

(This is all assuming those tables are how I think they are in my head).

ETA: If your tables have foreign keys (multiple columns in both fields that relate the tables to one another) that would be better than using a primary key.

Not sure if you still needed this. Assuming you have 2 tables:

equipment - fields are equipmentid and equipment description.

failures - fields are failureid, equipmentid_fk, failuredescription, and failuredate.

A possible query to get you what you want would be:

SELECT e.equipmentdescription, Count(f.equipmentid_fk) AS CountOfequipmentid_fk
FROM equipment AS e, failures AS f
WHERE (((e.equipmentid)=[f].[equipmentid_fk]) AND ((f.failuredate)>=#6/1/2022# And (f.failuredate)<=#6/3/2022#))
GROUP BY e.equipmentdescription
HAVING (((Count(f.equipmentid_fk))>=3));

Should you get all part descriptions and a count of the failures with 3 or more between 06/01/2022 and 06/03/2022.

$5k for a license to do something that can be done in Access or SQL?

Alteryx has some cool stuff, but mostly appears to be a GUI for a less than competent DBA.

quote:

---

WHERE (((e.equipmentid)=[f].[equipmentid_fk]) AND ((f.failuredate)>=#6/1/2022# And (f.failuredate)<=#6/3/2022#))

---

In the "WHERE" part of the clause, is there a reason for the brackets around [f].[equipmentid_fk], and could I use the following for my failure date parameters?

WHERE (((e.Func_Loc)=[f].[Func_Loc]) AND ((f.Failure_Date)>=(Date()-1095) And (f.Failure_Date)<=Date())