Microsoft office 365 Access 2016

PARAMETERS __OptionID Value; SELECT DISTINCTROW * FROM tblMember AS frmPlansWithMembers WHERE ([__OptionID] = OptionID);

SELECT DISTINCTROW * FROM tblOption;

SELECT DISTINCTROW * FROM tblOption;

SELECT tblOption.OptionID, tblOption.OptionDescription, tblOption.OptionCost, tblOption.FeeWaived FROM tblOption;

SELECT tblMember.OptionEnd, tblMember.MemberID, tblMember.OptionID, tblMember.FirstName, tblMember.LastName, tblMember.Street, tblMember.City, tblMember.State, tblMember.Zip, tblMember.Phone, tblMember.OptionBegin FROM tblMember WHERE (((tblMember.OptionEnd) In (SELECT [OptionEnd] FROM [tblMember] As Tmp GROUP BY [OptionEnd] HAVING Count(*)>1 ))) ORDER BY tblMember.OptionEnd;

SELECT tblMember.LastName, tblMember.FirstName, tblOption.OptionDescription, tblOption.OptionCost, IIf([FeeWaived],"Fee Waived","Fee Not Waived") AS FeeStatus FROM tblOption INNER JOIN tblMember ON tblOption.[OptionID] = tblMember.[OptionID];

SELECT tblOption.OptionID, tblOption.OptionDescription, tblOption.OptionCost, tblOption.FeeWaived FROM tblOption WHERE (((tblOption.OptionCost) Not In (70,125,140,250))) ORDER BY tblOption.OptionID DESC;

SELECT tblOption.OptionID, tblOption.OptionDescription, tblOption.OptionCost, tblOption.FeeWaived FROM tblOption WHERE (((tblOption.OptionCost) In (70,125,140,250))) ORDER BY tblOption.OptionID DESC;

SELECT tblMember.MemberID, tblMember.OptionID, tblMember.FirstName, tblMember.LastName, tblMember.Street, tblMember.City, tblMember.State, tblMember.Zip, tblMember.Phone, tblMember.OptionBegin, tblMember.OptionEnd FROM tblMember WHERE (((tblMember.City) Like [Type the City: ] & "*"));

SELECT [FirstName] & " " & [LastName] AS MemberName, tblMember.Street, [City] & " " & [State] & " " & [Zip] AS CityLine, tblMember.Phone FROM tblMember;

SELECT tblMember.FirstName, tblMember.LastName, tblMember.Phone FROM tblMember LEFT JOIN tblOption ON tblMember.[OptionID] = tblOption.[OptionID] WHERE (((tblOption.OptionID) Is Null));

SELECT tblMember.LastName, tblMember.FirstName, tblMember.City, tblOption.FeeWaived, tblOption.OptionDescription, tblOption.OptionCost FROM tblOption INNER JOIN tblMember ON tblOption.[OptionID] = tblMember.[OptionID] WHERE (((tblMember.City)="Orlando" Or (tblMember.City)="Celebration") AND ((tblOption.FeeWaived)=True));

SELECT TOP 25 PERCENT tblMember.FirstName, tblMember.LastName, tblMember.Phone, tblMember.OptionEnd, tblMember.OptionID FROM tblMember ORDER BY tblMember.OptionEnd;

SELECT DISTINCTROW * FROM tblMember;