membership-b.accdb
| ID | MemberNo | ActivityDate | HoursWorked |
| 1 | 6 | 12/31/13 | 8 |
| 2 | 7 | 12/31/13 | 8 |
| 3 | 9 | 12/31/13 | 8 |
| 4 | 13 | 1/27/14 | 4 |
| 5 | 18 | 1/27/14 | 4 |
| 6 | 12 | 1/27/14 | 4 |
| 7 | 8 | 1/27/14 | 6 |
| 8 | 11 | 1/27/14 | 2 |
| 9 | 16 | 1/29/14 | 5 |
| 10 | 14 | 1/29/14 | 5 |
| 11 | 19 | 1/29/14 | 5 |
| 12 | 20 | 1/29/14 | 4 |
| 13 | 17 | 1/29/14 | 5 |
| 14 | 28 | 1/30/14 | 10 |
| 15 | 27 | 1/30/14 | 8 |
| 16 | 25 | 1/30/14 | 4 |
| 17 | 26 | 1/30/14 | 4 |
| 18 | 13 | 3/27/14 | 4 |
| 19 | 18 | 3/27/14 | 4 |
| 20 | 10 | 3/29/14 | 4 |
| 21 | 15 | 3/29/14 | 4 |
| 22 | 20 | 3/29/14 | 4 |
| 23 | 3 | 3/29/14 | 4 |
| 24 | 33 | 3/29/14 | 4 |
| 25 | 1 | 3/29/14 | 4 |
| 26 | 17 | 3/29/14 | 5 |
| 27 | 16 | 3/29/14 | 5 |
| 28 | 14 | 3/29/14 | 5 |
| 29 | 19 | 3/29/14 | 5 |
| 30 | 15 | 3/30/14 | 8 |
| 31 | 26 | 3/30/14 | 4 |
| 32 | 27 | 3/30/14 | 8 |
| 33 | 28 | 3/30/14 | 10 |
| 34 | 25 | 3/30/14 | 4 |
| 35 | 31 | 3/30/14 | 8 |
| 36 | 32 | 3/30/14 | 8 |
| 37 | 29 | 3/31/14 | 8 |
| 38 | 6 | 3/31/14 | 8 |
| 39 | 27 | 3/31/14 | 8 |
| 40 | 8 | 4/27/14 | 6 |
| 41 | 11 | 4/27/14 | 2 |
| 42 | 1 | 12/30/14 | 4 |
| 43 | 15 | 12/30/14 | 4 |
| 44 | 10 | 12/30/14 | 4 |
| 45 | 3 | 12/30/14 | 4 |
| 46 | 2 | 12/30/14 | 4 |
| 47 | 15 | 12/31/14 | 8 |
| 48 | 5 | 12/31/14 | 8 |
| 49 | 4 | 12/31/14 | 8 |
| 50 | 13 | 1/27/14 | 4 |
| 51 | 5 | 1/22/15 | 4 |
| 52 | 12 | 1/22/15 | 4 |
| 53 | 8 | 1/22/15 | 6 |
| 54 | 11 | 1/22/15 | 2 |
| 55 | 16 | 1/24/15 | 5 |
| 56 | 14 | 1/24/15 | 5 |
| 57 | 21 | 1/24/15 | 5 |
| 58 | 20 | 1/24/15 | 4 |
| 59 | 19 | 1/24/15 | 5 |
| 60 | 28 | 1/25/15 | 10 |
| 61 | 7 | 1/25/15 | 8 |
| 62 | 25 | 1/25/15 | 4 |
| 63 | 1 | 1/25/15 | 4 |
| 64 | 27 | 3/22/15 | 4 |
| 65 | 18 | 3/22/15 | 4 |
| 66 | 10 | 3/24/15 | 4 |
| 67 | 24 | 3/24/15 | 4 |
| 68 | 20 | 3/24/15 | 4 |
| 69 | 15 | 3/24/15 | 4 |
| 70 | 2 | 3/24/15 | 4 |
| 71 | 1 | 3/24/15 | 4 |
| 72 | 17 | 3/24/15 | 5 |
| 73 | 4 | 3/24/15 | 5 |
| 74 | 22 | 3/24/15 | 5 |
| 75 | 9 | 3/24/15 | 5 |
| 76 | 23 | 3/25/15 | 8 |
| 77 | 26 | 3/25/15 | 4 |
| 78 | 3 | 3/25/15 | 8 |
| 79 | 14 | 3/25/15 | 10 |
| 80 | 25 | 3/25/15 | 4 |
| 81 | 31 | 3/25/15 | 8 |
| 82 | 32 | 3/25/15 | 8 |
| 83 | 29 | 3/26/15 | 8 |
| 84 | 6 | 3/26/15 | 8 |
| 85 | 15 | 3/26/15 | 8 |
| 86 | 8 | 4/22/15 | 6 |
| 87 | 13 | 4/22/15 | 2 |
| FirstName | LastName | Street | ZipCode | Birthday | Dues | MemberNo | Retired |
| Micah | Mayberry | 52411 Wornall Road | 64145 | 8/20/85 | ¤ 75.00 | 1 | false |
| Allie | Eahlie | 5246 Crabapple Road | 64145 | 12/25/70 | ¤ 75.00 | 10 | false |
| Brenda | Daniels | 661 Reagan Road | 64145 | 12/24/69 | ¤ 75.00 | 11 | false |
| Sindy | Dotey | 50966 Lowell Rd | 66210 | 11/1/61 | ¤ 75.00 | 12 | false |
| Martha | Duman | 651 N. Ambassador Drive | 64153 | 9/5/59 | ¤ 75.00 | 13 | false |
| Jana | Eckert | 903 East 504th St | 64131 | 4/18/62 | ¤ 75.00 | 14 | false |
| Quentin | Garden | 53305 W. 99th Street | 66215 | 8/14/55 | ¤ 75.00 | 15 | true |
| Loraine | Goode | 900 Barnes Road | 50265 | 10/6/61 | ¤ 75.00 | 16 | false |
| Gabriel | Hammer | 664 Carthage Rd | 64131 | 4/19/69 | ¤ 75.00 | 17 | false |
| Jeremiah | Hopper | 100 Main St | 64111 | 2/10/60 | ¤ 75.00 | 18 | false |
| Helen | Hubert | 2345 Grand Blvd | 64108 | 3/2/82 | ¤ 75.00 | 19 | false |
| Josiah | Alman | 2505 McGee St | 64141 | 6/4/79 | ¤ 75.00 | 2 | false |
| Heidi | Kalvert | 7066 College Blvd | 66211 | 9/5/61 | ¤ 100.00 | 20 | false |
| Benjamin | Martin | 5253 Duck Creek Dr | 52240 | 7/16/63 | ¤ 100.00 | 21 | false |
| Karla | Larson | 3966 Woodland Ave | 50266 | 1/6/62 | ¤ 100.00 | 22 | false |
| Jose | Martin | 52345 College Blvd | 66210 | 11/30/51 | ¤ 100.00 | 23 | true |
| Katrina | Margolis | 52345 College Blvd | 66210 | 8/1/70 | ¤ 100.00 | 24 | false |
| Harvey | Mackintosh | 2584 E. Meyer Blvd | 64132 | 5/23/70 | ¤ 100.00 | 25 | false |
| Jon | Maxim | 105 Mission Road | 66206 | 8/18/60 | ¤ 100.00 | 26 | false |
| Patch | Mullins | 66020 King Street | 66210 | 7/4/71 | ¤ 100.00 | 27 | false |
| Young | Nelson | 895 Lowell St | 66210 | 9/6/61 | ¤ 75.00 | 28 | false |
| Mallory | Olson | 300 Adams St | 64114 | 1/29/45 | ¤ 75.00 | 29 | true |
| Bart | Bouchart | 5200 Main Street | 64105 | 5/5/60 | ¤ 75.00 | 3 | false |
| Sally | Olingback | 2330 Shawnee Mission Pkwy | 66205 | 11/5/50 | ¤ 75.00 | 30 | true |
| Su | Vogue | 509 Johson Dr | 66210 | 7/19/61 | ¤ 75.00 | 31 | false |
| Taney | Wilson | 52345 College Blvd | 66210 | 3/22/50 | ¤ 75.00 | 32 | true |
| Sherry | Walker | 466 Lincoln Way | 64145 | 9/6/60 | ¤ 75.00 | 33 | false |
| Maggie | Yode | 52345 College Blvd | 66210 | 7/3/72 | ¤ 75.00 | 34 | false |
| Joshua | Parton | 200 Washington St | 64111 | 2/15/61 | ¤ 75.00 | 35 | false |
| Jaye | May | 1515 Maple St | 50033 | 9/30/60 | ¤ 75.00 | 36 | false |
| Martin | Chen | 1010 Green St | 50022 | 8/19/80 | ¤ 75.00 | 37 | false |
| Forrest | Browning | 8206 Marshall Drive | 66214 | 9/4/61 | ¤ 100.00 | 4 | false |
| Mary | Bovier | 110 College Blvd | 66031 | 10/1/89 | ¤ 100.00 | 5 | false |
| Golga | Collins | 520 West Elm | 64105 | 3/1/47 | ¤ 100.00 | 6 | true |
| Mark | Camel | 66020 King Street | 66210 | 6/19/60 | ¤ 75.00 | 7 | true |
| Mildred | Custard | 66900 College Blvd | 66210 | 6/12/58 | ¤ 75.00 | 8 | false |
| Holly | Cabriella | 52520 W. 505 Terr | 66215 | 1/1/54 | ¤ 75.00 | 9 | true |
| ZipCode | City | State2 |
| 50022 | Bridgewater | IA |
| 50033 | Fontanelle | IA |
| 50265 | Greenfield | IA |
| 50266 | Running Deer | MO |
| 52240 | Des Moines | IA |
| 64105 | Lee's Summit | MO |
| 64108 | Leawood | MO |
| 64111 | Kansas City | MO |
| 64114 | Kansas City | KS |
| 64131 | Overland Park | KS |
| 64132 | Lenexa | KS |
| 64141 | Flat Hills | KS |
| 64145 | Shawnee | KS |
| 64153 | Blue Springs | MO |
| 66031 | Manhattan | KS |
| 66205 | Hollister | KS |
| 66206 | Langguth | KS |
| 66210 | Red Bridge | KS |
| 66211 | Manawatta | KS |
| 66214 | Dripping Springs | KS |
| 66215 | Clear Water | KS |
SELECT DISTINCTROW *
FROM CONTACTS
PIVOT null;