Attached Access
workup582
New1_Exp19_Access_Ch4_Cap_Farm.accdb| PresenterID | ExhibitID | mSysRowId |
|---|---|---|
| 1 | 1 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 1 | 4 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 1 | 9 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 1 | 10 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 1 | 13 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 1 | 14 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 2 | 1 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 3 | 2 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 3 | 6 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 3 | 9 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 4 | 9 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 4 | 12 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 5 | 2 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 5 | 7 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 5 | 13 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 6 | 6 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 7 | 2 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 7 | 3 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 7 | 8 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 7 | 12 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 8 | 9 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 8 | 10 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 9 | 13 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 10 | 5 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 10 | 8 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 10 | 11 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 11 | 2 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 12 | 6 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 13 | 2 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 13 | 7 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| 13 | 9 | 8Crf58BZ8xe8W2r7UZRi792rqjAhSp8WM5l5sb3MZNk=-~8/UgwM6EFEJ175DCxhmNiA== |
| ExhibitID | ExhibitTitle | LocationID | Date | StartingTime | mSysRowId |
|---|---|---|---|---|---|
| 1 | Skills Competition I | 101 | 9/1/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 2 | Rabbit Show | 103 | 9/1/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 3 | Dairy Show | 104 | 9/1/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 4 | Sheep and Goat Show | 101 | 9/1/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 5 | Swine Show | 101 | 9/2/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 6 | Vegetable Exhibit | 102 | 9/2/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 7 | Breeding Techniques | 105 | 9/2/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 8 | Virtual Garden Tour | 105 | 9/2/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 9 | Horticulture | 104 | 9/2/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 10 | Recruiting for Your Chapter | 102 | 9/3/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 11 | Herb Exhibit | 103 | 9/3/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 12 | Skills Competition II | 101 | 9/3/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 13 | Basic Animal First Aid | 104 | 9/3/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| 14 | Volunteer Opportunities | 101 | 9/3/21 | 12/30/99 | gNDsGHVR9iGMAjft6123jUJixJtzId8IQz/7StVHbtM=-~yXfxW6eGAwZiOfK3ujtAAg== |
| LocationID | Capacity | Outdoors | Refreshments | Notes | mSysRowId |
|---|---|---|---|---|---|
| 101 | 150 | true | false | Main stage | VYnd55i0jN1TZufeuAQlTEGLb4n2q1I3WfESGaTZQeQ=-~IfBN3mxUM4rux5LLnvZDwA== |
| 102 | 100 | true | true | VYnd55i0jN1TZufeuAQlTEGLb4n2q1I3WfESGaTZQeQ=-~IfBN3mxUM4rux5LLnvZDwA== | |
| 103 | 50 | true | true | VYnd55i0jN1TZufeuAQlTEGLb4n2q1I3WfESGaTZQeQ=-~IfBN3mxUM4rux5LLnvZDwA== | |
| 104 | 25 | true | false | Small display outside the main office | VYnd55i0jN1TZufeuAQlTEGLb4n2q1I3WfESGaTZQeQ=-~IfBN3mxUM4rux5LLnvZDwA== |
| 105 | 75 | false | false | VYnd55i0jN1TZufeuAQlTEGLb4n2q1I3WfESGaTZQeQ=-~IfBN3mxUM4rux5LLnvZDwA== | |
| 106 | 75 | true | true | VYnd55i0jN1TZufeuAQlTEGLb4n2q1I3WfESGaTZQeQ=-~IfBN3mxUM4rux5LLnvZDwA== | |
| 107 | 50 | true | true | VYnd55i0jN1TZufeuAQlTEGLb4n2q1I3WfESGaTZQeQ=-~IfBN3mxUM4rux5LLnvZDwA== |
| ID | mSysRowId |
|---|---|
| 1 | mrAFVYPVDyBJVjEMC48yWkHyb1OaP2ueHWnMTSUstd8=-~6aOxHdk3ggNUq4Sv/83Zaw== |
| PresenterID | FirstName | LastName | Address | City | State | ZipCode |
|---|---|---|---|---|---|---|
| 1 | Shannon | Beck | 368 Graham Avenue | Graham | KY | 42344 |
| 2 | Sheila | Gibson | 139 Park Avenue | Benton | IL | 62812 |
| 3 | Alexander | Jackson | 182 Route 20 | Monroe | LA | 71207 |
| 4 | Leroy | Chavez | 122 East 24th Street | Guys | TN | 38339 |
| 5 | Andrea | Rose | 244 Curtis Place | Harrisburg | PA | 17128 |
| 6 | Jennifer | George | 100 20th Avenue | Waynesburg | KY | 40489 |
| 7 | Robert | Matthews | 262 Graham Avenue | Stem | NC | 27581 |
| 8 | Kyle | Shelton | 355 Curtis Place | Fort Totten | ND | 58335 |
| 9 | Eric | Ross | 372 East 21st Street | Bayamon | PR | 00958 |
| 10 | Ida | Walton | 360 Graham Avenue | Higden | AR | 72067 |
| 11 | Phillip | Perkins | 15 Ryle Avenue | Radersburg | MT | 59641 |
| 12 | Harold | Rogers | 253 Main Street | Deer Grove | IL | 61243 |
| 13 | Janice | Harvey | 33 Main Street | Willard | UT | 84340 |
| 14 | Connie | Hoffman | 196 Curtis Place | La Mirada | CA | 90637 |
| 15 | Dana | Taylor | 44 Montclair Avenue | Bloomington | IL | 61704 |
| 16 | Marvin | Rodriguez | 166 Market Street | Peoria | IL | 61641 |
| 17 | Chetan | Rana | 10000 SW 59 Court | Lake Norden | SD | 57248 |
| ID | FirstName | LastName | Address | City | StateProvince | PostalCode | FeePaid | mSysRowId |
|---|---|---|---|---|---|---|---|---|
| 8 | Tatiana | Toribio | 124 West Windmore Dr | New Fairfield | CT | 6812 | true |
SELECT Rooms.RoomID
FROM Rooms
ORDER BY [RoomID];
PARAMETERS __SpeakerID Value;
SELECT DISTINCTROW *
FROM [SELECT [Speaker - Session Query].SpeakerID, [Speaker - Session Query].SessionID, [Speaker - Session Query].SessionTitle, [Speaker - Session Query].RoomID, [Speaker - Session Query].Date, [Speaker - Session Query].StartingTime FROM [Speaker - Session Query]]. AS [Speakers Form]
WHERE ([__SpeakerID] = SpeakerID);
SELECT Presenters.FirstName, Presenters.LastName, Exhibits.ExhibitTitle, Exhibits.LocationID, Exhibits.Date
FROM Presenters INNER JOIN (Exhibits INNER JOIN ExhibitPresenter ON Exhibits.ExhibitID = ExhibitPresenter.[ExhibitID]) ON Presenters.PresenterID = ExhibitPresenter.[PresenterID];
