Access Module 7 SAM Project 1

profiletriceyr
IL_AC16_7a_LatriceReaves_1.accdb
IfSuccessful_Status GA_Status_Icon SAM_Logo
true
false
ID FirstName LastName AssignmentGUID UserID
false Latrice Reaves {81E75495-9AA6-4A61-A32A-1664864A97F8} {81E75495-9AA6-4A61-A32A-1664864A97F8}
ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion
ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder
Abbrev StateTerritory
AK Alaska
AL Alabama
AR Arkansas
AS American Samoa
AZ Arizona
CA California
CO Colorado
CT Connecticut
DC District Of Columbia
DE Delaware
FL Florida
FM Federated States Of Micronesia
GA Georgia
GU Guam
HI Hawaii
IA Iowa
ID Idaho
IL Illinois
IN Indiana
KS Kansas
KY Kentucky
LA Louisiana
MA Massachusetts
MD Maryland
ME Maine
MH Marshall Islands
MI Michigan
MN Minnesota
MO Missouri
MP Northern Mariana Islands
MS Mississippi
MT Montana
NC North Carolina
ND North Dakota
NE Nebraska
NH New Hampshire
NJ New Jersey
NM New Mexico
NV Nevada
NY New York
OH Ohio
OK Oklahoma
OR Oregon
PA Pennsylvania
PR Puerto Rico
PW Palau
QLD Queensland
RI Rhode Island
SC South Carolina
SD South Dakota
TN Tennessee
TX Texas
UT Utah
VA Virginia
VI Virgin Islands
VT Vermont
WA Washington
WI Wisconsin
WV West Virginia
WY Wyoming
CountryName
Australia
Bahamas
Belize
Bonaire
Brazil
Cayman Islands
Cuba
Curacao
Cyprus
Egypt
Fiji
Honduras
Israel
Jamaica
Mexico
United Kingdom
US Virgin Islands
USA
DiveMasterID LName Address City StateProvince ZipPostalCode PhoneNumber Birthday
1 Schwartz 111 Maple Street Filmont NM 77881 5555550101 5/5/83
2 Langguth 222 Oak Street Erie PA 34567 5555552344 2/29/80
3 Eagan 333 Elm Avenue New York City NY 15875 5555557890 2/26/89
4 Min 444 Lincoln Way Ft. Dodge IA 50111 5555557777 7/16/96
5 Friend 555 Perry Street Key Largo FL 29922 5555554545 9/5/77
6 Piper 12345 100th Street Long Beach CA 90222 5555551234 8/27/81
7 Kobach 12344 99th Street Branson MO 55880 5555557788 9/30/82
8 Huck 128 Main Street Green River FL 24242 5555557799 9/26/84
9 Lincoln 789 Jackson Street Dallas TX 68686 6662234343 1/30/86
10 Aaron 600 Lenexa Road Hartford CT 12345 2227060500 2/5/85
ID DiveMasterID Location City State Country StartDate Lodging TripPrice Rating Certification Participants TripReport
1 1 Great Barrier Reef Cairns Australia 5/13/17 Royal Palm ¤ 3,000.00 4.0 true 5 A goal of the trip is to help identify feeding locations for the humpback dolphin.
2 2 Grand Bahama Island Bimini Bahamas 2/6/17 Travel 6 Inn ¤ 2,000.00 4.0 false 6
3 2 Grand Bahama Island Nassau Bahamas 10/6/17 Marriott Sands ¤ 2,500.00 3.0 true 12
4 3 Grand Bahama Island Nassau Bahamas 12/29/16 Fairwind ¤ 2,200.00 4.0 false 10
5 4 Black Beards Cruises  Nassau Bahamas 4/30/15 Fairwind ¤ 2,400.00 4.0 false 11
6 5 Grand Bahama Island Nassau Bahamas 12/15/16 Fairwind ¤ 2,000.00 3.0 true 15
7 6 Ambergris Caye Belize City Belize 4/25/17 Sun Breeze ¤ 4,000.00 4.0 false 7
8 6 Ambergris Caye Belize City Belize 4/24/17 Sun Breeze ¤ 4,100.00 4.0 false 6
9 8 South Shore Kralendijk Bonaire 10/1/16 Pink Flamingo ¤ 3,900.00 4.0 false 4
10 9 South Shore Kralendijk Bonaire 6/19/17 Sea Star ¤ 3,600.00 4.0 false 5
11 8 South Shore Kralendijk Bonaire 10/2/16 Pink Flamingo ¤ 3,500.00 5.0 false 10 Overall, the trip was fantastic! The diving was absolutely spectacular! Some of our favorite sites are: Alice in Wonderland, Andrea II, and Pink Beach. Weather: We went October 9-16. This is their rainy season, but it only rained one day and didn't stop us from diving. Otherwise, it was partly cloudy to mostly sunny (bring sunscreen!) and the temperature was 85-90 degrees every day. There's always a nice breeze and the evenings cooled off really nice. Very comfortable.  
12 9 South Shore Kralendijk Bonaire 6/20/17 Sea Star ¤ 3,400.00 5.0 false 12 Three great dives today. Bari Reef, Salt Pier, and back to Bari for a REALLY late-night dive. The Salt Pier was exciting for us as we missed this dive the last time we were here. Dinner tonight was at Richards. Beautiful place! 
13 10 South Shore Kralendijk Bonaire 3/29/17 Sea Star ¤ 4,600.00 5.0 false 13 Oooh, Bonaire is a great place to be if you like relaxed vacations. You don't have to worry about boats leaving without you, or times of departure. You just hire a pick-up and off you go. Almost every dive site at the coastline, you can do a shore dive. This really is great and relaxing.  
14 10 South Shore Kralendijk Bonaire 5/18/16 Pink Flamingo ¤ 3,500.00 4.0 false 5
15 8 South Shore Kralendijk Bonaire 10/20/15 Sea Star ¤ 3,700.00 3.0 false 6
16 7 Fernando de Noronha Pernambuco Brazil 4/12/17 Port Arrowhead ¤ 4,900.00 3.0 false 3
17 7 Fernando de Noronha Pernambuco Brazil 8/3/17 Port Arrowhead ¤ 5,100.00 3.0 false 7
18 7 Angra dos Reis Rio de Janeiro Brazil 3/19/16 Sunset City ¤ 5,200.00 3.0 false 8
19 7 Arraial do Cabo  Rio de Janeiro Brazil 4/2/17 Sunset City ¤ 5,200.00 4.0 false 10
20 6 Arraial do Cabo  Rio de Janeiro Brazil 2/24/17 Sunset City ¤ 4,500.00 4.0 false 11
21 1 Grand Cayman  George Town Cayman Islands 5/11/16 Diving Lodge ¤ 3,300.00 4.0 false 13
22 2 Grand Cayman  George Town Cayman Islands 4/27/15 Diving Lodge ¤ 3,200.00 5.0 false 12 This has been the best vacation we have taken. The most relaxing and great diving. 
23 3 Grand Cayman  George Town Cayman Islands 8/31/16 Diving Lodge ¤ 3,300.00 5.0 false 11 As always, this trip to Cayman was great. The weather was good. The guests were great.
24 1 Grand Cayman  George Town Cayman Islands 8/31/16 Diving Lodge ¤ 3,100.00 5.0 false 10 This was our third trip to Grand Cayman, our second time with Cayman Diving Lodge. The day we went to Stingray City, we did two dives on the way there, had lunch on the boat, then dove Stingray City. The fish were abundant--many Parrotfish, Blennys (those guys are so cute!), Butterflyfish, Jacks, Tarpon, Snappers, Triggerfish, Spotted Drums Jawfish, and several Barracuda, Filefish, Flyingfish, Groupers, Hogfish, Morays, Scorpionfish, and Turtles. The highlights of this trip were the Turtles, Nurse Sharks, and Octopi. The night dives we did were filled with cool creatures. We saw Green Moray Eels, Sharptail Eels, Spotted Moray Eels (one so small that its head was about the size of a dime), Porcupinefish, Slipper Lobster, and Octopi.
25 1 Grand Cayman  George Town Cayman Islands 5/10/17 Sunset Hotel ¤ 3,000.00 4.0 false 16
26 2 Grand Cayman  George Town Cayman Islands 9/23/17 Sunset Hotel ¤ 3,100.00 4.0 false 8
27 5 West Shore Havana Cuba 1/22/15 Copa Cabana ¤ 2,900.00 3.0 true 7
28 3 East Shore Willemstad Curacao 7/2/16 Prince Resort ¤ 3,250.00 5.0 false 6
29 3 East Shore Willemstad Curacao 1/22/15 Prince Resort ¤ 3,300.00 4.0 false 6
30 4 Big Island Willemstad Curacao 5/6/17 Prince Resort ¤ 7,000.00 4.0 false 10
31 5 Summer Lake Hurghada Egypt 9/9/16 Ramada Inn ¤ 7,500.00 3.0 true 10
32 5 Winter Lake Sharm El Naga Egypt 9/30/16 Sala Dive Center ¤ 7,400.00 3.0 true 9
33 5 Winter Lake Sharm El Sheikh Egypt 9/29/15 Rosada Dive Center ¤ 8,300.00 3.0 false 8
34 5 Winter Lake Sharm El Sheikh Egypt 7/10/17 Rosada Dive Center ¤ 6,000.00 3.0 false 6
35 6 Two Islands Nadi Fiji 3/17/15 Coco Bay Resort ¤ 6,200.00 4.0 false 8
36 6 Two Islands Nadi Fiji 3/18/15 Coco Bay Resort ¤ 6,300.00 4.0 false 10
37 4 Sunset Reef Roatan Honduras 3/9/17 Tony's Resort ¤ 5,200.00 5.0 true 12
38 1 Sunset Reef Roatan Honduras 3/9/17 Tony's Resort ¤ 5,300.00 3.0 false 13
39 3 Sunset Reef Roatan Honduras 3/9/17 Lover's Bay Resort ¤ 5,400.00 4.0 false 11
40 3 Sunset Reef Roatan Honduras 10/14/17 Lover's Bay Resort ¤ 5,500.00 4.0 false 10
41 4 Sunset Reef Roatan Honduras 5/6/17 Lover's Bay Resort ¤ 5,000.00 3.0 false 8
42 2 Tree of Life Lake Eilat Israel 3/9/17 Kibbutz Dive ¤ 8,700.00 4.0 false 7
43 1 North Shore Montego Bay Jamaica 3/4/16 Village Sand ¤ 4,500.00 3.0 false 8
44 2 Flaming Reef Cabo San Lucas Mexico 4/28/16 Village by the Sea ¤ 3,000.00 4.0 false 8
45 2 Flaming Reef Cabo San Lucas Mexico 5/7/16 Village by the Sea ¤ 3,200.00 3.0 false 9
46 2 Flaming Reef Cabo San Lucas Mexico 4/29/16 Village by the Sea ¤ 3,100.00 3.0 false 10
47 3 Gold Shore Cancun Mexico 10/8/17 Hyatt Sands ¤ 3,300.00 4.0 false 12
48 4 Gold Shore Cancun Mexico 8/28/17 Hyatt Sands ¤ 3,400.00 4.0 false 12
49 5 Columbia Shallows Cozumel Mexico 3/4/15 Westin Del Mar ¤ 3,350.00 3.0 false 14
50 5 Columbia Shallows Cozumel Mexico 2/8/16 Westin Del Mar ¤ 3,600.00 3.0 false 10
51 5 Columbia Shallows Cozumel Mexico 2/6/16 Westin Del Mar ¤ 3,200.00 3.0 false 9
52 6 Columbia Shallows Cozumel Mexico 2/5/17 Atempo Resort ¤ 3,580.00 3.0 false 8
53 6 Columbia Shallows Cozumel Mexico 4/27/17 Atempo Resort ¤ 3,500.00 3.0 false 7
54 7 Columbia Shallows Cozumel Mexico 8/23/15 Atempo Resort ¤ 3,700.00 3.0 false 10
55 7 Columbia Shallows Cozumel Mexico 8/22/15 Atempo Resort ¤ 4,100.00 3.0 false 9
56 8 Columbia Shallows Cozumel Mexico 3/4/16 Royal Seas ¤ 4,100.00 3.0 false 8
57 9 Columbia Shallows Cozumel Mexico 3/5/16 Royal Seas ¤ 4,200.00 3.0 false 7
58 10 Columbia Shallows Cozumel Mexico 2/2/17 Royal Seas ¤ 4,300.00 3.0 false 5
59 10 Columbia Shallows Cozumel Mexico 2/3/17 Royal Seas ¤ 4,400.00 4.0 false 10
60 5 Columbia Shallows Cozumel Mexico 2/7/16 Scuba South Resort ¤ 4,200.00 4.0 false 4
61 6 Columbia Shallows Cozumel Mexico 4/26/17 Scuba South Resort ¤ 4,100.00 4.0 false 7
62 7 Columbia Shallows Cozumel Mexico 8/23/16 Scuba South Resort ¤ 3,900.00 4.0 false 9
63 8 Columbia Shallows Cozumel Mexico 3/5/16 Scuba South Resort ¤ 3,300.00 5.0 false 9
64 3 The Reef Club Cozumel Mexico 1/5/17 Scuba South Resort ¤ 3,200.00 3.0 false 10
65 2 The Reef Club Cozumel Mexico 6/25/15 Scuba South Resort ¤ 3,400.00 4.0 false 11
66 1 Blue Water Reef Ixtapa Mexico 4/2/15 Hyatt Ixtapa ¤ 3,900.00 3.0 false 12
67 10 Red Reef La Bufadora Mexico 2/11/17 4 Seasons Inn ¤ 4,280.00 3.0 false 13
68 5 Orange Reef La Paz Mexico 8/22/17 Hotel La Paz ¤ 5,000.00 4.0 false 7
69 4 Cat Eye Reef Mar de Cortez Mexico 9/25/16 Sweet Seas Resort ¤ 4,230.00 3.0 false 8
70 7 Tiger Reef San Carlos Mexico 3/28/17 Pedro Hotel ¤ 4,500.00 4.0 false 9
71 6 Manacles Porthkerris Cornwall United Kingdom 4/11/16 King James Castle ¤ 7,000.00 4.0 false 10
72 8 Porthkerris Cornwall United Kingdom 4/5/15 King James Castle ¤ 6,900.00 4.0 false 10
73 10 East Shore St. John US Virgin Islands 5/10/15 Pirates Cove Inn ¤ 5,000.00 3.0 false 9
74 8 Twin Grand Rivers Ketchikan AK USA 5/13/17 Timberwolf Lodge ¤ 3,000.00 4.0 false 8
75 6 Frog Reef Catalina Island  CA USA 8/21/17 Marriott Catalina ¤ 2,400.00 3.0 true 7
76 6 Frog Reef Catalina Island  CA USA 8/23/15 Marriott Catalina ¤ 2,300.00 3.0 true 10
77 4 Frog Reef Catalina Island  CA USA 3/9/16 Marriott Catalina ¤ 2,400.00 4.0 false 10
78 4 Frog Reef Catalina Island  CA USA 1/8/17 Hotel California ¤ 2,500.00 3.0 false 10
79 2 Daves Reef San Clemente CA USA 5/11/15 Galleon Resort ¤ 2,600.00 3.0 false 11
80 2 Daves Reef San Clemente CA USA 5/10/15 Galleon Resort ¤ 2,800.00 2.0 true 11
81 1 Little Reef Clearwater FL USA 7/22/16 Tropicana Inn ¤ 2,900.00 3.0 false 7
82 3 Little Reef Clearwater FL USA 6/8/15 Tropicana Inn ¤ 3,000.00 1.0 true 8
83 5 Manatee Island Crystal River FL USA 10/18/17 Westin Manatee ¤ 2,500.00 4.0 false 9
84 9 Indian Reef Key Largo FL USA 3/5/15 Key Largo Inn ¤ 2,400.00 3.0 false 9
85 7 Indian Reef Key Largo FL USA 4/30/17 Key Largo Inn ¤ 2,200.00 2.0 false 10
86 8 Indian Reef Key Largo FL USA 7/16/17 Best Western Key Largo ¤ 2,300.00 3.0 false 12
87 9 Blue State Park Key West FL USA 11/18/16 Westin Key West ¤ 1,000.00 3.0 false 13
88 10 Blue State Park Key West FL USA 12/15/17 Hyatt Sunset Harbor ¤ 1,400.00 2.0 false 11
89 5 Dragon Park Lake City FL USA 1/12/16 Sheraton 4 Seasons ¤ 1,500.00 3.0 false 10
90 4 Dragon Park Lake City FL USA 2/23/16 Spruce Inn ¤ 1,600.00 3.0 false 8
91 3 Tree Island Panama City FL USA 8/19/17 Iota Key Resort ¤ 1,320.00 3.0 false 7
92 3 Tree Island Panama City FL USA 12/24/17 Panama City Resort ¤ 1,200.00 3.0 false 8
93 2 Salt Island Ramrod Key FL USA 7/3/17 Lighthouse Inn ¤ 1,400.00 2.0 false 8
94 1 Lobster Island Tavernier FL USA 10/7/16 Pirates Ahoy Hotel ¤ 1,500.00 1.0 false 9
95 3 Fish House West Palm Beach FL USA 4/21/15 Motel 8 West Palm ¤ 1,400.00 2.0 false 10
96 5 Fish House West Palm Beach FL USA 3/10/15 Holiday Inn West ¤ 1,500.00 3.0 false 12
97 7 Fish House West Palm Beach FL USA 3/24/15 Holiday Inn West ¤ 1,800.00 3.0 false 12
98 9 Fish House West Palm Beach FL USA 7/29/15 Westin Beach House ¤ 2,200.00 3.0 false 14
99 10 Molokini Crater Molokai HI USA 3/9/17 Grand Beach Resort ¤ 4,500.00 3.0 false 10
100 5 Molokini Crater Molokai HI USA 3/9/17 Grand Beach Resort ¤ 4,600.00 4.0 false 9
101 3 Molokini Crater Molokai HI USA 11/13/15 Grand Beach Resort ¤ 4,900.00 4.0 false 8
102 4 Molokini Crater Molokai HI USA 8/9/17 Sand and Surf Resort ¤ 5,200.00 4.0 false 7
103 4 Molokini Crater Molokai HI USA 8/10/17 Sand and Surf Resort ¤ 5,250.00 5.0 false 10
104 5 South Maui Island  Maui HI USA 8/9/17 Hyatt Maui ¤ 5,260.00 4.0 false 9
105 6 Molokini Crater Molokai HI USA 8/7/17 Sand and Surf Resort ¤ 5,270.00 4.0 false 8
106 4 Spurgeon Lake Grand Springs IL USA 5/13/15 Holiday Inn Mermet ¤ 2,900.00 2.0 true 7
107 4 Spurgeon Lake Grand Springs IL USA 5/14/15 Holiday Inn Mermet ¤ 2,500.00 3.0 true 5
108 4 Spurgeon Lake Grand Springs IL USA 5/15/15 Red Roof Inn ¤ 2,600.00 3.0 true 10
109 2 Bass Lake Logansport IN USA 10/29/15 Logan's Point Hotel ¤ 2,800.00 3.0 true 12
110 2 Bass Lake Logansport IN USA 10/30/15 Logan's Point Hotel ¤ 2,900.00 4.0 true 13
111 10 Sawfish Lake Rockport MA USA 10/24/15 Rock Lodge ¤ 3,500.00 3.0 true 14
112 7 Mark Twain Lake Bonne Terre MO USA 7/25/15 Lucky 13 Lodge ¤ 2,890.00 4.0 true 8
113 7 Mark Twain Lake Bonne Terre MO USA 7/26/15 Lucky 13 Lodge ¤ 2,290.00 4.0 true 9
114 7 Table Rock Lake Branson MO USA 7/13/16 Big Cedar Lodge ¤ 2,690.00 3.0 true 8
115 10 Delaware Water Gap Manasquan NJ USA 8/11/16 La Quinta Inn ¤ 2,700.00 1.0 true 10
116 10 Delaware Water Gap Manasquan NJ USA 8/12/16 La Quinta Inn ¤ 2,750.00 2.0 true 12
117 1 Pontiac Reserve Santa Rosa NM USA 9/28/16 Ramada Inn ¤ 2,800.00 2.0 false 13
118 2 Gilboa Quarry Ottawa OH USA 6/19/16 Marriott Ottawa ¤ 2,850.00 3.0 false 11
119 2 Shawnee River Portage OH USA 6/23/17 Marriott Portage ¤ 3,150.00 3.0 false 10
120 2 Racoon Quarry Bethlehem PA USA 7/29/17 Red Roof Inn ¤ 3,170.00 3.0 false 8
121 2 Racoon Quarry Bethlehem PA USA 7/28/17 Red Roof Inn ¤ 3,250.00 3.0 false 7
122 2 Red River Dingman's Ferry PA USA 9/2/17 Hotel 6 ¤ 3,350.00 3.0 true 8
123 2 Green River Dutch Springs PA USA 7/11/17 Super 8 ¤ 3,220.00 3.0 true 8
124 2 Large Island Lake Erie PA USA 9/2/15 Holiday Inn Lake Erie ¤ 2,875.00 3.0 false 9
125 8 Outpost Island Charleston SC USA 11/4/15 Fairfield Inn Charleston ¤ 2,870.00 4.0 false 10
126 9 Turtle Island Myrtle Beach SC USA 9/16/17 Super 8 ¤ 2,200.00 4.0 false 12
127 8 Turtle Island Myrtle Beach SC USA 9/20/16 Super 8 ¤ 2,200.00 3.0 false 12
128 9 Snake Island Tyler TX USA 6/2/17 Hotel 6 ¤ 1,500.00 1.0 false 14
129 4 Devil's Lake Baraboo WI USA 5/8/15 Holiday Inn Baraboo ¤ 1,400.00 2.0 true 10
SELECT DISTINCTROW * FROM DiveTrips;
SELECT DISTINCTROW * FROM DiveTrips;
SELECT DISTINCTROW * FROM DiveTrips;
SELECT DISTINCTROW * FROM DiveMasters;
SELECT [DiveMasters].[LName], [DiveTrips].[Location], [DiveTrips].[City], [DiveTrips].[State], [DiveTrips].[Country], [DiveTrips].[StartDate], [DiveTrips].[Rating], [DiveTrips].[Participants], [DiveMasters].[DiveMasterID] FROM DiveMasters INNER JOIN DiveTrips ON [DiveMasters].[DiveMasterID] =[DiveTrips].[DiveMasterID];
SELECT Countries.CountryName FROM Countries ORDER BY Countries.CountryName;
SELECT Divemasters.LName, Divemasters.PhoneNumber, Divemasters.Birthday FROM Divemasters ORDER BY Divemasters.LName;
SELECT Divemasters.LName FROM Divemasters ORDER BY Divemasters.LName;
SELECT DiveTrips.Location, DiveTrips.Country, DiveTrips.State, DiveTrips.City, DiveTrips.StartDate FROM DiveTrips;
SELECT DiveTrips.ID, Divemasters.LName, DiveTrips.City, DiveTrips.Country, DiveTrips.StartDate, DiveTrips.Rating, DiveTrips.Participants FROM Divemasters INNER JOIN DiveTrips ON Divemasters.DiveMasterID = DiveTrips.DiveMasterID;
SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, "Score is: " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, [_GradingReportSteps].[StepScore] & "/" & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;
SELECT Divemasters.LName, DiveTrips.Participants FROM Divemasters INNER JOIN DiveTrips ON Divemasters.DiveMasterID = DiveTrips.DiveMasterID;
SELECT DiveTrips.Location, DiveTrips.City, DiveTrips.Country, DiveTrips.StartDate, DiveTrips.TripPrice FROM DiveTrips;
SELECT DiveTrips.Location, DiveTrips.Country, DiveTrips.State, DiveTrips.City, DiveTrips.StartDate FROM DiveTrips WHERE (((DiveTrips.Country)="USA"));