Access_2G_Concerts_Sponsors1.accdb
| Concert ID | Concert Name | Box Office Receipts | Date | Concert Location | Sponsor ID | mSysRowId |
| EVENT-101 | Spring Fling | ¤ 1,200.00 | 5/1/22 | Austin City Center | SPONSOR-101 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-102 | Pride of Texas | ¤ 575.00 | 6/15/22 | Texas Arts Center | SPONSOR-101 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-103 | Blues Festival | ¤ 500.00 | 9/10/22 | Austin City Center | SPONSOR-102 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-104 | Spirit of the Capital | ¤ 400.00 | | Austin City Center | SPONSOR-104 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-105 | Spanish Carols and Candles | ¤ 2,000.00 | 12/15/22 | Georgetown Community Theater | SPONSOR-107 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-106 | Jazz Alley Live | ¤ 400.00 | 9/30/22 | Austin City Center | SPONSOR-106 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-107 | Showtime Show Tunes | ¤ 1,900.00 | 11/18/22 | Georgetown Community Theater | SPONSOR-107 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-108 | Oldies Concert | ¤ 2,000.00 | 1/16/22 | Georgetown Community Theater | SPONSOR-108 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-109 | Bluebell Festival | ¤ 1,000.00 | 10/20/22 | Georgetown Community Theater | SPONSOR-103 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-110 | Cowboy Hospitality Tour | ¤ 800.00 | | Austin City Center | SPONSOR-103 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-111 | Texas Trail Songs | ¤ 500.00 | 4/20/22 | Austin City Center | SPONSOR-105 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-112 | Valentine Love Songs | ¤ 600.00 | 2/14/22 | Texas Arts Center | SPONSOR-101 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-113 | Fall Jazz Festival | ¤ 950.00 | 10/30/22 | Georgetown Community Theater | SPONSOR-101 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-114 | State Fair Concert | ¤ 2,500.00 | 8/15/22 | State Fairgrounds | SPONSOR-104 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-115 | Winter Jazz Festival | ¤ 975.00 | 1/23/22 | Austin City Center | SPONSOR-101 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-116 | Thanksgiving Festival | ¤ 500.00 | 11/24/22 | State Fairgrounds | SPONSOR-104 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| EVENT-117 | History of Blues | ¤ 675.00 | 3/15/22 | Texas Arts Center | SPONSOR-101 | qmfJ5AUmP7sw7YKAxr4Yg5hh5k9tQxcxzir1IWprkNc=-~A2q273fXvJ3c3qaNfDcXZA== |
| ID | mSysRowId |
| 1 | ePsRd/F0ZrWMOuC4KQ7s06zVAkNU3MZhg/UCa5RuZLQ=-~0QqrUM3qGm0emxym4F3/sQ== |
| Sponsor ID | Sponsor Name | Phone Number | Web Address | mSysRowId |
| SPONSOR-101 | KAUS Radio Station | (512) 555-0888 | www.kaus.rad |
|
| SPONSOR-102 | Austin Memorial Foundation | (512) 555-0557 | www.austinmf.com |
|
| SPONSOR-103 | Round Rock Chamber of Commerce | (512) 555-0077 | www.rrcc.biz |
|
| SPONSOR-104 | Georgetown Booster Club | (512) 555-3346 | www.georgetownbc.com |
|
| SPONSOR-105 | Texas Lakes CC Foundation | (512) 555-0090 | www.tlcc.edu/foundation |
|
| SPONSOR-106 | Bank of Texas | (512) 555-0666 | www.botexas.com |
|
| SPONSOR-107 | Dripping Springs City | (512) 555-0323 | www.codsprings.gov |
|
| SPONSOR-108 | KCEM Radio Station | (512) 555-0444 | www.kcem.rad |
|
SELECT Concerts.[Concert Name], Concerts.[Box Office Receipts], Concerts.[Concert Location]
FROM Concerts
WHERE (((Concerts.[Box Office Receipts])>=1000))
ORDER BY Concerts.[Concert Location];
Miky24
