SQL

customerdatabase_111.accdb

CustomerNumber	Name	Address	City	State	ZipCode	CustType	Balance	CreditLimit	SalesRepNumber
AN91	Atwater-Nelson	215 Watkins	Oakdale	IN	48101	REG	¤ 3,478.50	¤ 7,000.00	11
AW52	Alliance West	266 Ralston	Allanson	IN	48102	SPC	¤ 492.20	¤ 5,000.00	07
BD22	Betodial	542 Prairie	Oakdale	IN	48101	SPC	¤ 57.00	¤ 5,000.00	07
CE76	Carson Enterprise	96 Prospect	Bishop	IL	61354	REG	¤ 4,125.00	¤ 9,000.00	11
FC63	Forrest Co.	85 Stocking	Fergus	MI	48902	SPC	¤ 7,822.00	¤ 7,000.00	04
FY16	Fedder-Yansen	198 Pearl	Oakdale	IN	48101	DSC	¤ 3,912.00	¤ 7,000.00	07
GR78	Galleria Market	9993 Reseda	Northridge	CA	91324	DSC	¤ 10,520.00	¤ 15,000.00	09
LR72	Lanross, Inc.	195 Grayton	Bishop	IL	61354	REG	¤ 0.00	¤ 7,000.00	07
MT19	Morton Trent	867 Bedford	Acme	IL	62127	REG	¤ 1,867.50	¤ 7,000.00	11
OS00	Olsen Grocery	803 Cass	La Crosse	WI	43201	DSC	¤ 9,880.00	¤ 10,000.00	04
PP99	People's Coop	123 Front	La Crosse	WI	43201	SPC	¤ 6,660.00	¤ 7,000.00	04
RO22	Robertson, Inc.	682 Maumee	Allanson	IN	48102	REG	¤ 2,336.25	¤ 9,000.00	11
RO92	Ronald A. Orten	872 Devonshire	Benson	MI	49246	REG	¤ 6,420.00	¤ 9,000.00	04
SP99	Szechuan Plance	9600 Reseda	Northridge	CA	91324	DSC	¤ 4,300.00	¤ 7,000.00	09
WB77	Western Bagel	10223 Mason	Chatsworth	CA	91311	REG	¤ 5,500.00	¤ 7,000.00	09

SalesRepNumber	LastName	FirstName	Address	City	State	ZipCode	Sales	CommissionRate	StartDate	Note	MgrID
03	Jensen	Tom	1400 State	La Crosse	WI	43210	¤ 45,000.00	0.07	2/2/90
04	Wright	Cecilia	125 Westchester	Borculo	MI	49224	¤ 53,172.00	0.08	6/8/89	Fluent in French, German, and Spanish. Likes to travel. Technically strong.	03
07	Perry	Thomas	1664 Birchwood	Kaiser	IN	46219	¤ 74,956.00	0.06	8/4/90	Somewhat fluent in Spanish. Willing to travel. Works well with new companies. Very innovative.	13
09	Chen	Michelle	1450 N. Valley	San Gabriel	CA	91776	¤ 98,750.00	0.065	11/11/01		03
11	Sanchez	Maria	722 Kreiser	Elk River	IL	60205	¤ 30,125.50	0.07	10/2/88	Technically excellent. Good reputation among established customers.	03
13	Harding	Wayne	10321 Broadway	Indianapolis	IN	46201	¤ 15,000.00	0.06	3/31/16

SELECT tblSlsrep.SalesRepNumber, tblSlsrep.LastName, tblSlsrep.FirstName FROM tblSlsrep ORDER BY [LastName], [FirstName];

PARAMETERS __SalesRepNumber Value; SELECT DISTINCTROW * FROM qrySalesRepSub AS frmSalesRepMain WHERE ([__SalesRepNumber] = SalesRepNumber);

SELECT DISTINCTROW * FROM tblCustomer;

SELECT DISTINCTROW * FROM qrySalesRepMain;

SELECT DISTINCTROW * FROM qrySalesRepSub;

SELECT DISTINCTROW * FROM qryAvailableCredit;