Help with Microsoft Access please.
Evvy K
AlMoosani_exploring_a07_grader_h2_Rewards2.accdb| LocationID | City | Address | mSysRowId |
|---|---|---|---|
| 1.0 | Miami | Airport | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 2.0 | Boston | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 3.0 | Atlanta | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 4.0 | New York | Manhattan | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 5.0 | Chicago | Loop | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 6.0 | Pittsburgh | Point | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 7.0 | St. Paul | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 8.0 | Los Angeles | Airport | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 9.0 | Cleveland | Lake | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 10.0 | St. Louis | Convention Center | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 11.0 | Knoxville | Convention Center | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 12.0 | Houston | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 13.0 | Los Angeles | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 14.0 | Seattle | Airport | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 15.0 | Miami | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 16.0 | Las Vegas | Strip | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 17.0 | San Francisco | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 18.0 | Denver | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 19.0 | Portland | Downtown | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| 20.0 | New York | JFK | cgAEmiulIWLtykMXo9zuiYDaU6FuVdpeDqZf3NrK8QQ=-~SrLwE/drrTxmLpBGan6yJg== |
| MemNumber | LastName | FirstName | Address | City | State | Zip | Phone | MemberSince |
|---|---|---|---|---|---|---|---|---|
| 3385 | Haddad | Nabila | 1104 Brookside Drive | Vacaville | CA | 95687 | 600-887-1814 | 8/4/03 |
| 3391 | Harris | James | 212 Town Park Circle | Temple | TX | 76502 | 822-364-9273 | 1/23/02 |
| 3402 | Choi | Min | 486 Gem Place | Ronceverte | WV | 24970 | 822-292-6617 | 3/18/12 |
| 3407 | Ortiz | Ricardo | 191 Kelly Circle | Los Altos | CA | 94024 | 424-355-8347 | 12/3/96 |
| 3440 | Reyes | Riya | 827 Cape Seville Drive | Westfield | NY | 14787 | 555-523-1894 | 5/2/01 |
| 3443 | Liu | Feng | 1030 Barnett Drive | Indianapolis | IN | 46214 | 958-798-8127 | 11/13/95 |
| 3446 | Yamamoto | Hiroshi | 158 Telder Street | Spring | TX | 77393 | 833-876-2720 | 3/28/02 |
| 3463 | Diaz | Ana | 111 Mentra Court | Washington | DC | 20585 | 424-411-3041 | 11/16/93 |
| 3464 | Balasubramanium | Apoorva | 844 Sparks Avenue | South Pasadena | CA | 91030 | 236-763-5068 | 4/16/02 |
| 3465 | Yoshida | Minoru | 737 Ponds Circle | Dallas | TX | 75227 | 998-431-4730 | 3/11/00 |
| 3643 | Clark | Betty | 421 Omega Mine Circle | Littleton | CO | 80126 | 959-201-3190 | 7/13/90 |
| 3650 | Martinez | Rey | 864 Denise Drive | Stehekin | WA | 98852 | 822-986-3261 | 4/10/91 |
| 3652 | Liu | Cai | 231 Riviera Way | New Orleans | LA | 70190 | 969-369-7777 | 1/1/91 |
| 3676 | Choi | Whan | 634 Noblewood Street | Edgard | LA | 70049 | 998-822-5556 | 6/14/05 |
| 3678 | Diaz | Rey | 257 Port Orford Drive | Irvine | PA | 16329 | 958-449-8951 | 11/7/11 |
| 3679 | Yoon | Ryung | 217 Chugach Drive | Blythedale | MO | 64426 | 830-271-7889 | 3/11/11 |
| 3683 | Lee | Shik | 248 Liberty Road | Milwaukee | WI | 53204 | 351-936-6403 | 3/13/05 |
| 3684 | Patel | Rahul | 43 Mary Esther Drive | Encino | CA | 91436 | 950-830-9604 | 8/11/14 |
| 3689 | Yoo | Min | 677 Riffle Lane | Phoenix | AZ | 85065 | 950-776-9001 | 4/7/96 |
| 3701 | Ito | Toshio | 117 Flyway Avenue | Naval Air Station/ Jrb | TX | 76127 | 351-277-4831 | 6/11/97 |
| 3702 | Mukopadhyay | Ashwin | 357 Leyden Road | Fresno | CA | 93764 | 236-354-4827 | 9/18/00 |
| 3706 | Hyat | Loelia | 550 Fredricks Drive | Golden City | MO | 64748 | 424-607-2261 | 8/26/03 |
| 3709 | Anderson | Edward | 945 Ridge Park Drive | Pittsburg | KY | 40755 | 300-954-2356 | 5/18/01 |
| 3720 | Hussein | Messina | 51 Emerald Circle | Lloyd | FL | 32337 | 830-462-4864 | 11/14/11 |
| 3726 | Kimura | Ichiro | 615 Swan Circle | Dallas | PA | 18690 | 300-501-5487 | 12/7/99 |
| 7275 | Remaklus | Melissa | 1132 O'Brien Avenue | Manley Hot Springs | AK | 99756 | 830-598-1931 | 11/8/06 |
| 8960 | Atshan | Adnan | 550 Schuss Drive | Walcott | IA | 52773 | 833-701-4745 | 8/6/95 |
| ID | mSysRowId |
|---|---|
| 1 | WJaXz0XVDpma9Q8cwZGFPoBAFc3ULiJ7id/3VYC97dY=-~euIhzilVp1a/oEB9Tib+1Q== |
| OrderID | MemNumber | ServiceDate | ServiceID | NumInParty | Location | mSysRowId |
|---|---|---|---|---|---|---|
| 187 | 3701 | 6/21/17 | 5 | 3.0 | 7.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 188 | 3701 | 6/21/17 | 3 | 1.0 | 20.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 189 | 3701 | 6/21/17 | 2 | 2.0 | 11.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 220 | 3465 | 6/22/17 | 5 | 3.0 | 17.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 407 | 3391 | 7/10/17 | 6 | 3.0 | 1.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 408 | 3391 | 7/10/17 | 4 | 1.0 | 19.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 1127 | 7275 | 9/3/17 | 2 | 3.0 | 9.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 1128 | 7275 | 9/3/17 | 6 | 1.0 | 9.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 1175 | 3446 | 9/6/17 | 3 | 3.0 | 18.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 1176 | 3446 | 9/6/17 | 4 | 2.0 | 19.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 1793 | 3650 | 9/26/17 | 6 | 3.0 | 11.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 1794 | 3650 | 9/26/17 | 1 | 2.0 | 5.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 2459 | 3702 | 10/5/17 | 1 | 3.0 | 18.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 2460 | 3702 | 10/5/17 | 5 | 1.0 | 14.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 2689 | 3726 | 10/8/17 | 5 | 3.0 | 13.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 2693 | 3726 | 10/8/17 | 2 | 6.0 | 6.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 2694 | 3726 | 10/8/17 | 4 | 2.0 | 2.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 2729 | 3440 | 10/8/17 | 2 | 2.0 | 13.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 2730 | 3440 | 10/8/17 | 3 | 3.0 | 14.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 3587 | 3709 | 10/21/17 | 2 | 1.0 | 7.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 3588 | 3709 | 10/21/17 | 3 | 2.0 | 14.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 4027 | 3706 | 10/28/17 | 3 | 1.0 | 20.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 4032 | 3706 | 10/28/17 | 1 | 3.0 | 16.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5015 | 3679 | 11/9/17 | 1 | 1.0 | 13.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5016 | 3679 | 11/9/17 | 1 | 1.0 | 6.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5045 | 3407 | 11/10/17 | 4 | 2.0 | 16.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5046 | 3407 | 11/10/17 | 1 | 2.0 | 7.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5119 | 8960 | 11/11/17 | 2 | 2.0 | 19.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5124 | 8960 | 11/11/17 | 2 | 2.0 | 8.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5459 | 3684 | 11/14/17 | 5 | 2.0 | 16.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5460 | 3684 | 11/14/17 | 4 | 3.0 | 17.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 5646 | 3443 | 11/17/17 | 4 | 2.0 | 13.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 6133 | 3689 | 11/22/17 | 3 | 2.0 | 10.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 6138 | 3689 | 11/22/17 | 2 | 3.0 | 3.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 6203 | 3652 | 11/24/17 | 4 | 3.0 | 8.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 6204 | 3652 | 11/24/17 | 1 | 2.0 | 14.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 6971 | 3676 | 12/3/17 | 4 | 1.0 | 4.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 6972 | 3676 | 12/3/17 | 4 | 1.0 | 13.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 7151 | 3464 | 12/5/17 | 1 | 2.0 | 5.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 7152 | 3464 | 12/5/17 | 6 | 2.0 | 1.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 7435 | 3463 | 12/9/17 | 2 | 2.0 | 9.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 7436 | 3463 | 12/9/17 | 4 | 2.0 | 13.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 7439 | 3463 | 12/9/17 | 5 | 1.0 | 17.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 7440 | 3463 | 12/9/17 | 4 | 2.0 | 9.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 7799 | 3683 | 12/13/17 | 1 | 3.0 | 6.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 7800 | 3683 | 12/13/17 | 6 | 2.0 | 3.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 8425 | 3720 | 12/20/17 | 5 | 1.0 | 20.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 8430 | 3720 | 12/20/17 | 5 | 3.0 | 8.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| 8916 | 3402 | 12/25/17 | 3 | 2.0 | 11.0 | 1F3kTqSD+Cy1RzbQ61hg1M8o4AENTMd00T8IbPVwryc=-~wCNFgzN9HOcWdWIG5YTu7A== |
| ServiceID | ServiceName | PerPersonCharge | mSysRowId |
|---|---|---|---|
| 1 | Room | 185.0 | ui+ajffywJ9v3oPZbLrgde4zBOpBG5OUEj92O46sU/o=-~sVcl0c3iIx1+LWqymYBxOQ== |
| 2 | Conference Room | 10.0 | ui+ajffywJ9v3oPZbLrgde4zBOpBG5OUEj92O46sU/o=-~sVcl0c3iIx1+LWqymYBxOQ== |
| 3 | Suite | 245.0 | ui+ajffywJ9v3oPZbLrgde4zBOpBG5OUEj92O46sU/o=-~sVcl0c3iIx1+LWqymYBxOQ== |
| 4 | Banquet | 35.0 | ui+ajffywJ9v3oPZbLrgde4zBOpBG5OUEj92O46sU/o=-~sVcl0c3iIx1+LWqymYBxOQ== |
| 5 | Wedding | 20.0 | ui+ajffywJ9v3oPZbLrgde4zBOpBG5OUEj92O46sU/o=-~sVcl0c3iIx1+LWqymYBxOQ== |
| 6 | Event | 30.0 | ui+ajffywJ9v3oPZbLrgde4zBOpBG5OUEj92O46sU/o=-~sVcl0c3iIx1+LWqymYBxOQ== |
| Abbreviation | mSysRowId |
|---|---|
| AK | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| AL | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| AR | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| AS | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| AZ | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| CA | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| CO | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| CT | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| DC | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| DE | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| FL | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| FM | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| GA | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| GU | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| HI | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| IA | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| ID | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| IL | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| IN | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| KS | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| KY | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| LA | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MA | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MD | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| ME | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MH | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MI | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MN | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MO | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MP | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MS | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| MT | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| NC | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| ND | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| NE | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| NH | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| NJ | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| NM | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| NV | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| NY | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| OH | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| OK | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| OR | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| PA | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| PR | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| RI | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| SC | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| SD | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| TN | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| TX | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| UT | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| VA | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| VI | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| VT | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| WA | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| WI | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| WV | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
| WY | /t1Z7+iF03v4B9Vl7hHV4w9UdA1J2aCzTX0LE8BJ/fU=-~XyK7qsEd/IEwk7qj4AXr8w== |
SELECT DISTINCTROW *
FROM Members;
SELECT Location.City, orders.NumInParty, Service.PerPersonCharge, [NumInParty]*[PerPersonCharge] AS Revenue, Service.ServiceName
FROM Service INNER JOIN (Location INNER JOIN orders ON Location.LocationID = orders.Location) ON Service.ServiceID = orders.ServiceID;
SELECT Service.ServiceName, Sum([NumInParty]*[PerPersonCharge]) AS Revenue
FROM Service INNER JOIN (Location INNER JOIN orders ON Location.LocationID = orders.Location) ON Service.ServiceID = orders.ServiceID
WHERE (((Location.City) Like "*"))
GROUP BY Service.ServiceName;
