Excel, Tables and Access

profilemenoname
TechnicalCompanyDatabaseorAssign1IntrotoAccessDatabase.accdb
Home>Business & Finance homework help>Operations Management homework help>Excel, Tables and Access
Category Number Category Description
1 PC Installation
2 Software Installation
3 Hardware Repair
4 Troubleshoot Operating System
5 Training
6 System Back-up
7 Hardware Upgrade
8 Network Problem
Client Number Client Name Street City State Postal Code Telephone Number Client Type Billed Paid Technician Number
AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 MAN ¤ 315.50 ¤ 255.00 22
AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 RET ¤ 535.00 ¤ 565.00 23
BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 RET ¤ 229.50 ¤ 0.00 23
CR21 Cray Meat Market 72 Main Anderson TX 78077 512-555-7766 RET ¤ 0.00 ¤ 0.00 32
DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 RET ¤ 485.70 ¤ 400.00 29
GR56 Grant Cleaners 737 Allard Kingston TX 78084 512-555-1231 SER ¤ 215.00 ¤ 225.00 22
GU21 Grand Union 247 Fuller Kingston TX 78084 512-555-5431 RET ¤ 228.00 ¤ 0.00 23
ME17 Merry Café 665 Whittier Kingston TX 78084 512-555-9780 SER ¤ 312.50 ¤ 323.50 22
SA56 Sawyer Industries 31 Lafayette Anderson TX 78077 512-555-4567 MAN ¤ 372.25 ¤ 350.00 29
ST21 Steed's Department Store 752 Cadieux Liberty Corner TX 78080 254-555-9080 RET ¤ 0.00 ¤ 0.00 23
Employee ID FirstName LastName Address City State Zip Department Phone Email SSN Field1 Photo Start Date Birthdate Hourly Rate
00010 Kim Slaker 111 First Sst
099999 Katrin Aaronsdottir 235 Marshall Saint Paul MN 55123 BTEC 1421 (651) 846-1529 [email protected]#mailto:[email protected]# 987-88-9876 2018-10-29 1987-09-19 ¤ 29.99
100000 Jabalene Loloflax 421 Faun Run Eavan MN 55134 BTEC 1421 (651) 555-2222 [email protected]#mailto:[email protected]# 999-97-7777 2000-05-08 1966-04-08 ¤ 25.34
112394 Brian Lee 8299 Aberdeen Avenue Saint Paul MN 55122 Maintenance (999) 488-1234 [email protected]#mailto:[email protected]# 888-99-9999 1992-01-05 1976-03-12 ¤ 21.98
113322 Joe Cevin 26 Cotton Anderson TX 78077 Technician (435) 333-3331 [email protected]#mailto:[email protected]# 000-00-0001 1981-08-10 1947-07-21 ¤ 25.00
118675 Priyanka Chopra 127 Mason Lane Saint Paul MN 55122 Human Resouces (555) 555-7656 [email protected]#mailto:[email protected]# 555-44-4322 2008-03-04 1986-09-20 ¤ 32.97
119999 Tan Po 304 Main Street Saint Paul MN 55122 Management (948) 229-4555 [email protected]#mailto:[email protected]# 993-84-8290 1995-09-01 1986-07-04 ¤ 42.33
123994 Ali Lexander 834 Center Avenue Minneapolis MN 55144 Warehouse (999) 888-6666 [email protected]#mailto:[email protected]# 993-93-9322 2009-07-14 1990-11-01 ¤ 23.22
129923 Brad Rogers 79 Marsden Corner TX 78804 Technician (839) 882-8888 [email protected]#mailto:[email protected]# 990-00-0000 2012-04-03 1950-02-09 ¤ 30.00
155544 Lee Xi 6310 France Avenue Edina MN 55145 Maintenance (444) 555-3333 [email protected]#mailto:[email protected]# 883-72-6273 2000-04-24 1989-10-04 ¤ 20.99
176632 Lee Torres 34 Red Poppy Libety Corner TX 78080 Technician (839) 888-3726 [email protected]#mailto:[email protected]# 999-98-8827 1999-06-01 1971-05-01 ¤ 23.00
187629 Maria Rodriguez 263 Topper Kingston TX 78084 Technician (998) 776-7777 [email protected]#mailto:[email protected]# 883-44-2222 2002-07-11 1966-02-10 ¤ 35.00
198765 Joe Svenvig 1058 Van Buren Owatonna MN 55060 Accounting (507) 555-2222 [email protected]#mailto:[email protected]# 999-98-8888 2012-02-09 1978-03-06 ¤ 35.66
199999 Candy Swivelshanks 235 Marshall Saint Paul MN 55135 Training (651) 846-1529 [email protected]#mailto:[email protected]# 999-99-9999 2016-10-07 1976-04-03 ¤ 22.30
99999 Wiana Toope 111 Second Street Saint Paul MN 55122 Accounting (612) 333-0000 [email protected]#mailto:[email protected]# 999-88-7637 1990-03-10 1899-02-02 ¤ 11.00
Punch ID Employee ID Punch Date Punch In Punch Out Hours Worked
1 100000 2013-01-01 1899-12-30 1899-12-30 8.0
2 112394 2013-01-01 1899-12-30 1899-12-30 9.0
3 113322 2013-01-01 1899-12-30 1899-12-30 10.0
4 118675 2013-01-01 1899-12-30 1899-12-30 8.5
5 119999 2013-01-01 1899-12-30 1899-12-30 9.5
6 123994 2013-01-01 1899-12-30 1899-12-30 9.75
7 129923 2013-01-01 1899-12-30 1899-12-30 10.0
8 155544 2013-01-01 1899-12-30 1899-12-30 10.25
9 176632 2013-01-01 1899-12-30 1899-12-30 10.5
10 187629 2013-01-01 1899-12-30 1899-12-30 10.75
11 198765 2013-01-01 1899-12-30 1899-12-30 11.0
12 100000 2013-01-02 1899-12-30 1899-12-30 11.25
13 112394 2013-01-02 1899-12-30 1899-12-30 11.5
14 113322 2013-01-02 1899-12-30 1899-12-30 11.75
15 118675 2013-01-02 1899-12-30 1899-12-30 12.0
16 119999 2013-01-02 1899-12-30 1899-12-30 12.25
17 123994 2013-01-02 1899-12-30 1899-12-30 12.5
18 129923 2013-01-02 1899-12-30 1899-12-30 12.75
19 155544 2013-01-02 1899-12-30 1899-12-30 13.0
20 176632 2013-01-02 1899-12-30 1899-12-30 13.25
21 187629 2013-01-02 1899-12-30 1899-12-30 13.5
22 198765 2013-01-02 1899-12-30 1899-12-30 13.75
23 100000 2013-01-03 1899-12-30 1899-12-30 8.0
24 112394 2013-01-03 1899-12-30 1899-12-30 9.0
25 113322 2013-01-03 1899-12-30 1899-12-30 10.0
26 118675 2013-01-03 1899-12-30 1899-12-30 8.5
27 119999 2013-01-03 1899-12-30 1899-12-30 9.5
28 123994 2013-01-03 1899-12-30 1899-12-30 9.75
29 129923 2013-01-03 1899-12-30 1899-12-30 10.0
30 155544 2013-01-03 1899-12-30 1899-12-30 10.25
31 176632 2013-01-03 1899-12-30 1899-12-30 10.5
32 187629 2013-01-03 1899-12-30 1899-12-30 10.75
33 198765 2013-01-03 1899-12-30 1899-12-30 11.0
34 100000 2013-01-04 1899-12-30 1899-12-30 11.25
35 112394 2013-01-04 1899-12-30 1899-12-30 11.5
36 113322 2013-01-04 1899-12-30 1899-12-30 11.75
37 118675 2013-01-04 1899-12-30 1899-12-30 12.0
38 119999 2013-01-04 1899-12-30 1899-12-30 12.25
39 123994 2013-01-04 1899-12-30 1899-12-30 12.5
40 129923 2013-01-04 1899-12-30 1899-12-30 12.75
41 155544 2013-01-04 1899-12-30 1899-12-30 13.0
42 176632 2013-01-04 1899-12-30 1899-12-30 13.25
43 187629 2013-01-04 1899-12-30 1899-12-30 13.5
44 198765 2013-01-04 1899-12-30 1899-12-30 13.75
45 100000 2013-01-05 1899-12-30 1899-12-30 8.0
46 112394 2013-01-05 1899-12-30 1899-12-30 9.0
47 113322 2013-01-05 1899-12-30 1899-12-30 10.0
48 118675 2013-01-05 1899-12-30 1899-12-30 8.5
49 119999 2013-01-05 1899-12-30 1899-12-30 9.5
50 123994 2013-01-05 1899-12-30 1899-12-30 9.75
51 129923 2013-01-05 1899-12-30 1899-12-30 10.0
52 155544 2013-01-05 1899-12-30 1899-12-30 10.25
53 176632 2013-01-05 1899-12-30 1899-12-30 10.5
54 187629 2013-01-05 1899-12-30 1899-12-30 10.75
55 198765 2013-01-05 1899-12-30 1899-12-30 11.0
56 100000 2013-01-06 1899-12-30 1899-12-30 11.25
57 112394 2013-01-06 1899-12-30 1899-12-30 11.5
58 113322 2013-01-06 1899-12-30 1899-12-30 11.75
59 118675 2013-01-06 1899-12-30 1899-12-30 12.0
60 119999 2013-01-06 1899-12-30 1899-12-30 12.25
61 123994 2013-01-06 1899-12-30 1899-12-30 12.5
62 129923 2013-01-06 1899-12-30 1899-12-30 12.75
63 155544 2013-01-06 1899-12-30 1899-12-30 13.0
64 176632 2013-01-06 1899-12-30 1899-12-30 13.25
65 187629 2013-01-06 1899-12-30 1899-12-30 13.5
66 198765 2013-01-06 1899-12-30 1899-12-30 13.75
67 100000 2013-01-07 1899-12-30 1899-12-30 8.0
68 112394 2013-01-07 1899-12-30 1899-12-30 9.0
69 113322 2013-01-07 1899-12-30 1899-12-30 10.0
70 118675 2013-01-07 1899-12-30 1899-12-30 8.5
71 119999 2013-01-07 1899-12-30 1899-12-30 9.5
72 123994 2013-01-07 1899-12-30 1899-12-30 9.75
73 129923 2013-01-07 1899-12-30 1899-12-30 10.0
74 155544 2013-01-07 1899-12-30 1899-12-30 10.25
75 176632 2013-01-07 1899-12-30 1899-12-30 10.5
76 187629 2013-01-07 1899-12-30 1899-12-30 10.75
77 198765 2013-01-07 1899-12-30 1899-12-30 11.0
78 100000 2013-01-08 1899-12-30 1899-12-30 11.25
79 112394 2013-01-09 1899-12-30 1899-12-30 11.5
80 113322 2013-01-10 1899-12-30 1899-12-30 11.75
81 118675 2013-01-11 1899-12-30 1899-12-30 12.0
82 119999 2013-01-12 1899-12-30 1899-12-30 12.25
83 123994 2013-01-08 1899-12-30 1899-12-30 12.5
84 129923 2013-01-09 1899-12-30 1899-12-30 12.75
85 155544 2013-01-10 1899-12-30 1899-12-30 13.0
86 176632 2013-01-11 1899-12-30 1899-12-30 13.25
87 187629 2013-01-12 1899-12-30 1899-12-30 13.5
88 198765 2013-01-08 1899-12-30 1899-12-30 13.75
89 100000 2013-01-09 1899-12-30 1899-12-30 8.0
90 112394 2013-01-09 1899-12-30 1899-12-30 9.0
91 113322 2013-01-09 1899-12-30 1899-12-30 10.0
92 118675 2013-01-09 1899-12-30 1899-12-30 8.5
93 119999 2013-01-09 1899-12-30 1899-12-30 9.5
94 123994 2013-01-09 1899-12-30 1899-12-30 9.75
95 129923 2013-01-09 1899-12-30 1899-12-30 10.0
96 155544 2013-01-09 1899-12-30 1899-12-30 10.25
97 176632 2013-01-09 1899-12-30 1899-12-30 10.5
98 187629 2013-01-09 1899-12-30 1899-12-30 10.75
99 198765 2013-01-09 1899-12-30 1899-12-30 11.0
100 100000 2013-01-10 1899-12-30 1899-12-30 11.25
101 112394 2013-01-10 1899-12-30 1899-12-30 11.5
102 113322 2013-01-10 1899-12-30 1899-12-30 11.75
103 118675 2013-01-10 1899-12-30 1899-12-30 12.0
104 119999 2013-01-10 1899-12-30 1899-12-30 12.25
105 123994 2013-01-10 1899-12-30 1899-12-30 12.5
106 129923 2013-01-10 1899-12-30 1899-12-30 12.75
107 155544 2013-01-10 1899-12-30 1899-12-30 13.0
108 176632 2013-01-10 1899-12-30 1899-12-30 13.25
109 187629 2013-01-10 1899-12-30 1899-12-30 13.5
110 198765 2013-01-10 1899-12-30 1899-12-30 13.75
111 100000 2013-01-11 1899-12-30 1899-12-30 8.0
112 112394 2013-01-11 1899-12-30 1899-12-30 9.0
113 113322 2013-01-11 1899-12-30 1899-12-30 10.0
114 118675 2013-01-11 1899-12-30 1899-12-30 8.5
115 119999 2013-01-11 1899-12-30 1899-12-30 9.5
116 123994 2013-01-11 1899-12-30 1899-12-30 9.75
117 129923 2013-01-11 1899-12-30 1899-12-30 10.0
118 155544 2013-01-11 1899-12-30 1899-12-30 10.25
119 176632 2013-01-11 1899-12-30 1899-12-30 10.5
120 187629 2013-01-11 1899-12-30 1899-12-30 10.75
121 198765 2013-01-11 1899-12-30 1899-12-30 11.0
122 100000 2013-01-12 1899-12-30 1899-12-30 11.25
123 112394 2013-01-12 1899-12-30 1899-12-30 11.5
124 113322 2013-01-12 1899-12-30 1899-12-30 11.75
125 118675 2013-01-12 1899-12-30 1899-12-30 12.0
126 119999 2013-01-12 1899-12-30 1899-12-30 12.25
127 123994 2013-01-12 1899-12-30 1899-12-30 12.5
128 129923 2013-01-12 1899-12-30 1899-12-30 12.75
129 155544 2013-01-12 1899-12-30 1899-12-30 13.0
130 176632 2013-01-12 1899-12-30 1899-12-30 13.25
131 187629 2013-01-12 1899-12-30 1899-12-30 13.5
132 198765 2013-01-12 1899-12-30 1899-12-30 13.75
133 100000 2013-01-13 1899-12-30 1899-12-30 8.0
134 112394 2013-01-13 1899-12-30 1899-12-30 9.0
135 113322 2013-01-13 1899-12-30 1899-12-30 10.0
136 118675 2013-01-13 1899-12-30 1899-12-30 8.5
137 119999 2013-01-13 1899-12-30 1899-12-30 9.5
138 123994 2013-01-13 1899-12-30 1899-12-30 9.75
139 129923 2013-01-13 1899-12-30 1899-12-30 10.0
140 155544 2013-01-13 1899-12-30 1899-12-30 10.25
141 176632 2013-01-13 1899-12-30 1899-12-30 10.5
142 187629 2013-01-13 1899-12-30 1899-12-30 10.75
143 198765 2013-01-13 1899-12-30 1899-12-30 11.0
144 100000 2013-01-14 1899-12-30 1899-12-30 11.25
145 112394 2013-01-14 1899-12-30 1899-12-30 11.5
146 113322 2013-01-14 1899-12-30 1899-12-30 11.75
147 118675 2013-01-14 1899-12-30 1899-12-30 12.0
148 119999 2013-01-14 1899-12-30 1899-12-30 12.25
149 123994 2013-01-14 1899-12-30 1899-12-30 12.5
150 129923 2013-01-14 1899-12-30 1899-12-30 12.75
151 155544 2013-01-14 1899-12-30 1899-12-30 13.0
152 176632 2013-01-14 1899-12-30 1899-12-30 13.25
153 187629 2013-01-14 1899-12-30 1899-12-30 13.5
154 198765 2013-01-14 1899-12-30 1899-12-30 13.75
155 100000 2013-01-15 1899-12-30 1899-12-30 8.0
156 112394 2013-01-15 1899-12-30 1899-12-30 9.0
157 113322 2013-01-15 1899-12-30 1899-12-30 10.0
158 118675 2013-01-15 1899-12-30 1899-12-30 8.5
159 119999 2013-01-15 1899-12-30 1899-12-30 9.5
160 123994 2013-01-15 1899-12-30 1899-12-30 9.75
161 129923 2013-01-15 1899-12-30 1899-12-30 10.0
162 155544 2013-01-15 1899-12-30 1899-12-30 10.25
163 176632 2013-01-15 1899-12-30 1899-12-30 10.5
164 187629 2013-01-15 1899-12-30 1899-12-30 10.75
165 198765 2013-01-15 1899-12-30 1899-12-30 11.0
166 100000 2013-01-16 1899-12-30 1899-12-30 11.25
167 112394 2013-01-16 1899-12-30 1899-12-30 11.5
168 113322 2013-01-16 1899-12-30 1899-12-30 11.75
169 118675 2013-01-16 1899-12-30 1899-12-30 12.0
170 119999 2013-01-16 1899-12-30 1899-12-30 12.25
171 123994 2013-01-16 1899-12-30 1899-12-30 12.5
172 129923 2013-01-16 1899-12-30 1899-12-30 12.75
173 155544 2013-01-16 1899-12-30 1899-12-30 13.0
174 176632 2013-01-16 1899-12-30 1899-12-30 13.25
175 187629 2013-01-16 1899-12-30 1899-12-30 13.5
176 198765 2013-01-16 1899-12-30 1899-12-30 13.75
177 100000 2013-01-17 1899-12-30 1899-12-30 8.0
178 112394 2013-01-17 1899-12-30 1899-12-30 9.0
179 113322 2013-01-17 1899-12-30 1899-12-30 10.0
180 118675 2013-01-17 1899-12-30 1899-12-30 8.5
181 119999 2013-01-17 1899-12-30 1899-12-30 9.5
182 123994 2013-01-17 1899-12-30 1899-12-30 9.75
183 129923 2013-01-17 1899-12-30 1899-12-30 10.0
184 155544 2013-01-17 1899-12-30 1899-12-30 10.25
185 176632 2013-01-17 1899-12-30 1899-12-30 10.5
186 187629 2013-01-17 1899-12-30 1899-12-30 10.75
187 198765 2013-01-17 1899-12-30 1899-12-30 11.0
188 100000 2013-01-19 1899-12-30 1899-12-30 11.25
189 112394 2013-01-19 1899-12-30 1899-12-30 11.5
190 113322 2013-01-19 1899-12-30 1899-12-30 11.75
191 118675 2013-01-19 1899-12-30 1899-12-30 12.0
192 119999 2013-01-19 1899-12-30 1899-12-30 12.25
193 123994 2013-01-19 1899-12-30 1899-12-30 12.5
194 129923 2013-01-19 1899-12-30 1899-12-30 12.75
195 155544 2013-01-19 1899-12-30 1899-12-30 13.0
196 176632 2013-01-19 1899-12-30 1899-12-30 13.25
197 187629 2013-01-19 1899-12-30 1899-12-30 13.5
198 198765 2013-01-19 1899-12-30 1899-12-30 13.75
199 100000 2013-01-18 1899-12-30 1899-12-30 8.0
200 112394 2013-01-18 1899-12-30 1899-12-30 9.0
201 113322 2013-01-18 1899-12-30 1899-12-30 10.0
202 118675 2013-01-18 1899-12-30 1899-12-30 8.5
203 119999 2013-01-18 1899-12-30 1899-12-30 9.5
204 123994 2013-01-18 1899-12-30 1899-12-30 9.75
205 129923 2013-01-18 1899-12-30 1899-12-30 10.0
206 155544 2013-01-18 1899-12-30 1899-12-30 10.25
207 176632 2013-01-18 1899-12-30 1899-12-30 10.5
208 187629 2013-01-18 1899-12-30 1899-12-30 10.75
209 198765 2013-01-18 1899-12-30 1899-12-30 11.0
210 100000 2013-01-20 1899-12-30 1899-12-30 11.25
211 112394 2013-01-20 1899-12-30 1899-12-30 11.5
212 113322 2013-01-20 1899-12-30 1899-12-30 11.75
213 118675 2013-01-20 1899-12-30 1899-12-30 12.0
214 119999 2013-01-20 1899-12-30 1899-12-30 12.25
215 123994 2013-01-20 1899-12-30 1899-12-30 12.5
216 129923 2013-01-20 1899-12-30 1899-12-30 12.75
217 155544 2013-01-20 1899-12-30 1899-12-30 13.0
218 176632 2013-01-20 1899-12-30 1899-12-30 13.25
219 187629 2013-01-20 1899-12-30 1899-12-30 13.5
220 198765 2013-01-20 1899-12-30 1899-12-30 13.75
221 100000 2013-01-21 1899-12-30 1899-12-30 8.0
222 112394 2013-01-21 1899-12-30 1899-12-30 9.0
223 113322 2013-01-21 1899-12-30 1899-12-30 10.0
224 118675 2013-01-21 1899-12-30 1899-12-30 8.5
225 119999 2013-01-21 1899-12-30 1899-12-30 9.5
226 123994 2013-01-21 1899-12-30 1899-12-30 9.75
227 129923 2013-01-21 1899-12-30 1899-12-30 10.0
228 155544 2013-01-21 1899-12-30 1899-12-30 10.25
229 176632 2013-01-21 1899-12-30 1899-12-30 10.5
230 187629 2013-01-21 1899-12-30 1899-12-30 10.75
231 198765 2013-01-21 1899-12-30 1899-12-30 11.0
232 100000 2013-01-22 1899-12-30 1899-12-30 11.25
233 112394 2013-01-22 1899-12-30 1899-12-30 11.5
234 113322 2013-01-22 1899-12-30 1899-12-30 11.75
235 118675 2013-01-22 1899-12-30 1899-12-30 12.0
236 119999 2013-01-22 1899-12-30 1899-12-30 12.25
237 123994 2013-01-22 1899-12-30 1899-12-30 12.5
238 129923 2013-01-22 1899-12-30 1899-12-30 12.75
239 155544 2013-01-22 1899-12-30 1899-12-30 13.0
240 176632 2013-01-22 1899-12-30 1899-12-30 13.25
241 187629 2013-01-22 1899-12-30 1899-12-30 13.5
242 198765 2013-01-22 1899-12-30 1899-12-30 13.75
243 100000 2013-01-23 1899-12-30 1899-12-30 8.0
244 112394 2013-01-23 1899-12-30 1899-12-30 9.0
245 113322 2013-01-23 1899-12-30 1899-12-30 10.0
246 118675 2013-01-23 1899-12-30 1899-12-30 8.5
247 119999 2013-01-23 1899-12-30 1899-12-30 9.5
248 123994 2013-01-23 1899-12-30 1899-12-30 9.75
249 129923 2013-01-23 1899-12-30 1899-12-30 10.0
250 155544 2013-01-23 1899-12-30 1899-12-30 10.25
251 176632 2013-01-23 1899-12-30 1899-12-30 10.5
252 187629 2013-01-23 1899-12-30 1899-12-30 10.75
253 198765 2013-01-23 1899-12-30 1899-12-30 11.0
254 100000 2013-01-24 1899-12-30 1899-12-30 11.25
255 112394 2013-01-24 1899-12-30 1899-12-30 11.5
256 113322 2013-01-24 1899-12-30 1899-12-30 11.75
257 118675 2013-01-24 1899-12-30 1899-12-30 12.0
258 119999 2013-01-24 1899-12-30 1899-12-30 12.25
259 123994 2013-01-24 1899-12-30 1899-12-30 12.5
260 129923 2013-01-24 1899-12-30 1899-12-30 12.75
261 155544 2013-01-24 1899-12-30 1899-12-30 13.0
262 176632 2013-01-24 1899-12-30 1899-12-30 13.25
263 187629 2013-01-24 1899-12-30 1899-12-30 13.5
264 198765 2013-01-24 1899-12-30 1899-12-30 13.75
265 100000 2013-01-25 1899-12-30 1899-12-30 8.0
266 112394 2013-01-25 1899-12-30 1899-12-30 9.0
267 113322 2013-01-25 1899-12-30 1899-12-30 10.0
268 118675 2013-01-25 1899-12-30 1899-12-30 8.5
269 119999 2013-01-25 1899-12-30 1899-12-30 9.5
270 123994 2013-01-25 1899-12-30 1899-12-30 9.75
271 129923 2013-01-25 1899-12-30 1899-12-30 10.0
272 155544 2013-01-25 1899-12-30 1899-12-30 10.25
273 176632 2013-01-25 1899-12-30 1899-12-30 10.5
274 187629 2013-01-25 1899-12-30 1899-12-30 10.75
275 198765 2013-01-25 1899-12-30 1899-12-30 11.0
276 100000 2013-01-26 1899-12-30 1899-12-30 11.25
277 112394 2013-01-26 1899-12-30 1899-12-30 11.5
278 113322 2013-01-26 1899-12-30 1899-12-30 11.75
279 118675 2013-01-26 1899-12-30 1899-12-30 12.0
280 119999 2013-01-26 1899-12-30 1899-12-30 12.25
281 123994 2013-01-26 1899-12-30 1899-12-30 12.5
282 129923 2013-01-26 1899-12-30 1899-12-30 12.75
283 155544 2013-01-26 1899-12-30 1899-12-30 13.0
284 176632 2013-01-26 1899-12-30 1899-12-30 13.25
285 187629 2013-01-26 1899-12-30 1899-12-30 13.5
286 198765 2013-01-26 1899-12-30 1899-12-30 13.75
287 100000 2013-01-27 1899-12-30 1899-12-30 8.0
288 112394 2013-01-27 1899-12-30 1899-12-30 9.0
289 113322 2013-01-27 1899-12-30 1899-12-30 10.0
290 118675 2013-01-27 1899-12-30 1899-12-30 8.5
291 119999 2013-01-27 1899-12-30 1899-12-30 9.5
292 123994 2013-01-27 1899-12-30 1899-12-30 9.75
293 129923 2013-01-27 1899-12-30 1899-12-30 10.0
294 155544 2013-01-27 1899-12-30 1899-12-30 10.25
295 176632 2013-01-27 1899-12-30 1899-12-30 10.5
296 187629 2013-01-27 1899-12-30 1899-12-30 10.75
297 198765 2013-01-27 1899-12-30 1899-12-30 11.0
298 100000 2013-01-28 1899-12-30 1899-12-30 11.25
299 112394 2013-01-28 1899-12-30 1899-12-30 11.5
300 113322 2013-01-28 1899-12-30 1899-12-30 11.75
301 118675 2013-01-28 1899-12-30 1899-12-30 12.0
302 119999 2013-01-28 1899-12-30 1899-12-30 12.25
303 123994 2013-01-28 1899-12-30 1899-12-30 12.5
304 129923 2013-01-28 1899-12-30 1899-12-30 12.75
305 155544 2013-01-28 1899-12-30 1899-12-30 13.0
306 176632 2013-01-28 1899-12-30 1899-12-30 13.25
307 187629 2013-01-28 1899-12-30 1899-12-30 13.5
308 198765 2013-01-28 1899-12-30 1899-12-30 13.75
309 100000 2013-01-29 1899-12-30 1899-12-30 8.0
310 112394 2013-01-29 1899-12-30 1899-12-30 9.0
311 113322 2013-01-29 1899-12-30 1899-12-30 10.0
312 118675 2013-01-29 1899-12-30 1899-12-30 8.5
313 119999 2013-01-29 1899-12-30 1899-12-30 9.5
314 123994 2013-01-29 1899-12-30 1899-12-30 9.75
315 129923 2013-01-29 1899-12-30 1899-12-30 10.0
316 155544 2013-01-29 1899-12-30 1899-12-30 10.25
317 176632 2013-01-29 1899-12-30 1899-12-30 10.5
318 187629 2013-01-29 1899-12-30 1899-12-30 10.75
319 198765 2013-01-29 1899-12-30 1899-12-30 11.0
320 100000 2013-01-30 1899-12-30 1899-12-30 11.25
321 112394 2013-01-30 1899-12-30 1899-12-30 11.5
322 113322 2013-01-30 1899-12-30 1899-12-30 11.75
323 118675 2013-01-30 1899-12-30 1899-12-30 12.0
324 119999 2013-01-30 1899-12-30 1899-12-30 12.25
325 123994 2013-01-30 1899-12-30 1899-12-30 12.5
326 129923 2013-01-30 1899-12-30 1899-12-30 12.75
327 155544 2013-01-30 1899-12-30 1899-12-30 13.0
328 176632 2013-01-30 1899-12-30 1899-12-30 13.25
329 187629 2013-01-30 1899-12-30 1899-12-30 13.5
330 198765 2013-01-30 1899-12-30 1899-12-30 13.75
331 100000 2013-01-31 1899-12-30 1899-12-30 8.0
332 112394 2013-02-01 1899-12-30 1899-12-30 9.0
333 113322 2013-02-02 1899-12-30 1899-12-30 10.0
334 118675 2013-02-03 1899-12-30 1899-12-30 8.5
335 119999 2013-02-04 1899-12-30 1899-12-30 9.5
336 123994 2013-02-05 1899-12-30 1899-12-30 9.75
337 129923 2013-02-06 1899-12-30 1899-12-30 10.0
338 155544 2013-02-07 1899-12-30 1899-12-30 10.25
339 176632 2013-02-08 1899-12-30 1899-12-30 10.5
340 187629 2013-02-09 1899-12-30 1899-12-30 10.75
341 198765 2013-02-10 1899-12-30 1899-12-30 11.0
342 100000 2013-02-11 1899-12-30 1899-12-30 11.25
343 112394 2013-02-12 1899-12-30 1899-12-30 11.5
344 113322 2013-02-13 1899-12-30 1899-12-30 11.75
345 118675 2013-02-14 1899-12-30 1899-12-30 12.0
346 119999 2013-02-15 1899-12-30 1899-12-30 12.25
347 123994 2013-02-16 1899-12-30 1899-12-30 12.5
348 129923 2013-02-17 1899-12-30 1899-12-30 12.75
349 155544 2013-02-18 1899-12-30 1899-12-30 13.0
350 176632 2013-02-19 1899-12-30 1899-12-30 13.25
351 187629 2013-02-20 1899-12-30 1899-12-30 13.5
352 198765 2013-02-21 1899-12-30 1899-12-30 13.75
353 100000 2013-02-22 1899-12-30 1899-12-30 8.0
354 112394 2013-02-23 1899-12-30 1899-12-30 9.0
355 113322 2013-02-24 1899-12-30 1899-12-30 10.0
356 118675 2013-02-25 1899-12-30 1899-12-30 8.5
357 119999 2013-02-26 1899-12-30 1899-12-30 9.5
358 123994 2013-02-27 1899-12-30 1899-12-30 9.75
359 129923 2013-02-28 1899-12-30 1899-12-30 10.0
360 155544 2013-03-01 1899-12-30 1899-12-30 10.25
361 176632 2013-03-02 1899-12-30 1899-12-30 10.5
362 187629 2013-03-03 1899-12-30 1899-12-30 10.75
363 198765 2013-03-04 1899-12-30 1899-12-30 11.0
364 100000 2013-03-05 1899-12-30 1899-12-30 11.25
365 112394 2013-03-06 1899-12-30 1899-12-30 11.5
366 113322 2013-03-07 1899-12-30 1899-12-30 11.75
367 118675 2013-03-08 1899-12-30 1899-12-30 12.0
368 119999 2013-03-09 1899-12-30 1899-12-30 12.25
369 123994 2013-03-10 1899-12-30 1899-12-30 12.5
370 129923 2013-03-11 1899-12-30 1899-12-30 12.75
371 155544 2013-03-12 1899-12-30 1899-12-30 13.0
372 176632 2013-03-13 1899-12-30 1899-12-30 13.25
373 187629 2013-03-14 1899-12-30 1899-12-30 13.5
374 198765 2013-03-15 1899-12-30 1899-12-30 13.75
375 100000 2013-03-16 1899-12-30 1899-12-30 8.0
376 112394 2013-03-17 1899-12-30 1899-12-30 9.0
377 113322 2013-03-18 1899-12-30 1899-12-30 10.0
378 118675 2013-03-19 1899-12-30 1899-12-30 8.5
379 119999 2013-03-20 1899-12-30 1899-12-30 9.5
380 123994 2013-03-21 1899-12-30 1899-12-30 9.75
381 129923 2013-03-22 1899-12-30 1899-12-30 10.0
382 155544 2013-03-23 1899-12-30 1899-12-30 10.25
383 176632 2013-03-24 1899-12-30 1899-12-30 10.5
384 187629 2013-03-25 1899-12-30 1899-12-30 10.75
385 198765 2013-03-26 1899-12-30 1899-12-30 11.0
386 100000 2013-03-27 1899-12-30 1899-12-30 11.25
387 112394 2013-03-28 1899-12-30 1899-12-30 11.5
388 113322 2013-03-29 1899-12-30 1899-12-30 11.75
389 118675 2013-03-30 1899-12-30 1899-12-30 12.0
390 119999 2013-03-31 1899-12-30 1899-12-30 12.25
391 123994 2013-04-01 1899-12-30 1899-12-30 12.5
392 129923 2013-04-02 1899-12-30 1899-12-30 12.75
393 155544 2013-04-03 1899-12-30 1899-12-30 13.0
394 176632 2013-04-04 1899-12-30 1899-12-30 13.25
395 187629 2013-04-05 1899-12-30 1899-12-30 13.5
396 198765 2013-04-06 1899-12-30 1899-12-30 13.75
397 100000 2013-04-07 1899-12-30 1899-12-30 8.0
398 112394 2013-04-08 1899-12-30 1899-12-30 9.0
399 113322 2013-04-09 1899-12-30 1899-12-30 10.0
400 118675 2013-04-10 1899-12-30 1899-12-30 8.5
401 119999 2013-04-11 1899-12-30 1899-12-30 9.5
402 123994 2013-04-12 1899-12-30 1899-12-30 9.75
403 129923 2013-04-13 1899-12-30 1899-12-30 10.0
404 155544 2013-04-14 1899-12-30 1899-12-30 10.25
405 176632 2013-04-15 1899-12-30 1899-12-30 10.5
406 187629 2013-04-16 1899-12-30 1899-12-30 10.75
407 198765 2013-04-17 1899-12-30 1899-12-30 11.0
408 100000 2013-04-18 1899-12-30 1899-12-30 11.25
409 112394 2013-04-19 1899-12-30 1899-12-30 11.5
410 113322 2013-04-20 1899-12-30 1899-12-30 11.75
411 118675 2013-04-21 1899-12-30 1899-12-30 12.0
412 119999 2013-04-22 1899-12-30 1899-12-30 12.25
413 123994 2013-04-23 1899-12-30 1899-12-30 12.5
414 129923 2013-04-24 1899-12-30 1899-12-30 12.75
415 155544 2013-04-25 1899-12-30 1899-12-30 13.0
416 176632 2013-04-26 1899-12-30 1899-12-30 13.25
417 187629 2013-04-27 1899-12-30 1899-12-30 13.5
418 198765 2013-04-28 1899-12-30 1899-12-30 13.75
419 100000 2013-04-29 1899-12-30 1899-12-30 8.0
420 112394 2013-04-30 1899-12-30 1899-12-30 9.0
421 113322 2013-05-01 1899-12-30 1899-12-30 10.0
422 118675 2013-05-02 1899-12-30 1899-12-30 8.5
423 119999 2013-05-03 1899-12-30 1899-12-30 9.5
424 123994 2013-05-04 1899-12-30 1899-12-30 9.75
425 129923 2013-05-05 1899-12-30 1899-12-30 10.0
426 155544 2013-05-06 1899-12-30 1899-12-30 10.25
427 176632 2013-05-07 1899-12-30 1899-12-30 10.5
428 187629 2013-05-08 1899-12-30 1899-12-30 10.75
429 198765 2013-05-09 1899-12-30 1899-12-30 11.0
430 100000 2013-05-10 1899-12-30 1899-12-30 11.25
431 112394 2013-05-11 1899-12-30 1899-12-30 11.5
432 113322 2013-05-12 1899-12-30 1899-12-30 11.75
433 118675 2013-05-13 1899-12-30 1899-12-30 12.0
434 119999 2013-05-14 1899-12-30 1899-12-30 12.25
435 123994 2013-05-15 1899-12-30 1899-12-30 12.5
436 129923 2013-05-16 1899-12-30 1899-12-30 12.75
437 155544 2013-05-17 1899-12-30 1899-12-30 13.0
438 176632 2013-05-18 1899-12-30 1899-12-30 13.25
439 187629 2013-05-19 1899-12-30 1899-12-30 13.5
440 198765 2013-05-20 1899-12-30 1899-12-30 13.75
441 100000 2013-05-21 1899-12-30 1899-12-30 8.0
442 112394 2013-05-22 1899-12-30 1899-12-30 9.0
443 113322 2013-05-23 1899-12-30 1899-12-30 10.0
444 118675 2013-05-24 1899-12-30 1899-12-30 8.5
445 119999 2013-05-25 1899-12-30 1899-12-30 9.5
446 123994 2013-05-26 1899-12-30 1899-12-30 9.75
447 129923 2013-05-27 1899-12-30 1899-12-30 10.0
448 155544 2013-05-28 1899-12-30 1899-12-30 10.25
449 176632 2013-05-29 1899-12-30 1899-12-30 10.5
450 187629 2013-05-30 1899-12-30 1899-12-30 10.75
451 198765 2013-05-31 1899-12-30 1899-12-30 11.0
452 100000 2013-06-01 1899-12-30 1899-12-30 11.25
453 112394 2013-06-02 1899-12-30 1899-12-30 11.5
454 113322 2013-06-03 1899-12-30 1899-12-30 11.75
455 118675 2013-06-04 1899-12-30 1899-12-30 12.0
456 119999 2013-06-05 1899-12-30 1899-12-30 12.25
457 123994 2013-06-06 1899-12-30 1899-12-30 12.5
458 129923 2013-06-07 1899-12-30 1899-12-30 12.75
459 155544 2013-06-08 1899-12-30 1899-12-30 13.0
460 176632 2013-06-09 1899-12-30 1899-12-30 13.25
461 187629 2013-06-10 1899-12-30 1899-12-30 13.5
462 198765 2013-06-11 1899-12-30 1899-12-30 13.75
463 100000 2013-06-12 1899-12-30 1899-12-30 8.0
464 112394 2013-06-13 1899-12-30 1899-12-30 9.0
465 113322 2013-06-14 1899-12-30 1899-12-30 10.0
466 118675 2013-06-15 1899-12-30 1899-12-30 8.5
467 119999 2013-06-16 1899-12-30 1899-12-30 9.5
468 123994 2013-06-17 1899-12-30 1899-12-30 9.75
469 129923 2013-06-18 1899-12-30 1899-12-30 10.0
470 155544 2013-06-19 1899-12-30 1899-12-30 10.25
471 176632 2013-06-20 1899-12-30 1899-12-30 10.5
472 187629 2013-06-21 1899-12-30 1899-12-30 10.75
473 198765 2013-06-22 1899-12-30 1899-12-30 11.0
474 100000 2013-06-23 1899-12-30 1899-12-30 11.25
475 112394 2013-06-24 1899-12-30 1899-12-30 11.5
476 113322 2013-06-25 1899-12-30 1899-12-30 11.75
477 118675 2013-06-26 1899-12-30 1899-12-30 12.0
478 119999 2013-06-27 1899-12-30 1899-12-30 12.25
479 123994 2013-06-28 1899-12-30 1899-12-30 12.5
480 129923 2013-06-29 1899-12-30 1899-12-30 12.75
481 155544 2013-06-30 1899-12-30 1899-12-30 13.0
482 176632 2013-07-01 1899-12-30 1899-12-30 13.25
483 187629 2013-07-02 1899-12-30 1899-12-30 13.5
484 198765 2013-07-03 1899-12-30 1899-12-30 13.75
485 100000 2013-07-04 1899-12-30 1899-12-30 8.0
486 112394 2013-07-05 1899-12-30 1899-12-30 9.0
487 113322 2013-07-06 1899-12-30 1899-12-30 10.0
488 118675 2013-07-07 1899-12-30 1899-12-30 8.5
489 119999 2013-07-08 1899-12-30 1899-12-30 9.5
490 123994 2013-07-09 1899-12-30 1899-12-30 9.75
491 129923 2013-07-10 1899-12-30 1899-12-30 10.0
492 155544 2013-07-11 1899-12-30 1899-12-30 10.25
493 176632 2013-07-12 1899-12-30 1899-12-30 10.5
494 187629 2013-07-13 1899-12-30 1899-12-30 10.75
495 198765 2013-07-14 1899-12-30 1899-12-30 11.0
496 100000 2013-07-15 1899-12-30 1899-12-30 11.25
497 112394 2013-07-16 1899-12-30 1899-12-30 11.5
498 113322 2013-07-17 1899-12-30 1899-12-30 11.75
499 118675 2013-07-18 1899-12-30 1899-12-30 12.0
500 119999 2013-07-19 1899-12-30 1899-12-30 12.25
501 123994 2013-07-20 1899-12-30 1899-12-30 12.5
502 129923 2013-07-21 1899-12-30 1899-12-30 12.75
503 155544 2013-07-22 1899-12-30 1899-12-30 13.0
504 176632 2013-07-23 1899-12-30 1899-12-30 13.25
505 187629 2013-07-24 1899-12-30 1899-12-30 13.5
506 198765 2013-07-25 1899-12-30 1899-12-30 13.75
507 100000 2013-07-26 1899-12-30 1899-12-30 8.0
508 112394 2013-07-27 1899-12-30 1899-12-30 9.0
509 113322 2013-07-28 1899-12-30 1899-12-30 10.0
510 118675 2013-07-29 1899-12-30 1899-12-30 8.5
511 119999 2013-07-30 1899-12-30 1899-12-30 9.5
512 123994 2013-07-31 1899-12-30 1899-12-30 9.75
513 129923 2013-08-01 1899-12-30 1899-12-30 10.0
514 155544 2013-08-02 1899-12-30 1899-12-30 10.25
515 176632 2013-08-03 1899-12-30 1899-12-30 10.5
516 187629 2013-08-04 1899-12-30 1899-12-30 10.75
517 198765 2013-08-05 1899-12-30 1899-12-30 11.0
518 100000 2013-08-06 1899-12-30 1899-12-30 11.25
519 112394 2013-08-07 1899-12-30 1899-12-30 11.5
520 113322 2013-08-08 1899-12-30 1899-12-30 11.75
521 118675 2013-08-09 1899-12-30 1899-12-30 12.0
522 119999 2013-08-10 1899-12-30 1899-12-30 12.25
523 123994 2013-08-11 1899-12-30 1899-12-30 12.5
524 129923 2013-08-12 1899-12-30 1899-12-30 12.75
525 155544 2013-08-13 1899-12-30 1899-12-30 13.0
526 176632 2013-08-14 1899-12-30 1899-12-30 13.25
527 187629 2013-08-15 1899-12-30 1899-12-30 13.5
528 198765 2013-08-16 1899-12-30 1899-12-30 13.75
529 100000 2013-08-17 1899-12-30 1899-12-30 8.0
530 112394 2013-08-18 1899-12-30 1899-12-30 9.0
531 113322 2013-08-19 1899-12-30 1899-12-30 10.0
532 118675 2013-08-20 1899-12-30 1899-12-30 8.5
533 119999 2013-08-21 1899-12-30 1899-12-30 9.5
534 123994 2013-08-22 1899-12-30 1899-12-30 9.75
535 129923 2013-08-23 1899-12-30 1899-12-30 10.0
536 155544 2013-08-24 1899-12-30 1899-12-30 10.25
537 176632 2013-08-25 1899-12-30 1899-12-30 10.5
538 187629 2013-08-26 1899-12-30 1899-12-30 10.75
539 198765 2013-08-27 1899-12-30 1899-12-30 11.0
540 100000 2013-08-28 1899-12-30 1899-12-30 11.25
541 112394 2013-08-29 1899-12-30 1899-12-30 11.5
542 113322 2013-08-30 1899-12-30 1899-12-30 11.75
543 118675 2013-08-31 1899-12-30 1899-12-30 12.0
544 119999 2013-09-01 1899-12-30 1899-12-30 12.25
545 123994 2013-09-02 1899-12-30 1899-12-30 12.5
546 129923 2013-09-03 1899-12-30 1899-12-30 12.75
547 155544 2013-09-04 1899-12-30 1899-12-30 13.0
548 176632 2013-09-05 1899-12-30 1899-12-30 13.25
549 187629 2013-09-06 1899-12-30 1899-12-30 13.5
550 198765 2013-09-07 1899-12-30 1899-12-30 13.75
551 100000 2013-09-08 1899-12-30 1899-12-30 8.0
552 112394 2013-09-09 1899-12-30 1899-12-30 9.0
553 113322 2013-09-10 1899-12-30 1899-12-30 10.0
554 118675 2013-09-11 1899-12-30 1899-12-30 8.5
555 119999 2013-09-12 1899-12-30 1899-12-30 9.5
556 123994 2013-09-13 1899-12-30 1899-12-30 9.75
557 129923 2013-09-14 1899-12-30 1899-12-30 10.0
558 155544 2013-09-15 1899-12-30 1899-12-30 10.25
559 176632 2013-09-16 1899-12-30 1899-12-30 10.5
560 187629 2013-09-17 1899-12-30 1899-12-30 10.75
561 198765 2013-09-18 1899-12-30 1899-12-30 11.0
562 100000 2013-09-19 1899-12-30 1899-12-30 11.25
563 112394 2013-09-20 1899-12-30 1899-12-30 11.5
564 113322 2013-09-21 1899-12-30 1899-12-30 11.75
565 118675 2013-09-22 1899-12-30 1899-12-30 12.0
566 119999 2013-09-23 1899-12-30 1899-12-30 12.25
567 123994 2013-09-24 1899-12-30 1899-12-30 12.5
568 129923 2013-09-25 1899-12-30 1899-12-30 12.75
569 155544 2013-09-26 1899-12-30 1899-12-30 13.0
570 176632 2013-09-27 1899-12-30 1899-12-30 13.25
571 187629 2013-09-28 1899-12-30 1899-12-30 13.5
572 198765 2013-09-29 1899-12-30 1899-12-30 13.75
573 100000 2013-09-30 1899-12-30 1899-12-30 8.0
574 112394 2013-10-01 1899-12-30 1899-12-30 9.0
575 113322 2013-10-02 1899-12-30 1899-12-30 10.0
576 118675 2013-10-03 1899-12-30 1899-12-30 8.5
577 119999 2013-10-04 1899-12-30 1899-12-30 9.5
578 123994 2013-10-05 1899-12-30 1899-12-30 9.75
579 129923 2013-10-06 1899-12-30 1899-12-30 10.0
580 155544 2013-10-07 1899-12-30 1899-12-30 10.25
581 176632 2013-10-08 1899-12-30 1899-12-30 10.5
582 187629 2013-10-09 1899-12-30 1899-12-30 10.75
583 198765 2013-10-10 1899-12-30 1899-12-30 11.0
584 100000 2013-10-11 1899-12-30 1899-12-30 11.25
585 112394 2013-10-12 1899-12-30 1899-12-30 11.5
586 113322 2013-10-13 1899-12-30 1899-12-30 11.75
587 118675 2013-10-14 1899-12-30 1899-12-30 12.0
588 119999 2013-10-15 1899-12-30 1899-12-30 12.25
589 123994 2013-10-16 1899-12-30 1899-12-30 12.5
590 129923 2013-10-17 1899-12-30 1899-12-30 12.75
591 155544 2013-10-18 1899-12-30 1899-12-30 13.0
592 176632 2013-10-19 1899-12-30 1899-12-30 13.25
593 187629 2013-10-20 1899-12-30 1899-12-30 13.5
594 198765 2013-10-21 1899-12-30 1899-12-30 13.75
595 100000 2013-10-22 1899-12-30 1899-12-30 8.0
596 112394 2013-10-23 1899-12-30 1899-12-30 9.0
597 113322 2013-10-24 1899-12-30 1899-12-30 10.0
598 118675 2013-10-25 1899-12-30 1899-12-30 8.5
599 119999 2013-10-26 1899-12-30 1899-12-30 9.5
600 123994 2013-10-27 1899-12-30 1899-12-30 9.75
601 129923 2013-10-28 1899-12-30 1899-12-30 10.0
602 155544 2013-10-29 1899-12-30 1899-12-30 10.25
603 176632 2013-10-30 1899-12-30 1899-12-30 10.5
604 187629 2013-10-31 1899-12-30 1899-12-30 10.75
605 198765 2013-11-01 1899-12-30 1899-12-30 11.0
606 100000 2013-11-02 1899-12-30 1899-12-30 11.25
607 112394 2013-11-03 1899-12-30 1899-12-30 11.5
608 113322 2013-11-04 1899-12-30 1899-12-30 11.75
609 118675 2013-11-05 1899-12-30 1899-12-30 12.0
610 119999 2013-11-06 1899-12-30 1899-12-30 12.25
611 123994 2013-11-07 1899-12-30 1899-12-30 12.5
612 129923 2013-11-08 1899-12-30 1899-12-30 12.75
613 155544 2013-11-09 1899-12-30 1899-12-30 13.0
614 176632 2013-11-10 1899-12-30 1899-12-30 13.25
615 187629 2013-11-11 1899-12-30 1899-12-30 13.5
616 198765 2013-11-12 1899-12-30 1899-12-30 13.75
617 100000 2013-11-13 1899-12-30 1899-12-30 8.0
618 112394 2013-11-14 1899-12-30 1899-12-30 9.0
619 113322 2013-11-15 1899-12-30 1899-12-30 10.0
620 118675 2013-11-16 1899-12-30 1899-12-30 8.5
621 119999 2013-11-17 1899-12-30 1899-12-30 9.5
622 123994 2013-11-18 1899-12-30 1899-12-30 9.75
623 129923 2013-11-19 1899-12-30 1899-12-30 10.0
624 155544 2013-11-20 1899-12-30 1899-12-30 10.25
625 176632 2013-11-21 1899-12-30 1899-12-30 10.5
626 187629 2013-11-22 1899-12-30 1899-12-30 10.75
627 198765 2013-11-23 1899-12-30 1899-12-30 11.0
628 100000 2013-11-24 1899-12-30 1899-12-30 11.25
629 112394 2013-11-25 1899-12-30 1899-12-30 11.5
630 113322 2013-11-26 1899-12-30 1899-12-30 11.75
631 118675 2013-11-27 1899-12-30 1899-12-30 12.0
632 119999 2013-11-28 1899-12-30 1899-12-30 12.25
633 123994 2013-11-29 1899-12-30 1899-12-30 12.5
634 129923 2013-11-30 1899-12-30 1899-12-30 12.75
635 155544 2013-12-01 1899-12-30 1899-12-30 13.0
636 176632 2013-12-02 1899-12-30 1899-12-30 13.25
637 187629 2013-12-03 1899-12-30 1899-12-30 13.5
638 198765 2013-12-04 1899-12-30 1899-12-30 13.75
639 100000 2013-12-05 1899-12-30 1899-12-30 8.0
640 112394 2013-12-06 1899-12-30 1899-12-30 9.0
641 113322 2013-12-07 1899-12-30 1899-12-30 10.0
642 118675 2013-12-08 1899-12-30 1899-12-30 8.5
643 119999 2013-12-09 1899-12-30 1899-12-30 9.5
644 123994 2013-12-10 1899-12-30 1899-12-30 9.75
645 129923 2013-12-11 1899-12-30 1899-12-30 10.0
646 155544 2013-12-12 1899-12-30 1899-12-30 10.25
647 176632 2013-12-13 1899-12-30 1899-12-30 10.5
648 187629 2013-12-14 1899-12-30 1899-12-30 10.75
649 198765 2013-12-15 1899-12-30 1899-12-30 11.0
650 100000 2013-12-16 1899-12-30 1899-12-30 11.25
651 112394 2013-12-17 1899-12-30 1899-12-30 11.5
652 113322 2013-12-18 1899-12-30 1899-12-30 11.75
653 118675 2013-12-19 1899-12-30 1899-12-30 12.0
654 119999 2013-12-20 1899-12-30 1899-12-30 12.25
655 123994 2013-12-21 1899-12-30 1899-12-30 12.5
656 129923 2013-12-22 1899-12-30 1899-12-30 12.75
657 155544 2013-12-23 1899-12-30 1899-12-30 13.0
658 176632 2013-12-24 1899-12-30 1899-12-30 13.25
659 187629 2013-12-25 1899-12-30 1899-12-30 13.5
660 198765 2013-12-26 1899-12-30 1899-12-30 13.75
661 100000 2013-12-27 1899-12-30 1899-12-30 8.0
662 112394 2013-12-28 1899-12-30 1899-12-30 9.0
663 113322 2013-12-29 1899-12-30 1899-12-30 10.0
664 118675 2013-12-30 1899-12-30 1899-12-30 8.5
665 119999 2013-12-31 1899-12-30 1899-12-30 9.5
666 123994 2014-01-01 1899-12-30 1899-12-30 9.75
667 129923 2014-01-02 1899-12-30 1899-12-30 10.0
668 155544 2014-01-03 1899-12-30 1899-12-30 10.25
669 176632 2014-01-04 1899-12-30 1899-12-30 10.5
670 187629 2014-01-05 1899-12-30 1899-12-30 10.75
671 198765 2014-01-06 1899-12-30 1899-12-30 11.0
672 100000 2014-01-07 1899-12-30 1899-12-30 11.25
673 112394 2014-01-08 1899-12-30 1899-12-30 11.5
674 113322 2014-01-09 1899-12-30 1899-12-30 11.75
675 118675 2014-01-10 1899-12-30 1899-12-30 12.0
676 119999 2014-01-11 1899-12-30 1899-12-30 12.25
677 123994 2014-01-12 1899-12-30 1899-12-30 12.5
678 129923 2014-01-13 1899-12-30 1899-12-30 12.75
679 155544 2014-01-14 1899-12-30 1899-12-30 13.0
680 176632 2014-01-15 1899-12-30 1899-12-30 13.25
681 187629 2014-01-16 1899-12-30 1899-12-30 13.5
682 198765 2014-01-17 1899-12-30 1899-12-30 13.75
683 100000 2014-01-18 1899-12-30 1899-12-30 8.0
684 112394 2014-01-19 1899-12-30 1899-12-30 9.0
685 113322 2014-01-20 1899-12-30 1899-12-30 10.0
686 118675 2014-01-21 1899-12-30 1899-12-30 8.5
687 119999 2014-01-22 1899-12-30 1899-12-30 9.5
688 123994 2014-01-23 1899-12-30 1899-12-30 9.75
689 129923 2014-01-24 1899-12-30 1899-12-30 10.0
690 155544 2014-01-25 1899-12-30 1899-12-30 10.25
691 176632 2014-01-26 1899-12-30 1899-12-30 10.5
692 187629 2014-01-27 1899-12-30 1899-12-30 10.75
693 198765 2014-01-28 1899-12-30 1899-12-30 11.0
694 100000 2014-01-29 1899-12-30 1899-12-30 11.25
695 112394 2014-01-30 1899-12-30 1899-12-30 11.5
696 113322 2014-01-31 1899-12-30 1899-12-30 11.75
697 118675 2014-02-01 1899-12-30 1899-12-30 12.0
698 119999 2014-02-02 1899-12-30 1899-12-30 12.25
699 123994 2014-02-03 1899-12-30 1899-12-30 12.5
700 129923 2014-02-04 1899-12-30 1899-12-30 12.75
701 155544 2014-02-05 1899-12-30 1899-12-30 13.0
702 176632 2014-02-06 1899-12-30 1899-12-30 13.25
703 187629 2014-02-07 1899-12-30 1899-12-30 13.5
704 198765 2014-02-08 1899-12-30 1899-12-30 13.75
705 100000 2014-02-09 1899-12-30 1899-12-30 8.0
706 112394 2014-02-10 1899-12-30 1899-12-30 9.0
707 113322 2014-02-11 1899-12-30 1899-12-30 10.0
708 118675 2014-02-12 1899-12-30 1899-12-30 8.5
709 119999 2014-02-13 1899-12-30 1899-12-30 9.5
710 123994 2014-02-14 1899-12-30 1899-12-30 9.75
711 129923 2014-02-15 1899-12-30 1899-12-30 10.0
712 155544 2014-02-16 1899-12-30 1899-12-30 10.25
713 176632 2014-02-17 1899-12-30 1899-12-30 10.5
714 187629 2014-02-18 1899-12-30 1899-12-30 10.75
715 198765 2014-02-19 1899-12-30 1899-12-30 11.0
716 100000 2014-02-20 1899-12-30 1899-12-30 11.25
717 112394 2014-02-21 1899-12-30 1899-12-30 11.5
718 113322 2014-02-22 1899-12-30 1899-12-30 11.75
719 118675 2014-02-23 1899-12-30 1899-12-30 12.0
720 119999 2014-02-24 1899-12-30 1899-12-30 12.25
721 123994 2014-02-25 1899-12-30 1899-12-30 12.5
722 129923 2014-02-26 1899-12-30 1899-12-30 12.75
723 155544 2014-02-27 1899-12-30 1899-12-30 13.0
724 176632 2014-02-28 1899-12-30 1899-12-30 13.25
725 187629 2014-03-01 1899-12-30 1899-12-30 13.5
726 198765 2014-03-02 1899-12-30 1899-12-30 13.75
727 100000 2014-03-03 1899-12-30 1899-12-30 8.0
728 112394 2014-03-04 1899-12-30 1899-12-30 9.0
729 113322 2014-03-05 1899-12-30 1899-12-30 10.0
730 118675 2014-03-06 1899-12-30 1899-12-30 8.5
731 119999 2014-03-07 1899-12-30 1899-12-30 9.5
732 123994 2014-03-08 1899-12-30 1899-12-30 9.75
733 129923 2014-03-09 1899-12-30 1899-12-30 10.0
734 155544 2014-03-10 1899-12-30 1899-12-30 10.25
735 176632 2014-03-11 1899-12-30 1899-12-30 10.5
736 187629 2014-03-12 1899-12-30 1899-12-30 10.75
737 198765 2014-03-13 1899-12-30 1899-12-30 11.0
738 100000 2014-03-14 1899-12-30 1899-12-30 11.25
739 112394 2014-03-15 1899-12-30 1899-12-30 11.5
740 113322 2014-03-16 1899-12-30 1899-12-30 11.75
741 118675 2014-03-17 1899-12-30 1899-12-30 12.0
742 119999 2014-03-18 1899-12-30 1899-12-30 12.25
743 123994 2014-03-19 1899-12-30 1899-12-30 12.5
744 129923 2014-03-20 1899-12-30 1899-12-30 12.75
745 155544 2014-03-21 1899-12-30 1899-12-30 13.0
746 176632 2014-03-22 1899-12-30 1899-12-30 13.25
747 187629 2014-03-23 1899-12-30 1899-12-30 13.5
748 198765 2014-03-24 1899-12-30 1899-12-30 13.75
749 100000 2014-03-25 1899-12-30 1899-12-30 8.0
750 112394 2014-03-26 1899-12-30 1899-12-30 9.0
751 113322 2014-03-27 1899-12-30 1899-12-30 10.0
752 118675 2014-03-28 1899-12-30 1899-12-30 8.5
753 119999 2014-03-29 1899-12-30 1899-12-30 9.5
754 123994 2014-03-30 1899-12-30 1899-12-30 9.75
755 129923 2014-03-31 1899-12-30 1899-12-30 10.0
756 155544 2014-04-01 1899-12-30 1899-12-30 10.25
757 176632 2014-04-02 1899-12-30 1899-12-30 10.5
758 187629 2014-04-03 1899-12-30 1899-12-30 10.75
759 198765 2014-04-04 1899-12-30 1899-12-30 11.0
760 100000 2014-04-05 1899-12-30 1899-12-30 11.25
761 112394 2014-04-06 1899-12-30 1899-12-30 11.5
762 113322 2014-04-07 1899-12-30 1899-12-30 11.75
763 118675 2014-04-08 1899-12-30 1899-12-30 12.0
764 119999 2014-04-09 1899-12-30 1899-12-30 12.25
765 123994 2014-04-10 1899-12-30 1899-12-30 12.5
766 129923 2014-04-11 1899-12-30 1899-12-30 12.75
767 155544 2014-04-12 1899-12-30 1899-12-30 13.0
768 176632 2014-04-13 1899-12-30 1899-12-30 13.25
769 187629 2014-04-14 1899-12-30 1899-12-30 13.5
770 198765 2014-04-15 1899-12-30 1899-12-30 13.75
771 100000 2014-04-16 1899-12-30 1899-12-30 8.0
772 112394 2014-04-17 1899-12-30 1899-12-30 9.0
773 113322 2014-04-18 1899-12-30 1899-12-30 10.0
774 118675 2014-04-19 1899-12-30 1899-12-30 8.5
775 119999 2014-04-20 1899-12-30 1899-12-30 9.5
776 123994 2014-04-21 1899-12-30 1899-12-30 9.75
777 129923 2014-04-22 1899-12-30 1899-12-30 10.0
778 155544 2014-04-23 1899-12-30 1899-12-30 10.25
779 176632 2014-04-24 1899-12-30 1899-12-30 10.5
780 187629 2014-04-25 1899-12-30 1899-12-30 10.75
781 198765 2014-04-26 1899-12-30 1899-12-30 11.0
782 100000 2014-04-27 1899-12-30 1899-12-30 11.25
783 112394 2014-04-28 1899-12-30 1899-12-30 11.5
784 113322 2014-04-29 1899-12-30 1899-12-30 11.75
785 118675 2014-04-30 1899-12-30 1899-12-30 12.0
786 119999 2014-05-01 1899-12-30 1899-12-30 12.25
787 123994 2014-05-02 1899-12-30 1899-12-30 12.5
788 129923 2014-05-03 1899-12-30 1899-12-30 12.75
789 155544 2014-05-04 1899-12-30 1899-12-30 13.0
790 176632 2014-05-05 1899-12-30 1899-12-30 13.25
791 187629 2014-05-06 1899-12-30 1899-12-30 13.5
792 198765 2014-05-07 1899-12-30 1899-12-30 13.75
793 100000 2014-05-08 1899-12-30 1899-12-30 8.0
794 112394 2014-05-09 1899-12-30 1899-12-30 9.0
795 113322 2014-05-10 1899-12-30 1899-12-30 10.0
796 118675 2014-05-11 1899-12-30 1899-12-30 8.5
797 119999 2014-05-12 1899-12-30 1899-12-30 9.5
798 123994 2014-05-13 1899-12-30 1899-12-30 9.75
799 129923 2014-05-14 1899-12-30 1899-12-30 10.0
800 155544 2014-05-15 1899-12-30 1899-12-30 10.25
801 176632 2014-05-16 1899-12-30 1899-12-30 10.5
802 187629 2014-05-17 1899-12-30 1899-12-30 10.75
803 198765 2014-05-18 1899-12-30 1899-12-30 11.0
804 100000 2014-05-19 1899-12-30 1899-12-30 11.25
805 112394 2014-05-20 1899-12-30 1899-12-30 11.5
806 113322 2014-05-21 1899-12-30 1899-12-30 11.75
807 118675 2014-05-22 1899-12-30 1899-12-30 12.0
808 119999 2014-05-23 1899-12-30 1899-12-30 12.25
809 123994 2014-05-24 1899-12-30 1899-12-30 12.5
810 129923 2014-05-25 1899-12-30 1899-12-30 12.75
811 155544 2014-05-26 1899-12-30 1899-12-30 13.0
812 176632 2014-05-27 1899-12-30 1899-12-30 13.25
813 187629 2014-05-28 1899-12-30 1899-12-30 13.5
814 198765 2014-05-29 1899-12-30 1899-12-30 13.75
815 100000 2014-05-30 1899-12-30 1899-12-30 8.0
816 112394 2014-05-31 1899-12-30 1899-12-30 9.0
817 113322 2014-06-01 1899-12-30 1899-12-30 10.0
818 118675 2014-06-02 1899-12-30 1899-12-30 8.5
819 119999 2014-06-03 1899-12-30 1899-12-30 9.5
820 123994 2014-06-04 1899-12-30 1899-12-30 9.75
821 129923 2014-06-05 1899-12-30 1899-12-30 10.0
822 155544 2014-06-06 1899-12-30 1899-12-30 10.25
823 176632 2014-06-07 1899-12-30 1899-12-30 10.5
824 187629 2014-06-08 1899-12-30 1899-12-30 10.75
825 198765 2014-06-09 1899-12-30 1899-12-30 11.0
826 100000 2014-06-10 1899-12-30 1899-12-30 11.25
827 112394 2014-06-11 1899-12-30 1899-12-30 11.5
828 113322 2014-06-12 1899-12-30 1899-12-30 11.75
829 118675 2014-06-13 1899-12-30 1899-12-30 12.0
830 119999 2014-06-14 1899-12-30 1899-12-30 12.25
831 123994 2014-06-15 1899-12-30 1899-12-30 12.5
832 129923 2014-06-16 1899-12-30 1899-12-30 12.75
833 155544 2014-06-17 1899-12-30 1899-12-30 13.0
834 176632 2014-06-18 1899-12-30 1899-12-30 13.25
835 187629 2014-06-19 1899-12-30 1899-12-30 13.5
836 198765 2014-06-20 1899-12-30 1899-12-30 13.75
837 100000 2014-06-21 1899-12-30 1899-12-30 8.0
838 112394 2014-06-22 1899-12-30 1899-12-30 9.0
839 113322 2014-06-23 1899-12-30 1899-12-30 10.0
840 118675 2014-06-24 1899-12-30 1899-12-30 8.5
841 119999 2014-06-25 1899-12-30 1899-12-30 9.5
842 123994 2014-06-26 1899-12-30 1899-12-30 9.75
843 129923 2014-06-27 1899-12-30 1899-12-30 10.0
844 155544 2014-06-28 1899-12-30 1899-12-30 10.25
845 176632 2014-06-29 1899-12-30 1899-12-30 10.5
846 187629 2014-06-30 1899-12-30 1899-12-30 10.75
847 198765 2014-07-01 1899-12-30 1899-12-30 11.0
848 100000 2014-07-02 1899-12-30 1899-12-30 11.25
849 112394 2014-07-03 1899-12-30 1899-12-30 11.5
850 113322 2014-07-04 1899-12-30 1899-12-30 11.75
851 118675 2014-07-05 1899-12-30 1899-12-30 12.0
852 119999 2014-07-06 1899-12-30 1899-12-30 12.25
853 123994 2014-07-07 1899-12-30 1899-12-30 12.5
854 129923 2014-07-08 1899-12-30 1899-12-30 12.75
855 155544 2014-07-09 1899-12-30 1899-12-30 13.0
856 176632 2014-07-10 1899-12-30 1899-12-30 13.25
857 187629 2014-07-11 1899-12-30 1899-12-30 13.5
858 198765 2014-07-12 1899-12-30 1899-12-30 13.75
859 100000 2014-07-13 1899-12-30 1899-12-30 8.0
860 112394 2014-07-14 1899-12-30 1899-12-30 9.0
861 113322 2014-07-15 1899-12-30 1899-12-30 10.0
862 118675 2014-07-16 1899-12-30 1899-12-30 8.5
863 119999 2014-07-17 1899-12-30 1899-12-30 9.5
864 123994 2014-07-18 1899-12-30 1899-12-30 9.75
865 129923 2014-07-19 1899-12-30 1899-12-30 10.0
866 155544 2014-07-20 1899-12-30 1899-12-30 10.25
867 176632 2014-07-21 1899-12-30 1899-12-30 10.5
868 187629 2014-07-22 1899-12-30 1899-12-30 10.75
869 198765 2014-07-23 1899-12-30 1899-12-30 11.0
870 100000 2014-07-24 1899-12-30 1899-12-30 11.25
871 112394 2014-07-25 1899-12-30 1899-12-30 11.5
872 113322 2014-07-26 1899-12-30 1899-12-30 11.75
873 118675 2014-07-27 1899-12-30 1899-12-30 12.0
874 119999 2014-07-28 1899-12-30 1899-12-30 12.25
875 123994 2014-07-29 1899-12-30 1899-12-30 12.5
876 129923 2014-07-30 1899-12-30 1899-12-30 12.75
877 155544 2014-07-31 1899-12-30 1899-12-30 13.0
878 176632 2014-08-01 1899-12-30 1899-12-30 13.25
879 187629 2014-08-02 1899-12-30 1899-12-30 13.5
880 198765 2014-08-03 1899-12-30 1899-12-30 13.75
881 100000 2014-08-04 1899-12-30 1899-12-30 8.0
882 112394 2014-08-05 1899-12-30 1899-12-30 9.0
883 113322 2014-08-06 1899-12-30 1899-12-30 10.0
884 118675 2014-08-07 1899-12-30 1899-12-30 8.5
885 119999 2014-08-08 1899-12-30 1899-12-30 9.5
886 123994 2014-08-09 1899-12-30 1899-12-30 9.75
887 129923 2014-08-10 1899-12-30 1899-12-30 10.0
888 155544 2014-08-11 1899-12-30 1899-12-30 10.25
889 176632 2014-08-12 1899-12-30 1899-12-30 10.5
890 187629 2014-08-13 1899-12-30 1899-12-30 10.75
891 198765 2014-08-14 1899-12-30 1899-12-30 11.0
892 100000 2014-08-15 1899-12-30 1899-12-30 11.25
893 112394 2014-08-16 1899-12-30 1899-12-30 11.5
894 113322 2014-08-17 1899-12-30 1899-12-30 11.75
895 118675 2014-08-18 1899-12-30 1899-12-30 12.0
896 119999 2014-08-19 1899-12-30 1899-12-30 12.25
897 123994 2014-08-20 1899-12-30 1899-12-30 12.5
898 129923 2014-08-21 1899-12-30 1899-12-30 12.75
899 155544 2014-08-22 1899-12-30 1899-12-30 13.0
900 176632 2014-08-23 1899-12-30 1899-12-30 13.25
901 187629 2014-08-24 1899-12-30 1899-12-30 13.5
902 198765 2014-08-25 1899-12-30 1899-12-30 13.75
903 100000 2014-08-26 1899-12-30 1899-12-30 8.0
904 112394 2014-08-27 1899-12-30 1899-12-30 9.0
905 113322 2014-08-28 1899-12-30 1899-12-30 10.0
906 118675 2014-08-29 1899-12-30 1899-12-30 8.5
SwitchboardID ItemNumber ItemText Command Argument
1 0 Main Switchboard Default
1 1 View Table 1 2
1 2 View Report 1 3
1 3 View Form 1 4
1 4 Print Report 1 5
1 5 Exit Application 6
2 0 View Table 0
2 1 Client Table 7 JMS Macros.Open Client Table
2 2 Technician Table 7 JMS Macros.Open Technician Table
2 3 Return to Main Switchboard 1 1
3 0 View Report 0
3 1 Billing Summary Report 7 JMS Macros.Preview Billing Summary Report
3 2 Clients by Technician 7 JMS Macros.Preview Clients by Technician
3 3 Clients by Type 7 JMS Macros.Preview Clients by Type
3 4 Return to Main Switchboard 1 1
4 0 View Form 0
4 1 Client 7 JMS Macros.Open Client Form
4 2 Technician Master Form 7 JMS Macros.Open Technician Master Form
4 3 Return to Main Switchboard 1 1
5 0 Print Report 0
5 1 Billing Summary Report 7 JMS Macros.Print Billing Summary Report
5 2 Clients by Technician 7 JMS Macros.Print Clients by Technician
5 3 Clients by Type 7 JMS Macros.Print Clients by Type
5 4 Return to Main Switchboard 1 1
Technician Number Last Name First Name Street City State Postal Code Hourly Rate YTD Earnings Start Date Notes Picture Employee ID
22 Levin Joe 26 Cotton Anderson TX 78077 ¤ 25.00 ¤ 8,245.00 2007-04-02 Has MOS certification in Word, Excel, and Access.
23 Rogers Brad 79 Marsden Liberty Corner TX 78080 ¤ 30.00 ¤ 9,143.30 2007-05-14 Extensive network experience. Has a good rapport with clients.
29 Rodriguez Maria 263 Topper Kingston TX 78084 ¤ 35.00 ¤ 9,745.50 2007-10-01 Excellent diagnostic skills. Prefers to handle hardware problems.
32 Torres Lee 34 Red Poppy Liberty Corner TX 78080 ¤ 23.00 ¤ 0.00 2008-01-14 Has MOS certification in Access.
Client Number Category Number Total Hours (est) Hours Spent
AM53 5 3 0
BE29 2 1 0
BE29 7 2 1
CR21 4 4 2
DE76 6 2 0
GR56 8 3 1
SA56 1 2 0
SA56 2 3 1
SA56 5 4 1
ST21 3 2 1
ST21 7 2 1
PARAMETERS __Technician Number Value; SELECT DISTINCTROW * FROM Client AS [Technician Master Form] WHERE ([__Technician Number] = [Technician Number]);
SELECT DISTINCTROW * FROM Client;
SELECT DISTINCTROW * FROM Client;
SELECT DISTINCTROW * FROM Employee;
SELECT * FROM [Switchboard Items] WHERE [ItemNumber]>0 And [SwitchboardID]=TempVars!SwitchboardID ORDER BY [ItemNumber];
SELECT Technician.[Technician Number], Technician.[First Name], Technician.[Last Name], Technician.[Hourly Rate], Technician.[YTD Earnings], Technician.[Start Date], Technician.Notes, Technician.Picture FROM Technician;
SELECT DISTINCTROW * FROM Client;
SELECT [Technician].[Technician Number], [Technician].[First Name], [Technician].[Last Name], [Client].[Client Number], [Client].[Client Name], [Client].[Client Type], [Client].[Billed], [Client].[Paid] FROM Technician INNER JOIN Client ON Technician.[Technician Number]=Client.[Technician Number];
SELECT DISTINCTROW * FROM Client;
SELECT DISTINCTROW * FROM Employee;
SELECT DISTINCTROW * FROM Employee;
SELECT DISTINCTROW * FROM Technician;
TRANSFORM Sum(Client.Paid) AS SumOfPaid SELECT Client.City, Sum(Client.Paid) AS [Total Of Paid] FROM Client GROUP BY Client.City PIVOT Client.[Technician Number];
UPDATE Client SET Client.[Client Type] = "RET";
SELECT Client.[Client Number], Client.[Client Name], Client.Billed FROM Client WHERE (((Client.City)=[Enter City]));
SELECT Employee.Birthdate FROM Employee WHERE (((Employee.FirstName)=[First name?]));
SELECT Technician.[Technician Number], Technician.[First Name], Technician.[Last Name], Technician.Notes FROM Technician WHERE (((Technician.Notes) Like "* MOS *") AND ((Technician.[Start Date])<#1/1/2008#));
SELECT Technician.[Technician Number], Technician.[First Name], Technician.[Last Name], Client.[Client Number], Client.[Client Name], Client.Billed FROM Technician LEFT JOIN Client ON Technician.[Technician Number] = Client.[Technician Number] ORDER BY Technician.[Last Name], Client.[Client Name];
SELECT Technician.[Technician Number], Client.[Client Number], [Work Orders].[Category Number], [Work Orders].[Hours Spent], [Total Hours (est)]-[Hours Spent] AS [Hours Remaining] FROM (Technician INNER JOIN Client ON Technician.[Technician Number] = Client.[Technician Number]) INNER JOIN [Work Orders] ON Client.[Client Number] = [Work Orders].[Client Number];