AnsweredAssumed Answered

Trying to report unique instances of duplicates after constraining find

Question asked by savingprivatedata on Dec 13, 2013
Latest reply on Dec 20, 2013 by Oliver_Reid

Trying to report unique instances of duplicates after constraining find

I have the following structure;

 

FIELDS;

UniqueID

Equip_ID

Location

TestNumber

TestDate

 

This table records each test number that a piece of equipment performs, along with the date of the test and the location.

 

There are often multiple tests per piece of equipment on a given day.

I'm trying to report the following;

1) Multiple instances of a Equip_ID in a given time period.

2) Locations transmitting from Equip_ID in a given timer period.

 

I want to be able to take this;

 

Equip_ID | Location | TestNumber | TestDate

1 NewYork 111 10-5-2013

1 NewYork 112 10-5-2013

1 NewYork 113 10-5-2013

2 Utah 245 10-5-2013

3 California 345 10-6-2013

3 California 346 10-6-2013

4 Oklahoma 400 10-6-2013

4 Oklahoma 401 10-6-2013

5 Florida 405 10-7-2013

6 Illinois 450 10-7-2013

6 Illinois 451 10-7-2013

6 Illinois 452 10-7-2013

7 NewYork 500 10-7-2013

7 NewYork 500 10-7-2013

8 Florida 530 10-8-2013

8 Florida 531 10-8-2013

1 NewJersey 575 10-10-2013

 

And display single instances of LOCATIONS that transmitted tests from more than one Equip_ID;

For the month of Oct.2013;

Equip_ID | Location | TestDate

1 NewYork 10/2013

7 NewYork 10/2013

5 Florida 10/2013

8 Florida 10/2013

 

AND

 

Display Equip_ID that transmitted from multiple locations

For the month of Oct.2013;

Equip_ID | Location | TestDate

1 NewYork 10/2013

1 NewJersey 10/2013

Outcomes