Access Case 4 Mod 6

SELECT DISTINCTROW * FROM tblHiker;

SELECT tblHiker.HikerFirst, tblHiker.HikerLast, tblHiker.Address, tblHiker.City, tblHiker.State, tblHiker.Zip, tblHiker.Phone FROM tblHiker WHERE (((tblHiker.HikerLast) Like "s*")) ORDER BY tblHiker.HikerLast;

SELECT tblHiker.HikerID, tblHiker.HikerFirst, tblHiker.HikerLast, tblHiker.Address, tblHiker.City, tblHiker.State, tblHiker.Zip, tblHiker.Phone, tblReservation.ReservationID, tblReservation.TourID, tblReservation.TourDate, tblReservation.People FROM tblHiker INNER JOIN tblReservation ON tblHiker.HikerID = tblReservation.HikerID;

SELECT tblHiker.HikerFirst, tblHiker.HikerLast, tblHiker.City, tblHiker.State, tblHiker.Phone FROM tblHiker LEFT JOIN tblReservation ON tblHiker.[HikerID] = tblReservation.[HikerID] WHERE (((tblReservation.HikerID) Is Null));

SELECT tblTour.TourID, tblTour.TourName, tblTour.TourType, tblTour.Hours, tblTour.Description, tblTour.PricePerPerson FROM tblTour WHERE (((tblTour.TourType)="Hiking") AND ((tblTour.PricePerPerson)<=100)) ORDER BY tblTour.PricePerPerson DESC;

SELECT qryHikersAndReservations.[HikerID], qryHikersAndReservations.[HikerFirst], qryHikersAndReservations.[HikerLast], qryHikersAndReservations.[TourID], qryHikersAndReservations.[TourDate], qryHikersAndReservations.[People] FROM qryHikersAndReservations WHERE (((qryHikersAndReservations.[HikerID]) In (SELECT [HikerID] FROM [qryHikersAndReservations] As Tmp GROUP BY [HikerID] HAVING Count(*)>1 ))) ORDER BY qryHikersAndReservations.[HikerID];

SELECT tblTour.[TourID], tblTour.[TourName], tblTour.[TourType], tblTour.[Hours], tblTour.[Description], tblTour.[PricePerPerson] FROM tblTour WHERE ((Not (tblTour.[TourType])="Hiking")) ORDER BY tblTour.[TourName];

TRANSFORM Sum(qryHikersAndReservations.[People]) AS SumOfPeople SELECT qryHikersAndReservations.[TourID], Sum(qryHikersAndReservations.[People]) AS [Total Of People] FROM qryHikersAndReservations GROUP BY qryHikersAndReservations.[TourID] PIVOT qryHikersAndReservations.[HikerID];

SELECT tblHiker.HikerID, tblHiker.HikerFirst, tblHiker.HikerLast, tblHiker.Address, tblHiker.City, tblHiker.State, tblHiker.Zip, tblHiker.Phone FROM tblHiker WHERE (((tblHiker.State)="NC" Or (tblHiker.State)="SC" Or (tblHiker.State)="GA")) ORDER BY tblHiker.HikerLast;

SELECT TOP 50 PERCENT tblTour.TourID, tblTour.TourName, tblTour.TourType, tblTour.Hours, tblTour.Description, tblTour.PricePerPerson FROM tblTour WHERE (((tblTour.TourType)="Hiking") AND ((tblTour.PricePerPerson)<=100)) ORDER BY tblTour.PricePerPerson DESC;

SELECT tblTour.TourID, tblTour.TourName, tblTour.TourType, tblTour.Hours, tblTour.Description, tblTour.PricePerPerson FROM tblTour WHERE (((tblTour.TourType) Like "*" & [Enter tour type phrase: ] & "*")) ORDER BY tblTour.TourName;

SELECT DISTINCTROW * FROM tblHiker;