Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Trying to report unique instances of duplicates after constraining find

  •
Steve Weiss
in Finding & Searching

Featured Replies

  • Newbies
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!

Create an account or sign in to comment
Go to topic listing

Similar Content

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.