----qryNV02
SELECT tblCustomer.custFname, custLname, custDateJoin, tblSalesrep.srepFname, srepLname
FROM tblCustomer, tblSalesrep
WHERE tblCustomer.srepNum = tblSalesrep.srepNum
GROUP BY custDateJoin;

----qryNV03
SELECT srepFname, srepLname
FROM tblCustomer, tblSalesrep
WHERE tblCustomer.srepNum = tblSalesrep.srepNum
AND tblCustomer.custProv = 'ON';

----qryNV04
SELECT tblSalesrep.srepNum, srepFname, srepLname, tblCustomer.custType
FROM tblSalesrep, tblCustomer
WHERE tblCustomer.srepNum=tblSalesrep.srepNum And tblCustomer.custType='GOLD';

----qryNV05
SELECT  COUNT(tblCustomer.custNum) AS 'R. Fredricks clients'
FROM tblCustomer, tblSalesrep
WHERE tblSalesrep.srepLname='Fredricks';

----qryNV07
SELECT tblCustomer.custLname, MAX(tblCustomer.custCredLim) AS Highest
FROM tblCustomer;

----qryNV08
SELECT tblSalesrep.srepFname, srepLname, srep