AnsweredAssumed Answered

Trying to report unique instances of duplicates after constraining find

Question asked by StephenWeiss on Dec 13, 2013
Latest reply on Dec 18, 2013 by philmodjunk

Title

Trying to report unique instances of duplicates after constraining find

Post

     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
      
     THANKS IN ADVANCE!

Outcomes