Access 2003 Query
I have a table (tblRents)with the following fields:
RentID, LeaseID, StartDate, EndDate, RentalRate, TenantID and LessorID. For each lease entered, there could be several rent rates, each entered seperately with it's own RentID. I am trying to write a query that will give me each rent rate for the entire lease and the start and ending dates for each term. Basically, the LeaseID would be the same, but I am having trouble with the syntax. Any ideas?
Software/Hardware used:
MS Access 2003
Software/Hardware used:
MS Access 2003
ASKED:
October 11, 2012 9:05 PM
UPDATED:
October 12, 2012 3:39 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Can you show us a statement that is giving you trouble? It’s hard to comment on what we can’t see. Also, out of curiosity, why are TenantID and LessorID in this table? Aren’t they accessible through the LeaseID? — Tom
Providing some example data and the results you would expect from it could also help.
Here is my table, and I am not even quite sure where to start on the query. Do I use SELECT, or WHERE? The results I am trying to get on a report that will list each lease term and it’s corresponding rent rate. Example:1/1/12 – 12/31/12 $400.001/1/13 – 12/31/13 $450.00Any help anyone can give is greatly appreciated!tblRents
RentID
LeaseID
StartDate
EndDate
RentalRate
TenantID
LessorID
1
1
4/1/2010
6/30/2010
$44,226.78
1
2
2
1
7/1/2010
6/30/2011
$44,226.78
1
2
3
1
7/1/2011
6/30/2012
$45,332.45
1
2
4
1
7/1/2012
12/31/2012
$46,465.76
1
2
5
3
3/1/2010
2/28/2011
$9,116.10
3
16
6
3
3/1/2011
2/29/2012
$9,116.10
3
16
7
3
3/1/2012
2/28/2013
$9,376.56
3
16
8
3
3/1/2013
2/28/2014
$9,376.56
3
16
9
3
3/1/2014
2/28/2015
$9,637.02
3
16
10
4
3/1/2010
2/28/2011
$935.00
4
16
11
4
3/1/2011
2/29/2012
$935.00
4
16
12
4
3/1/2012
2/28/2013
$935.00
4
16
13
4
3/1/2013
2/28/2014
$935.00
4
16
14
4
3/1/2014
2/28/2015
$935.00
4
16
15
5
7/1/2010
7/31/2010
$0.00
5
16
16
5
8/1/2010
6/30/2011
$1,910.70
5
16
17
5
7/1/2011
6/30/2012
$1,910.70
5
16
18
5
7/1/2012
6/30/2013
$1,962.81
5
16
19
5
7/1/2013
6/30/2014
$1,962.81
5
16
20
5
7/1/2014
6/30/2015
$2,014.92
5
16
21
6
3/1/2011
2/29/2012
$1,304.40
6
16
22
6
3/1/2012
2/28/2013
$1,304.40
6
16
23
6
3/1/2013
2/28/2014
$1,337.55
6
16
24
6
3/1/2014
2/28/2015
$1,337.55
6
16
25
6
3/1/2015
2/29/2016
$1,385.75
6
16
26
7
3/1/2012
8/31/2012
$1,670.40
7
16
27
8
7/1/2011
6/30/2012
$1,150.00
8
17
28
9
8/1/2011
7/31/2012
$1,166.00
9
20
29
9
8/1/2012
7/31/2013
$1,166.00
9
20
30
10
4/1/2010
3/31/2011
$887.50
10
21
31
10
4/1/2011
3/31/2012
$887.50
10
21
32
10
4/1/2012
3/31/2013
$887.50
10
21
33
10
4/1/2013
3/31/2014
$887.50
10
21
34
10
4/1/2014
3/31/2015
$887.50
10
21
35
11
1/1/2010
12/31/2010
$4,183.40
11
23
36
11
1/1/2011
12/31/2011
$4,183.40
11
23
37
11
1/1/2012
12/31/2012
$4,308.90
11
23
38
14
8/1/2011
7/31/2012
$0.00
14
24
39
14
8/1/2012
7/31/2013
$4,010.05
14
24
40
14
8/1/2013
7/31/2014
$4,010.05
14
24
41
14
8/1/2014
7/31/2015
$4,254.14
14
24
42
14
8/1/2015
7/31/2016
$4,254.14
14
24
43
12
5/1/2010
4/30/2011
$1,646.40
12
24
44
12
5/1/2011
4/30/2012
$1,646.40
12
24
45
12
5/1/2012
4/30/2013
$1,756.16
12
24
46
12
5/1/2013
4/30/2014
$1,850.24
12
24
47
12
5/1/2014
4/30/2015
$1,960.11
12
24
48
13
6/1/2010
5/31/2011
$2,406.60
13
24
49
13
6/1/2011
5/31/2012
$2,406.60
13
24
50
13
6/1/2012
5/31/2013
$2,406.60
13
24
51
15
7/1/2011
6/30/2012
$24,795.15
15
26
52
15
7/1/2012
6/30/2013
$24,795.15
15
26
53
15
7/1/2013
6/30/2014
$25,539.01
15
26
54
15
7/1/2014
6/30/2015
$26,305.18
15
26
55
16
7/1/2011
6/30/2012
$4,785.29
16
26
56
16
7/1/2012
6/30/2013
$4,785.29
16
26
57
17
7/1/2011
6/30/2012
$3,502.90
17
30
58
17
7/1/2012
6/30/2013
$3,502.90
17
30
59
17
7/1/2013
6/30/2014
$3,594.28
17
30
60
19
4/14/2010
4/30/2010
$7,112.00
19
50
61
19
5/1/2010
4/30/2011
$7,112.00
19
50
62
19
5/1/2011
4/30/2012
$7,112.00
19
50
63
19
5/1/2012
4/30/2013
$7,264.40
19
50
64
19
5/1/2013
4/30/2014
$7,264.40
19
50
65
20
3/1/2010
2/28/2011
$29,928.14
20
50
66
20
3/1/2011
2/29/2012
$30,329.86
20
50
67
20
3/1/2012
2/28/2013
$31,535.02
20
50
68
20
3/1/2013
2/28/2014
$31,535.02
20
50
69
20
3/1/2014
2/28/2015
$32,740.18
20
50
70
21
3/1/2010
2/28/2011
$14,293.72
21
50
71
21
3/1/2011
2/29/2012
$14,293.72
21
50
72
21
3/1/2012
2/28/2013
$14,696.36
21
50
73
21
3/1/2013
2/28/2014
$14,696.36
21
50
74
21
3/1/2014
2/28/2015
$15,400.98
21
50
75
18
2/15/2009
6/14/2009
$2,263.00
18
50
76
18
6/15/2009
2/14/2010
$3,006.45
18
50
77
18
2/15/2010
2/14/2011
$3,006.45
18
50
78
18
2/15/2011
2/14/2012
$3,051.55
18
50
79
18
2/15/2012
2/14/2013
$3,097.32
18
50
80
18
2/15/2013
2/14/2014
$3,143.78
18
50
81
22
8/1/2010
9/30/2010
$0.00
22
53
82
22
10/1/2010
9/30/2011
$28,980.00
22
53
83
22
10/1/2011
9/30/2012
$28,980.00
22
53
84
22
10/1/2012
9/30/2013
$29,704.50
22
53
85
22
10/1/2013
9/30/2014
$29,704.50
22
53
86
22
10/1/2014
9/30/2015
$30,447.11
22
53
87
23
7/1/2008
8/31/2008
$10,531.09
23
56
88
23
9/1/2008
8/31/2009
$10,933.04
23
56
89
23
9/1/2009
8/31/2010
$11,254.60
23
56
90
23
9/1/2010
8/31/2011
$11,608.32
23
56
91
23
9/1/2011
8/31/2012
$11,897.72
23
56
92
24
3/1/2007
8/31/2007
$14,334.02
24
56
93
24
9/1/2007
8/31/2008
$14,891.02
24
56
94
24
9/1/2008
8/31/2009
$15,448.02
24
56
95
24
9/1/2009
8/31/2010
$15,893.62
24
56
96
24
9/1/2010
8/31/2011
$16,339.22
24
56
97
24
9/1/2011
8/31/2012
$16,784.82
24
56
98
25
10/1/2009
9/30/2010
$64,460.66
25
61
99
25
10/1/2010
9/30/2011
$66,378.41
25
61
100
25
10/1/2011
9/30/2012
$68,353.69
25
61
101
25
10/1/2012
9/30/2013
$70,388.23
25
61
102
27
12/1/2011
11/30/2012
$1,987.20
27
67
103
27
12/1/2012
11/30/2013
$1,987.20
27
67
104
27
12/1/2013
11/30/2014
$2,073.60
27
67
105
27
12/1/2014
11/30/2015
$2,073.60
27
67
106
27
12/1/2015
11/30/2016
$2,160.00
27
67
107
28
3/1/2012
2/28/2013
$123,432.50
28
69
108
28
3/1/2013
2/28/2014
$127,135.48
28
69
109
28
3/1/2014
2/28/2015
$130,949.54
28
69
110
28
3/1/2015
2/28/2016
$134,878.03
28
69
111
28
3/1/2016
2/28/2017
$138,924.37
28
69
112
29
1/11/2012
1/31/2012
$0.00
29
74
113
29
2/1/2012
1/31/2013
$484.00
29
74
114
29
2/1/2013
1/31/2014
$484.00
29
74
115
29
2/1/2014
1/31/2015
$508.20
29
74
116
29
2/1/2015
1/31/2016
$508.20
29
74
117
29
2/1/2016
1/31/2017
$532.40
29
74
118
30
3/1/2010
5/31/2010
$16,036.99
30
74
119
30
6/1/2010
5/31/2011
$16,518.10
30
74
120
30
6/1/2011
5/31/2012
$17,013.64
30
74
121
30
6/1/2012
5/31/2013
$17,524.05
30
74
122
32
3/14/2012
3/31/2012
$6,066.81
32
74
123
32
4/1/2012
2/28/2013
$10,448.40
32
74
124
32
3/1/2013
$10,883.75
32
74
125
31
3/1/2010
2/28/2011
$3,965.89
31
74
126
31
3/1/2011
2/29/2012
$4,084.87
31
74
127
31
3/1/2012
2/28/2013
$4,207.42
31
74
128
33
4/1/2010
3/31/2011
$11,135.30
33
76
129
33
4/1/2011
3/31/2012
$11,135.30
33
76
130
33
4/1/2012
3/31/2013
$11,641.45
33
76
131
33
4/1/2013
3/31/2014
$11,641.45
33
76
132
33
4/1/2014
3/31/2015
$12,147.60
33
76
133
34
4/1/2010
3/31/2011
$946.00
34
76
134
34
4/1/2011
3/31/2012
$946.00
34
76
135
34
4/1/2012
3/31/2013
$946.00
34
76
136
34
4/1/2013
3/31/2014
$946.00
34
76
137
34
4/1/2014
3/31/2015
$946.00
34
76
138
35
9/16/2011
9/30/2011
$10,391.05
35
79
139
35
10/1/2011
8/31/2012
$10,391.05
35
79
140
35
9/1/2012
8/31/2013
$10,391.05
35
79
141
35
9/1/2013
8/31/2014
$10,702.78
35
79
142
35
9/1/2014
8/31/2015
$11,023.86
35
79
143
35
9/1/2015
8/31/2016
$11,354.57
35
79
144
35
9/1/2016
9/15/2016
$11,354.57
35
79
145
36
10/1/2009
9/30/2010
$11,048.40
36
83
146
36
10/1/2010
9/30/2011
$11,048.40
36
83
147
36
10/1/2011
9/30/2012
$11,048.40
36
83
148
37
7/1/2011
6/30/2012
$7,638.38
37
89
149
37
7/1/2012
6/30/2013
$7,638.38
37
89
150
38
7/1/2006
6/30/2007
$8,280.00
38
88
151
38
7/1/2007
6/30/2008
$9,792.00
38
88
152
38
7/1/2008
6/30/2009
$10,152.00
38
88
153
38
7/1/2009
6/30/2010
$10,512.00
38
88
154
38
7/1/2010
6/30/2011
$10,872.00
38
88
155
38
7/1/2011
6/30/2012
$11,232.00
38
88
156
38
7/1/2012
6/30/2013
$11,592.00
38
88
157
39
4/1/2010
1/31/2011
$2,548.01
39
98
158
39
2/1/2011
1/31/2012
$2,624.44
39
98
159
39
2/1/2012
1/31/2013
$2,703.18
39
98
160
40
2/1/2010
1/31/2011
$42,739.20
40
101
161
40
2/1/2011
1/31/2012
$42,739.20
40
101
162
40
2/1/2012
1/31/2013
$43,655.04
40
101
163
40
2/1/2013
1/31/2014
$43,655.04
40
101
164
40
2/1/2014
1/31/2015
$44,876.16
40
101
165
41
5/1/2009
1/31/2010
$5,075.00
41
101
166
41
2/1/2010
1/31/2011
$8,278.60
41
101
167
41
2/1/2011
1/31/2012
$8,278.60
41
101
168
42
1/1/2009
4/30/2009
$3,500.00
42
101
169
42
5/1/2009
4/30/2010
$3,500.00
42
101
170
43
4/20/2007
2/29/2008
$1,375.00
43
101
171
43
3/1/2008
2/28/2009
$1,400.00
43
101
172
43
3/1/2009
2/28/2010
$1,442.50
43
101
173
43
3/1/2010
2/28/2011
$1,486.26
43
101
174
44
1/1/2006
12/31/2006
$11,287.50
44
101
175
44
1/1/2007
12/31/2007
$11,626.12
44
101
176
44
1/1/2008
12/31/2008
$11,974.90
44
101
177
44
1/1/2009
12/31/2009
$12,334.15
44
101
178
44
1/1/2010
12/31/2010
$12,704.17
44
101
179
45
3/1/2010
12/31/2010
$1,550.00
45
101
180
45
1/1/2011
12/31/2011
$1,550.00
45
101
181
45
1/1/2012
12/31/2012
$1,550.00
45
101
182
46
1/1/2012
2/29/2012
$0.00
46
103
183
46
3/1/2012
12/31/2012
$4,691.70
46
103
184
46
1/1/2013
12/31/2013
$4,691.70
46
103
185
47
1/1/2012
12/31/2012
$2,289.60
47
112
186
47
1/1/2013
12/31/2013
$2,289.60
47
112
187
47
1/1/2014
12/31/2014
$2,289.60
47
112
188
47
1/1/2015
12/31/2015
$2,404.08
47
112
189
47
1/1/2016
12/31/2016
$2,404.08
47
112
190
50
9/17/2007
11/16/2007
$0.00
50
279
191
50
11/17/2007
9/16/2008
$19,341.52
50
279
192
50
9/17/2008
9/16/2009
$19,921.77
50
279
193
50
9/17/2009
9/16/2010
$20,519.42
50
279
194
50
9/17/2010
9/16/2011
$21,135.00
50
279
195
50
9/17/2011
9/16/2012
$21,769.05
50
279
196
50
9/17/2012
9/16/2013
$22,422.12
50
279
197
50
9/17/2013
9/16/2014
$23,094.78
50
279
198
50
9/17/2014
9/16/2015
$23,787.63
50
279
199
50
9/17/2015
9/16/2016
$24,501.26
50
279
200
50
9/17/2016
9/16/2017
$25,236.30
50
279
201
49
1/1/2008
12/31/2008
$2,284.33
49
132
202
49
1/1/2009
12/31/2009
$2,352.86
49
132
203
49
1/1/2010
12/31/2010
$2,423.45
49
132
204
49
1/1/2011
12/31/2011
$2,496.15
49
132
205
49
1/1/2012
12/31/2012
$2,574.04
49
132
206
48
7/1/2010
8/31/2010
$0.00
48
132
207
48
9/1/2010
8/31/2011
$37,945.55
48
132
208
48
9/1/2011
8/31/2012
$38,924.79
48
132
209
48
9/1/2012
8/31/2013
$40,148.84
48
132
210
48
9/1/2013
8/31/2014
$41,372.89
48
132
211
48
9/1/2014
8/31/2015
$42,596.94
48
132
212
48
9/1/2015
8/31/2016
$43,820.99
48
132
213
48
9/1/2016
8/31/2017
$45,289.85
48
132
214
51
11/1/2008
10/31/2009
$46,095.00
51
136
215
51
11/1/2009
10/31/2010
$47,696.60
51
136
216
51
11/1/2010
10/31/2011
$49,354.26
51
136
217
51
11/1/2011
10/31/2012
$51,069.93
51
136
218
51
11/1/2012
10/31/2013
$52,845.65
51
136
219
52
9/1/2007
12/31/2007
$9,383.00
52
140
220
52
1/1/2008
6/30/2008
$31,928.00
52
140
221
52
7/1/2008
6/30/2009
$33,843.00
52
140
222
52
7/1/2009
6/30/2010
$35,536.00
52
140
223
52
7/1/2010
6/30/2011
$35,536.00
52
140
224
52
7/1/2011
6/30/2012
$38,468.00
52
140
225
52
7/1/2012
6/30/2013
$40,334.00
52
140
226
52
7/1/2013
6/30/2014
$41,901.00
52
140
227
52
7/1/2014
6/30/2015
$41,901.00
52
140
228
53
5/1/2011
4/30/2012
$4,650.00
53
144
229
53
5/1/2012
4/30/2013
$4,650.00
53
144
230
53
5/1/2013
4/30/2014
$4,798.80
53
144
231
53
5/1/2014
4/30/2015
$4,798.80
53
144
232
53
5/1/2015
4/30/2016
$4,947.60
53
144
233
56
4/1/2009
3/31/2010
$6,044.76
56
144
234
56
4/1/2010
3/31/2011
$5,603.50
56
144
235
56
4/1/2011
3/31/2012
$5,771.60
56
144
236
57
4/1/2012
4/30/2012
$41,077.50
57
144
237
57
5/1/2012
5/14/2012
$18,551.13
57
144
238
57
5/15/2012
5/31/2012
$18,551.13
57
144
239
57
6/1/2012
6/30/2012
$18,551.13
57
144
240
57
7/1/2012
3/31/2013
$18,551.13
57
144
241
57
4/1/2013
3/31/2014
$18,551.13
57
144
242
57
4/1/2014
3/31/2015
$18,551.13
57
144
243
58
10/1/2010
3/31/2012
$1,812.50
58
144
244
54
5/1/2011
4/30/2012
$3,300.00
54
144
245
54
5/1/2012
4/30/2013
$3,300.00
54
144
246
54
5/1/2013
4/30/2014
$3,405.60
54
144
247
54
5/1/2014
4/30/2015
$3,405.60
54
144
248
54
5/1/2015
4/30/2016
$3,511.20
54
144
249
55
4/1/2010
1/31/2011
$692.00
55
144
250
55
2/1/2011
1/31/2012
$692.00
55
144
251
55
2/1/2012
1/31/2013
$692.00
55
144
252
59
4/1/2010
5/31/2010
$28,269.31
59
144
253
59
6/1/2010
5/31/2011
$29,117.39
59
144
254
59
6/1/2011
5/31/2012
$29,990.92
59
144
255
59
6/1/2012
5/31/2013
$30,890.65
59
144
256
60
6/1/2010
5/31/2011
$3,360.00
60
147
257
60
6/1/2011
5/31/2012
$3,427.20
60
147
258
60
6/1/2012
5/31/2013
$3,495.74
60
147
259
60
6/1/2013
5/31/2014
$3,565.66
60
147
260
60
6/1/2014
5/31/2015
$3,636.97
60
147
261
62
3/14/2012
3/31/2012
$0.00
62
147
262
62
4/1/2012
4/30/2012
$0.00
62
147
263
62
5/1/2012
4/30/2013
$4,000.00
62
147
264
62
5/1/2013
4/30/2014
$4,000.00
62
147
265
62
5/1/2014
4/30/2015
$4,212.00
62
147
266
62
5/1/2015
4/30/2016
$4,212.00
62
147
267
62
5/1/2016
4/30/2017
$4,424.00
62
147
268
63
3/14/2012
3/31/2012
$0.00
63
147
269
63
4/1/2012
4/30/2012
$0.00
63
147
270
63
5/1/2012
4/30/2013
$2,880.00
63
147
271
63
5/1/2013
4/30/2014
$2,880.00
63
147
272
63
5/1/2014
4/30/2015
$2,880.00
63
147
273
63
5/1/2015
4/30/2016
$2,880.00
63
147
274
63
5/1/2016
4/30/2017
$2,880.00
63
147
275
61
3/1/2009
2/28/2010
$4,511.41
61
147
276
61
3/1/2010
2/28/2011
$4,060.27
61
147
277
61
3/1/2011
2/29/2012
$4,182.07
61
147
278
61
3/1/2012
2/28/2013
$4,307.54
61
147
279
61
3/1/2013
2/28/2014
$4,436.76
61
147
280
61
3/1/2014
2/28/2015
$4,569.86
61
147
281
64
2/1/2010
1/31/2011
$1,800.00
64
151
282
64
2/1/2011
1/31/2012
$1,854.00
64
151
283
64
2/1/2012
1/31/2013
$1,909.62
64
151
284
64
2/1/2013
1/31/2014
$1,966.91
64
151
285
64
2/1/2014
1/31/2015
$2,025.92
64
151
286
65
2/7/2008
1/31/2009
$6,968.75
65
156
287
65
2/1/2009
1/31/2010
$7,177.81
65
156
288
65
2/1/2010
1/31/2011
$7,393.15
65
156
289
65
2/1/2011
1/31/2012
$7,614.94
65
156
290
65
2/1/2012
1/31/2013
$7,843.39
65
156
291
66
1/1/2010
12/31/2010
$4,838.05
66
156
292
66
1/1/2011
12/31/2011
$4,838.05
66
156
293
66
1/1/2012
12/31/2012
$4,983.19
66
156
294
66
1/1/2013
12/31/2013
$4,983.19
66
156
295
66
1/1/2014
12/31/2014
$5,132.69
66
156
296
67
2/1/2012
1/31/2013
$3,816.25
67
157
297
67
2/1/2013
1/31/2014
$3,816.25
67
157
298
67
2/1/2014
1/31/2015
$4,121.55
67
157
299
67
2/1/2015
1/31/2016
$4,121.55
67
157
300
67
2/1/2016
1/31/2017
$4,121.55
67
157
301
68
2/1/2010
1/31/2011
$16,284.80
68
157
302
68
2/1/2011
1/31/2012
$16,284.80
68
157
303
68
2/1/2012
1/31/2013
$17,099.04
68
157
304
68
2/1/2013
1/31/2014
$17,099.04
68
157
305
68
2/1/2014
1/31/2015
$18,029.60
68
157
306
69
5/1/2012
4/30/2013
$750.00
69
174
307
69
5/1/2013
4/30/2014
$750.00
69
174
308
69
5/1/2014
4/30/2015
$862.50
69
174
309
69
5/1/2015
4/30/2016
$862.50
69
174
310
69
5/1/2016
4/30/2017
$945.00
69
174
311
70
7/1/2010
6/30/2011
$6,828.03
70
174
312
70
7/1/2011
6/30/2012
$6,828.03
70
174
313
70
7/1/2012
6/30/2013
$6,940.89
70
174
314
70
7/1/2013
6/30/2014
$7,053.75
70
174
315
74
4/4/2009
3/31/2010
$2,073.50
74
179
316
74
4/1/2010
3/31/2011
$2,135.71
74
179
317
74
4/1/2011
3/31/2012
$2,199.78
74
179
318
74
4/1/2012
3/31/2013
$2,265.77
74
179
319
74
4/1/2013
3/31/2014
$2,333.74
74
179
320
73
7/1/2009
6/30/2010
$1,166.67
73
179
321
73
7/1/2010
6/30/2011
$1,166.67
73
179
322
73
7/1/2011
6/30/2012
$1,166.67
73
179
323
73
7/1/2012
6/30/2013
$1,166.67
73
179
324
73
7/1/2013
6/30/2014
$1,201.67
73
179
325
73
7/1/2014
6/30/2015
$1,237.72
73
179
326
73
7/1/2015
6/30/2016
$1,274.85
73
179
327
71
12/1/2011
11/30/2012
$8,036.20
71
179
328
71
12/1/2012
11/30/2013
$8,036.20
71
179
329
71
12/1/2013
11/30/2014
$8,245.84
71
179
330
71
12/1/2014
11/30/2015
$8,245.84
71
179
331
71
12/1/2015
11/30/2016
$8,455.48
71
179
332
72
3/1/2010
2/28/2011
$1,704.15
72
179
333
72
3/1/2011
2/29/2012
$1,704.15
72
179
334
72
3/1/2012
2/28/2013
$1,755.27
72
179
335
75
1/1/2011
12/31/2011
$320.83
75
180
336
75
1/1/2012
12/31/2012
$320.83
75
180
337
75
1/1/2013
12/31/2013
$320.83
75
180
338
75
1/1/2014
12/31/2014
$320.83
75
180
339
75
1/1/2015
12/31/2015
$320.83
75
180
340
78
10/1/2007
9/30/2008
$5,220.96
78
25
341
78
10/1/2008
9/30/2009
$5,361.12
78
25
342
78
10/1/2009
9/30/2010
$5,501.28
78
25
343
78
10/1/2010
9/30/2011
$5,641.44
78
25
344
78
10/1/2011
9/30/2012
$5,781.60
78
25
345
78
10/1/2012
9/30/2013
$5,781.60
78
25
346
78
10/1/2013
9/30/2014
$5,921.76
78
25
347
78
10/1/2014
9/30/2015
$5,921.76
78
25
348
78
10/1/2015
9/30/2016
$6,061.92
78
25
349
78
10/1/2016
9/30/2017
$6,202.08
78
25
350
79
10/1/2007
9/30/2008
$11,072.19
79
25
351
79
10/1/2008
9/30/2009
$11,369.43
79
25
352
79
10/1/2009
9/30/2010
$11,666.67
79
25
353
79
10/1/2010
9/30/2011
$11,963.91
79
25
354
79
10/1/2011
9/30/2012
$12,261.15
79
25
355
79
10/1/2012
9/30/2013
$12,261.15
79
25
356
79
10/1/2013
9/30/2014
$12,558.39
79
25
357
79
10/1/2014
9/30/2015
$12,558.39
79
25
358
79
10/1/2015
9/30/2016
$12,855.63
79
25
359
79
10/1/2016
9/30/2017
$13,152.87
79
25
360
80
10/1/2007
9/30/2008
$13,095.61
224
81
361
80
10/1/2008
9/30/2009
$13,447.17
224
81
362
80
10/1/2009
9/30/2010
$13,798.73
224
81
363
80
10/1/2010
9/30/2011
$14,150.85
224
81
364
80
10/1/2011
9/30/2012
$14,501.85
224
81
365
80
10/1/2012
9/30/2013
$14,501.85
224
81
366
80
10/1/2013
9/30/2014
$14,853.41
224
81
367
80
10/1/2014
9/30/2015
$14,853.41
224
81
368
80
10/1/2015
9/30/2016
$15,204.97
224
81
369
80
10/1/2016
9/30/2017
$15,556.53
224
81
370
81
10/1/2007
9/30/2008
$1,934.02
81
121
371
81
10/1/2008
9/30/2009
$1,985.94
81
121
372
81
10/1/2009
9/30/2010
$2,037.86
81
121
373
81
10/1/2010
9/30/2011
$2,089.78
81
121
374
81
10/1/2011
9/30/2012
$2,141.70
81
121
375
81
10/1/2012
9/30/2013
$2,141.70
81
121
376
81
10/1/2013
9/30/2014
$2,193.62
81
121
377
81
10/1/2014
9/30/2015
$2,193.62
81
121
378
81
10/1/2015
9/30/2016
$2,245.54
81
121
379
81
10/1/2016
9/30/2017
$2,297.46
81
121
380
82
10/1/2007
9/30/2008
$7,716.71
82
63
381
82
10/1/2008
9/30/2009
$7,923.84
82
63
382
82
10/1/2009
9/30/2010
$8,131.03
82
63
383
82
10/1/2010
9/30/2011
$8,338.19
82
63
384
82
10/1/2011
9/30/2012
$8,545.35
82
63
385
82
10/1/2012
9/30/2013
$8,545.35
82
63
386
82
10/1/2013
9/30/2014
$8,752.51
82
63
387
82
10/1/2014
9/30/2015
$8,752.51
82
63
388
82
10/1/2015
9/30/2016
$8,959.67
82
63
389
82
10/1/2016
9/30/2017
$9,166.83
82
63
390
77
7/1/2011
6/30/2012
$34,978.96
77
25
391
77
7/1/2012
6/30/2013
$34,978.96
77
25
392
77
7/1/2013
6/30/2014
$34,978.96
77
25
393
77
7/1/2014
6/30/2015
$35,853.43
77
25
394
77
7/1/2015
6/30/2016
$36,749.77
77
25
395
76
7/1/2011
6/30/2012
$22,768.70
76
25
396
76
7/1/2012
6/30/2013
$23,337.92
76
25
397
76
7/1/2013
6/30/2014
$23,921.37
76
25
398
76
7/1/2014
6/30/2015
$24,519.40
76
25
399
76
7/1/2015
6/30/2016
$25,132.39
76
25
400
83
1/1/2011
12/31/2015
$1,545.00
83
34
401
85
2/15/2008
2/28/2009
$1,687.75
85
64
402
85
3/1/2009
2/28/2010
$1,738.38
85
64
403
85
3/1/2010
2/28/2011
$1,790.53
85
64
404
85
3/1/2011
2/29/2012
$1,844.24
85
64
405
85
3/1/2012
2/28/2013
$1,899.57
85
64
406
86
10/1/2005
9/30/2006
$9,640.00
86
65
407
86
10/1/2006
9/30/2007
$9,922.60
86
65
408
86
10/1/2007
9/30/2008
$10,213.68
86
65
409
86
10/1/2008
9/30/2009
$10,513.49
86
65
410
86
10/1/2009
9/30/2010
$10,822.29
86
65
411
86
10/1/2010
9/30/2011
$11,140.36
86
65
412
86
10/1/2011
9/30/2012
$11,467.97
86
65
413
87
10/1/2009
9/30/2010
$1,188.62
87
94
414
88
10/1/2009
9/30/2014
$117.00
88
94
415
87
10/1/2010
9/30/2011
$1,188.62
87
94
416
87
10/1/2011
9/30/2012
$1,188.62
87
94
417
87
10/1/2012
9/30/2013
$1,224.28
87
94
418
87
10/1/2013
9/30/2014
$1,224.28
87
94
419
89
5/1/2012
4/30/2013
$3,129.00
89
159
420
89
5/1/2013
4/30/2014
$3,129.00
89
159
421
89
5/1/2014
4/30/2015
$3,222.87
89
159
422
89
5/1/2015
4/30/2016
$3,222.87
89
159
423
89
5/1/2016
4/30/2017
$3,222.87
89
159
424
90
5/1/2012
4/30/2013
$1,716.48
90
160
425
90
5/1/2013
4/30/2014
$1,716.48
90
160
426
90
5/1/2014
4/30/2015
$1,767.97
90
160
427
90
5/1/2015
4/30/2016
$1,767.97
90
160
428
90
5/1/2016
4/30/2017
$1,767.97
90
160
429
92
5/1/2012
4/30/2013
$1,716.48
92
161
430
92
5/1/2013
4/30/2014
$1,716.48
92
161
431
92
5/1/2014
4/30/2015
$1,767.97
92
161
432
92
5/1/2015
4/30/2016
$1,767.97
92
161
433
92
5/1/2016
4/30/2017
$1,767.97
92
161
434
91
11/1/2011
10/31/2012
$1,730.33
91
161
435
91
11/1/2012
10/31/2013
$1,730.33
91
161
436
91
11/1/2013
10/31/2014
$1,730.33
91
161
437
91
11/1/2014
10/31/2015
$1,730.33
91
161
438
91
11/1/2015
10/31/2016
$1,730.33
91
161
439
93
11/1/2010
10/31/2011
$3,530.80
93
19
440
93
11/1/2011
10/31/2012
$3,829.56
93
19
441
93
10/1/2012
10/31/2013
$3,938.20
93
19
442
93
11/1/2013
10/31/2014
$4,046.84
93
19
443
93
11/1/2014
10/31/2015
$4,155.48
93
19
444
94
7/1/2008
6/30/2009
$2,056.02
94
49
445
94
7/1/2009
6/30/2010
$2,056.02
94
49
446
94
7/1/2010
6/30/2011
$2,056.02
94
49
447
94
7/1/2011
6/30/2012
$2,056.02
94
49
448
95
5/1/2012
4/30/2013
$1,476.00
95
55
449
95
5/1/2013
4/30/2014
$1,476.00
95
55
450
95
5/1/2014
4/30/2015
$1,512.00
95
55
451
95
5/1/2015
4/30/2016
$1,512.00
95
55
452
96
7/1/2010
6/30/2011
$439.10
96
60
453
96
7/1/2011
6/30/2012
$439.10
96
60
454
97
7/1/2010
6/30/2011
$262.20
97
60
455
97
7/1/2011
6/30/2012
$262.20
97
60
456
98
10/1/2007
9/30/2008
$971.63
98
60
457
99
4/1/2009
$500.00
99
85
458
98
10/1/2008
9/30/2009
$987.69
98
60
459
98
10/1/2009
9/30/2010
$1,003.75
98
60
460
98
10/1/2010
9/30/2011
$1,019.81
98
60
461
98
10/1/2011
9/30/2012
$1,035.87
98
60
462
101
6/1/2010
5/31/2011
$2,641.20
101
104
463
101
6/1/2011
5/31/2012
$2,641.20
101
104
464
101
6/1/2012
5/31/2013
$2,694.02
101
104
465
101
6/1/2013
5/31/2014
$2,747.90
101
104
466
100
6/1/2010
5/31/2011
$6,096.00
100
104
467
103
11/1/2009
$200.00
103
104
468
100
6/1/2011
5/31/2012
$6,248.40
100
104
469
100
6/1/2012
5/31/2013
$6,248.40
100
104
470
100
6/1/2013
5/31/2014
$6,400.08
100
104
471
100
6/1/2014
5/31/2015
$6,400.08
100
104
472
102
6/1/2010
5/31/2011
$2,553.60
102
104
473
102
6/1/2011
5/31/2012
$2,553.60
102
104
474
102
6/1/2012
5/31/2013
$2,630.21
102
104
475
102
6/1/2013
5/31/2014
$2,630.21
102
104
476
102
6/1/2014
5/31/2015
$2,709.12
102
104
477
104
10/1/2010
9/30/2012
$4,160.00
104
126
478
104
10/1/2012
9/30/2014
$4,284.80
104
126
479
106
6/1/2009
5/31/2010
$2,970.52
106
80
480
106
6/1/2010
7/31/2011
$2,732.88
106
80
481
105
8/1/2009
7/31/2010
$300.00
105
80
482
105
8/1/2010
7/31/2011
$300.00
105
80
483
107
7/1/2007
6/30/2008
$3,223.49
107
168
484
107
7/1/2008
6/30/2009
$3,223.49
107
168
485
107
7/1/2009
6/30/2010
$3,223.49
107
168
486
107
7/1/2010
6/30/2011
$3,223.49
107
168
487
107
7/1/2011
6/30/2012
$3,223.49
107
168
488
111
7/1/2006
6/30/2007
$4,985.45
111
168
489
111
7/1/2007
6/30/2008
$5,135.01
111
168
490
111
7/1/2008
6/30/2009
$5,289.06
111
168
491
111
7/1/2009
6/30/2010
$5,447.73
111
168
492
111
7/1/2010
6/30/2011
$5,611.16
111
168
493
110
7/2/2007
6/30/2008
$7,089.00
110
168
494
110
7/1/2008
6/30/2009
$7,436.50
110
168
495
110
7/1/2009
6/30/2010
$7,853.50
110
168
496
110
7/1/2010
6/30/2011
$8,201.00
110
168
497
110
7/1/2011
6/30/2012
$8,618.00
110
168
498
109
7/1/2007
6/30/2008
$969.47
109
168
499
109
7/1/2008
6/30/2009
$969.47
109
168
500
109
7/1/2009
6/30/2010
$969.47
109
168
501
109
7/1/2010
6/30/2011
$969.47
109
168
502
109
7/1/2011
6/30/2012
$969.47
109
168
503
108
7/1/2009
6/30/2010
$1,777.00
108
168
504
108
7/1/2010
6/30/2011
$1,777.00
108
168
505
108
7/1/2011
6/30/2012
$1,777.00
108
168
506
108
7/1/2012
6/30/2013
$1,777.00
108
168
507
108
7/1/2013
6/30/2014
$1,777.00
108
168
508
113
7/1/2008
6/30/2009
$721.00
113
171
509
113
7/1/2009
6/30/2010
$742.63
113
171
510
113
7/1/2010
6/30/2011
$764.90
113
171
511
112
7/1/2011
6/30/2012
$2,345.00
112
171
512
112
7/1/2012
6/30/2013
$2,345.00
112
171
513
112
7/1/2013
6/30/2014
$2,345.00
112
171
514
112
7/1/2014
6/30/2015
$2,345.00
112
171
515
115
10/1/2009
3/31/2010
$53,563.60
115
35
516
115
4/1/2010
1/31/2011
$53,563.60
115
35
517
115
2/1/2011
3/31/2011
$61,043.60
115
35
518
115
4/1/2011
3/31/2012
$62,839.00
115
35
519
115
4/1/2012
3/31/2013
$64,634.40
115
35
520
115
4/1/2013
3/31/2014
$66,429.80
115
35
521
115
4/1/2014
9/30/2014
$68,225.20
115
35
522
115
10/1/2014
11/30/2015
$71,816.00
115
35
523
114
1/1/2010
12/31/2010
$1,332.50
114
14
524
114
1/1/2011
12/31/2011
$1,373.00
114
14
525
114
1/1/2012
12/31/2012
$1,414.00
114
14
526
114
1/1/2013
12/31/2013
$1,546.00
114
14
527
114
1/1/2014
12/31/2014
$1,500.00
114
14
528
116
5/1/2007
4/30/2008
$26,000.00
116
71
529
116
5/1/2008
4/30/2009
$27,500.00
116
71
530
116
5/1/2009
4/30/2010
$28,050.00
116
71
531
116
5/1/2010
4/30/2011
$28,677.00
116
71
532
116
5/1/2011
4/30/2012
$29,183.22
116
71
533
116
5/1/2012
4/30/2013
$29,766.88
116
71
534
116
5/1/2013
4/30/2014
$30,362.22
116
71
535
116
5/1/2014
4/30/2015
$30,969.47
116
71
536
116
5/1/2015
4/30/2016
$31,588.86
116
71
537
116
5/1/2016
4/30/2017
$32,320.63
116
71
538
117
4/1/2007
3/31/2008
$5,644.80
117
78
539
117
4/1/2008
3/31/2009
$5,927.04
117
78
540
118
1/1/2009
6/30/2009
$0.00
118
108
541
118
7/1/2009
12/31/2010
$16,898.00
118
108
542
118
1/1/2011
12/31/2011
$17,395.00
118
108
543
118
1/1/2012
12/31/2012
$17,892.00
118
108
544
118
1/1/2013
12/31/2013
$18,389.00
118
108
545
118
1/1/2014
6/30/2014
$18,886.00
118
108
546
119
4/1/2011
6/30/2012
$3,540.00
119
117
547
119
7/1/2012
6/30/2013
$3,680.00
119
117
548
119
7/1/2013
6/30/2014
$3,820.00
119
117
549
119
7/1/2014
2/28/2015
$3,980.00
119
117
550
120
2/1/2006
1/31/2007
$14,350.00
120
155
551
120
2/1/2007
1/31/2008
$14,350.00
120
155
552
120
2/1/2008
1/31/2009
$15,050.00
120
155
553
120
2/1/2009
1/31/2010
$15,750.00
120
155
554
120
2/1/2010
1/31/2011
$16,450.00
120
155
555
120
2/1/2011
1/31/2012
$17,150.00
120
155
556
120
2/1/2012
1/31/2013
$17,780.00
120
155
557
121
5/1/2011
6/30/2011
$0.00
121
158
558
121
7/1/2011
11/30/2011
$26,964.00
121
158
559
121
12/1/2011
11/30/2012
$26,964.00
121
158
560
121
12/1/2012
11/30/2013
$29,211.00
121
158
561
121
12/1/2013
11/30/2014
$29,211.00
121
158
562
121
12/1/2014
11/30/2015
$31,458.00
121
158
563
121
12/1/2015
11/30/2016
$31,458.00
121
158
564
122
1/1/2010
2/28/2010
$0.00
122
164
565
122
3/1/2010
2/28/2011
$2,610.00
122
164
566
122
3/1/2011
2/29/2012
$2,714.40
122
164
567
122
3/1/2012
2/28/2013
$2,822.98
122
164
568
123
1/1/2011
12/31/2011
$12,162.60
123
3
569
123
1/1/2012
12/31/2012
$12,162.60
123
3
570
123
1/1/2013
12/31/2013
$12,500.45
123
3
571
123
1/1/2014
12/31/2014
$12,838.30
123
3
572
123
1/1/2015
12/31/2015
$13,176.15
123
3
573
124
12/1/2007
12/31/2007
$0.00
124
4
574
124
1/1/2008
11/30/2008
$25,595.70
124
4
575
124
12/1/2008
11/30/2009
$26,363.57
124
4
576
124
12/1/2009
11/30/2010
$27,154.48
124
4
577
124
12/1/2010
11/30/2011
$27,969.11
124
4
578
124
12/1/2011
11/30/2012
$28,808.18
124
4
579
125
10/1/2009
9/30/2010
$9,404.40
125
8
580
125
10/1/2010
9/30/2011
$9,404.40
125
8
581
125
10/1/2011
9/30/2012
$9,686.53
125
8
582
125
10/1/2012
9/30/2013
$9,977.13
125
8
583
125
10/1/2013
9/30/2014
$10,276.44
125
8
584
126
11/1/2006
6/30/2007
$2,322.65
126
9
585
127
$525.00
127
11
586
126
7/1/2007
12/31/2007
$5,642.60
126
9
587
126
1/1/2008
6/30/2008
$8,559.14
126
9
588
126
7/1/2008
6/30/2009
$8,679.50
126
9
589
126
7/1/2009
6/30/2010
$7,669.01
126
9
590
126
7/1/2010
6/30/2011
$8,129.15
126
9
591
126
7/1/2011
6/30/2012
$8,616.90
126
9
592
126
7/1/2012
6/30/2013
$9,133.92
126
9
593
128
1/1/2006
12/31/2006
$39,707.20
128
12
594
128
1/1/2007
12/31/2007
$40,302.81
128
12
595
128
1/1/2008
12/31/2008
$40,907.35
128
12
596
128
1/1/2009
12/31/2009
$41,520.96
128
12
597
128
1/1/2010
12/31/2010
$42,143.77
128
12
598
128
1/1/2011
12/31/2011
$42,775.93
128
12
599
128
1/1/2012
12/31/2012
$43,417.57
128
12
600
128
1/1/2013
12/31/2013
$44,068.83
128
12
601
128
1/1/2014
12/31/2014
$44,729.87
128
12
602
128
1/1/2015
12/31/2015
$45,400.81
128
12
603
129
12/1/2003
11/30/2004
$45,399.69
129
13
604
129
12/1/2004
11/30/2005
$46,761.68
129
13
605
129
12/1/2005
11/30/2006
$48,164.53
129
13
606
129
12/1/2006
11/30/2007
$49,609.47
129
13
607
129
12/1/2007
11/30/2008
$51,097.75
129
13
608
129
12/1/2008
11/30/2009
$52,630.60
129
13
609
129
12/1/2009
11/30/2010
$54,209.60
129
13
610
129
12/1/2010
11/30/2011
$55,835.89
129
13
611
129
12/1/2011
11/30/2012
$57,510.97
129
13
612
129
12/1/2012
11/30/2013
$59,236.30
129
13
613
134
2/1/2010
12/31/2010
$57,104.25
134
18
614
134
1/1/2011
12/31/2011
$57,104.25
134
18
615
134
1/1/2012
12/31/2012
$58,817.38
134
18
616
134
1/1/2013
12/31/2013
$60,581.90
134
18
617
134
1/1/2014
12/31/2014
$62,399.36
134
18
618
134
1/1/2015
12/31/2015
$64,271.33
134
18
619
130
1/10/2012
3/9/2012
$0.00
130
18
620
130
3/10/2012
3/31/2012
$2,906.33
130
18
621
130
4/1/2012
2/28/2013
$4,095.30
130
18
622
130
3/1/2013
2/28/2014
$4,095.30
130
18
623
130
3/1/2014
2/28/2015
$4,263.93
130
18
624
130
3/1/2015
2/29/2016
$4,263.93
130
18
625
130
3/1/2016
2/28/2017
$4,384.38
130
18
626
130
3/1/2017
2/28/2018
$4,384.38
130
18
627
130
3/1/2018
3/9/2018
$1,272.88
130
18
628
131
1/10/2012
3/9/2012
$0.00
131
18
629
131
3/10/2012
3/31/2012
$3,030.61
131
18
630
131
4/1/2012
2/28/2013
$4,270.40
131
18
631
131
3/1/2013
2/28/2014
$4,270.40
131
18
632
131
3/1/2014
2/28/2015
$4,446.24
131
18
633
131
3/1/2015
2/29/2016
$4,446.24
131
18
634
131
3/1/2016
2/28/2017
$4,571.84
131
18
635
131
3/1/2017
2/28/2018
$4,571.84
131
18
636
131
3/1/2018
3/9/2018
$1,374.55
131
18
637
133
11/9/2011
1/8/2012
$0.00
133
18
638
133
1/9/2012
1/31/2012
$1,162.90
133
18
639
133
2/1/2012
12/31/2012
$1,567.40
133
18
640
133
1/1/2013
12/31/2013
$1,567.40
133
18
641
133
1/1/2014
12/31/2014
$1,631.94
133
18
642
133
1/1/2015
12/31/2015
$1,631.94
133
18
643
133
1/1/2016
12/31/2016
$1,696.48
133
18
644
133
1/1/2017
12/31/2017
$1,696.48
133
18
645
133
1/1/2018
1/8/2018
$437.80
133
18
646
132
1/10/2012
3/9/2012
$0.00
132
18
647
132
3/10/2012
3/31/2012
$1,323.48
132
18
648
132
4/1/2012
2/28/2013
$1,864.90
132
18
649
132
3/1/2014
2/28/2014
$1,864.90
132
18
650
132
3/1/2014
2/28/2015
$1,941.69
132
18
651
132
3/1/2015
2/29/2016
$1,941.69
132
18
652
132
3/1/2016
2/28/2017
$1,996.54
132
18
653
132
3/1/2017
2/28/2018
$1,996.54
132
18
654
132
3/1/2018
3/9/2018
$579.54
132
18
655
137
12/1/2009
11/30/2010
$291.00
137
36
656
137
12/1/2010
11/30/2011
$305.55
137
36
657
137
12/1/2011
11/30/2012
$320.83
137
36
658
138
12/1/2006
1/31/2007
$0.00
138
37
659
138
2/1/2007
11/30/2007
$28,141.45
138
37
660
138
12/1/2007
11/30/2008
$28,985.69
138
37
661
138
12/1/2008
11/30/2009
$29,885.69
138
37
662
138
12/1/2009
11/30/2010
$30,750.92
138
37
663
138
12/1/2010
11/30/2011
$31,673.45
138
37
664
138
12/1/2011
11/30/2012
$32,623.65
138
37
665
138
12/1/2012
11/30/2013
$33,602.36
138
37
666
139
5/1/2012
4/30/2013
$29,677.05
139
39
667
139
5/1/2013
10/31/2013
$29,677.05
139
39
668
140
5/1/2008
4/30/2009
$16,005.17
140
43
669
140
5/1/2010
4/30/2010
$13,604.39
140
43
670
140
5/1/2011
4/30/2012
$13,604.39
140
43
671
140
5/1/2012
4/30/2013
$13,604.39
140
43
672
141
7/1/2009
7/31/2010
$2,937.00
141
44
673
141
8/1/2010
7/31/2011
$2,496.45
141
44
674
141
8/1/2011
7/31/2012
$2,496.45
141
44
675
141
8/1/2012
7/31/2013
$2,546.38
141
44
676
141
8/1/2013
7/31/2014
$2,546.38
141
44
677
141
8/1/2014
7/31/2015
$2,597.31
141
44
678
143
12/1/2011
11/30/2012
$1,105.00
143
48
679
143
12/1/2012
11/30/2013
$1,105.00
143
48
680
143
12/1/2013
11/30/2014
$1,138.15
143
48
681
143
12/1/2014
11/30/2015
$1,138.15
143
48
682
143
12/1/2015
11/30/2016
$1,172.29
143
48
683
144
8/1/2010
8/31/2010
$0.00
144
48
684
144
9/1/2010
7/31/2011
$7,715.90
144
48
685
144
8/1/2011
8/31/2011
$0.00
144
48
686
144
9/1/2011
7/31/2012
$7,715.90
144
48
687
144
8/1/2012
8/31/2012
$0.00
144
48
688
144
9/1/2012
7/31/2013
$7,715.90
144
48
689
144
8/1/2013
8/31/2013
$0.00
144
48
690
144
9/1/2013
7/31/2014
$7,715.90
144
48
691
144
8/1/2014
7/31/2015
$7,715.90
144
48
692
145
3/1/2010
1/31/2011
$23,062.20
145
51
693
145
2/1/2011
2/28/2011
$27,310.50
145
51
694
145
3/1/2011
3/31/2011
$27,917.40
145
51
695
145
4/1/2011
1/31/2012
$28,524.30
145
51
696
145
2/1/2012
1/31/2013
$29,131.20
145
51
697
145
2/1/2013
1/31/2014
$29,738.10
145
51
698
145
2/1/2014
9/30/2014
$30,345.00
145
51
699
146
2/1/2010
1/31/2011
$3,347.30
146
52
700
146
2/1/2011
1/31/2012
$3,347.30
146
52
701
146
2/1/2012
1/31/2013
$3,445.75
146
52
702
146
2/1/2013
1/31/2014
$3,445.75
146
52
703
146
2/1/2014
1/31/2015
$3,544.20
146
52
704
147
9/1/2006
8/31/2007
$42,191.60
147
57
705
147
9/1/2007
8/31/2008
$43,457.35
147
57
706
147
9/1/2008
8/31/2009
$44,761.07
147
57
707
147
9/1/2009
8/31/2010
$46,103.90
147
57
708
147
9/1/2010
8/31/2011
$47,487.02
147
57
709
151
9/2/2010
9/30/2010
$0.00
151
68
710
151
10/1/2010
9/30/2011
$5,049.00
151
68
711
151
10/1/2011
9/30/2012
$5,197.50
151
68
712
158
1/1/2012
12/31/2012
$2,585.20
158
70
713
158
1/1/2013
6/30/2013
$2,585.20
158
70
714
158
7/1/2013
6/30/2014
$2,662.76
158
70
715
158
7/1/2014
6/30/2015
$2,742.65
158
70
716
158
7/1/2015
1/31/2016
$2,742.65
158
70
717
159
1/1/2012
12/31/2012
$2,375.10
159
70
718
159
1/1/2013
6/30/2013
$2,434.48
159
70
719
159
7/1/2013
6/30/2014
$2,434.48
159
70
720
159
7/1/2014
6/30/2015
$2,495.34
159
70
721
159
7/1/2015
1/31/2016
$1,605.24
159
70
722
160
1/1/2012
12/31/2012
$658.50
160
70
723
160
1/1/2013
6/30/2013
$658.50
160
70
724
160
7/1/2013
6/30/2014
$678.26
160
70
725
160
7/1/2014
6/30/2015
$698.61
160
70
726
160
7/1/2015
1/31/2016
$698.61
160
70
727
161
1/1/2012
12/31/2012
$1,819.50
161
70
728
161
1/1/2013
12/31/2013
$1,819.50
161
70
729
161
1/1/2014
12/31/2014
$1,819.50
161
70
730
161
1/1/2015
12/31/2015
$1,819.50
161
70
731
161
1/1/2016
1/31/2016
$1,819.50
161
70
732
162
9/1/2008
1/31/2009
$28,039.76
162
70
733
162
2/1/2009
1/31/2010
$29,875.65
162
70
734
162
2/1/2010
1/31/2011
$29,875.65
162
70
735
162
2/1/2011
1/31/2012
$32,564.46
162
70
736
162
2/1/2012
1/31/2013
$32,564.46
162
70
737
162
2/1/2013
1/31/2014
$32,564.46
162
70
738
162
2/1/2014
1/31/2015
$32,564.46
162
70
739
162
2/1/2015
1/31/2016
$32,564.46
162
70
740
153
8/1/2012
6/30/2013
$895.00
153
70
741
153
7/1/2013
6/30/2014
$895.00
153
70
742
153
7/1/2014
6/30/2015
$895.00
153
70
743
154
1/1/2009
3/31/2009
$0.00
154
70
744
154
4/1/2009
12/31/2009
$2,387.55
154
70
745
154
1/1/2010
12/31/2010
$2,387.55
154
70
746
154
1/1/2011
12/31/2011
$2,435.30
154
70
747
154
1/1/2012
12/31/2012
$2,484.00
154
70
748
155
2/1/2012
1/31/2013
$4,554.00
155
70
749
155
2/1/2013
1/31/2014
$4,554.00
155
70
750
157
3/1/2012
2/28/2013
$1,061.18
157
70
751
157
3/1/2013
2/28/2014
$1,061.18
157
70
752
157
3/1/2014
2/28/2015
$1,094.00
157
70
753
157
3/1/2015
2/29/2016
$1,094.00
157
70
754
156
2/1/2012
1/31/2013
$3,288.30
156
70
755
156
2/1/2013
1/31/2014
$3,288.30
156
70
756
156
2/1/2014
1/31/2015
$3,390.00
156
70
757
156
2/1/2015
1/31/2016
$3,390.00
156
70
758
152
3/1/2011
2/29/2012
$2,087.48
152
70
759
152
3/1/2012
2/28/2013
$2,155.55
152
70
760
163
3/1/2010
12/31/2010
$2,203.25
163
75
761
163
1/1/2011
12/31/2011
$2,291.38
163
75
762
163
1/1/2012
12/31/2012
$2,379.51
163
75
763
163
1/1/2013
12/31/2013
$2,467.64
163
75
764
163
1/1/2014
12/31/2014
$2,555.77
163
75
765
163
1/1/2015
12/31/2015
$2,555.77
163
75
766
163
1/1/2016
12/31/2016
$2,555.77
163
75
767
164
3/1/2008
2/28/2009
$12,832.00
164
75
768
164
3/1/2009
2/28/2010
$13,281.00
164
75
769
164
3/1/2010
2/28/2011
$13,746.00
164
75
770
164
3/1/2011
2/29/2012
$14,227.00
164
75
771
164
3/1/2012
2/28/2013
$14,725.00
164
75
772
165
1/1/2012
1/31/2012
$0.00
165
82
773
165
2/1/2012
3/31/2012
$32,200.00
165
82
774
165
4/1/2012
4/30/2012
$0.00
165
82
775
165
5/1/2012
6/30/2012
$32,200.00
165
82
776
165
6/1/2012
7/31/2012
$0.00
165
82
777
165
8/1/2012
11/30/2012
$32,200.00
165
82
778
165
12/1/2012
12/31/2012
$33,180.00
165
82
779
165
1/1/2013
1/31/2013
$0.00
165
82
780
165
2/1/2013
11/30/2013
$33,180.00
165
82
781
165
12/1/2013
12/31/2013
$34,160.00
165
82
782
166
4/15/2008
10/14/2008
$0.00
166
87
783
166
10/15/2008
4/14/2009
$24,174.99
166
87
784
166
4/15/2009
4/14/2010
$24,900.24
166
87
785
166
4/15/2010
4/14/2011
$25,647.25
166
87
786
166
4/15/2011
4/14/2012
$26,416.66
166
87
787
166
4/15/2012
4/14/2013
$27,209.16
166
87
788
166
4/15/2013
4/14/2014
$28,025.44
166
87
789
166
4/15/2014
4/14/2015
$28,866.20
166
87
790
168
9/1/2008
9/30/2009
$0.00
168
88
791
168
10/1/2009
11/30/2009
$6,630.40
168
88
792
168
12/1/2009
11/30/2010
$6,630.40
168
88
793
168
12/1/2010
11/30/2011
$6,796.16
168
88
794
168
12/1/2011
11/30/2012
$6,966.06
168
88
795
168
12/1/2012
11/30/2013
$7,140.21
168
88
796
168
12/1/2013
7/31/2014
$7,318.72
168
88
797
167
2/1/2009
7/31/2009
$0.00
167
88
798
169
12/5/2006
$208.33
169
97
799
170
7/1/2007
$425.00
170
100
800
167
8/1/2009
7/31/2010
$9,401.20
167
88
801
167
8/1/2010
7/31/2011
$9,683.24
167
88
802
167
8/1/2011
7/31/2012
$9,973.74
167
88
803
167
8/1/2012
7/31/2013
$10,372.69
167
88
804
167
8/1/2013
7/31/2014
$10,787.60
167
88
805
171
1/1/2009
12/31/2009
$2,460.00
171
105
806
171
1/1/2010
12/31/2010
$2,533.80
171
105
807
171
1/1/2011
5/31/2012
$2,609.81
171
105
808
172
2/1/2012
1/31/2013
$34,231.75
172
106
809
172
2/1/2013
1/31/2014
$35,209.80
172
106
810
172
2/1/2014
1/31/2015
$35,209.80
172
106
811
172
2/1/2015
1/31/2016
$36,579.07
172
106
812
172
2/1/2016
1/31/2017
$36,579.07
172
106
813
172
2/1/2017
1/31/2018
$37,557.12
172
106
814
172
2/1/2018
1/31/2019
$37,557.12
172
106
815
174
4/23/2012
7/31/2012
$0.00
174
107
816
173
3/1/2012
$800.00
173
107
817
174
8/1/2012
8/31/2012
$2,989.50
174
107
818
175
5/1/2010
4/30/2011
$8,175.75
175
110
819
175
5/1/2011
4/30/2012
$8,175.75
175
110
820
175
5/1/2012
4/30/2013
$8,671.25
175
110
821
175
5/1/2013
4/30/2014
$8,671.25
175
110
822
175
5/1/2014
4/30/2015
$8,671.25
175
110
823
176
3/16/2009
3/15/2010
$5,448.76
176
110
824
176
3/16/2010
3/15/2011
$5,631.40
176
110
825
176
3/16/2011
3/15/2012
$5,844.48
176
110
826
176
3/16/2012
3/15/2013
$6,088.00
176
110
827
176
3/16/2013
3/15/2014
$6,392.40
176
110
828
177
11/1/2008
10/31/2009
$4,824.72
177
113
829
177
11/1/2009
10/31/2010
$4,969.46
177
113
830
177
11/1/2010
10/31/2011
$4,969.46
177
113
831
177
11/1/2011
10/31/2012
$5,118.55
177
113
832
177
11/1/2012
10/31/2013
$5,118.55
177
113
833
178
5/1/2009
4/30/2010
$3,300.00
178
114
834
178
5/1/2010
4/30/2011
$3,399.00
178
114
835
178
5/1/2011
4/30/2012
$3,500.97
178
114
836
178
5/1/2012
4/30/2013
$3,606.00
178
114
837
178
5/1/2013
4/30/2014
$3,714.18
178
114
838
179
5/1/2010
4/30/2011
$43,286.94
179
120
839
179
5/1/2011
4/30/2012
$44,552.64
179
120
840
179
5/1/2012
4/30/2013
$44,552.64
179
120
841
179
5/1/2013
4/30/2014
$45,818.34
179
120
842
179
5/1/2014
4/30/2015
$45,818.34
179
120
843
179
5/1/2015
4/30/2016
$47,084.04
179
120
844
181
5/1/2010
4/30/2011
$1,290.90
181
120
845
181
5/1/2011
4/30/2012
$1,290.90
181
120
846
181
5/1/2012
4/30/2013
$1,290.90
181
120
847
181
5/1/2013
4/30/2014
$1,290.90
181
120
848
181
5/1/2014
4/30/2015
$1,290.90
181
120
849
181
5/1/2015
4/30/2016
$1,290.90
181
120
850
180
5/1/2010
4/30/2011
$2,406.25
180
120
851
180
5/1/2011
4/30/2012
$2,406.25
180
120
852
180
5/1/2012
4/30/2013
$2,406.25
180
120
853
180
5/1/2013
4/30/2014
$2,406.25
180
120
854
180
5/1/2014
4/30/2015
$2,406.25
180
120
855
180
5/1/2015
4/30/2016
$2,406.25
180
120
856
184
10/13/2003
10/12/2004
$34,932.00
184
133
857
184
10/13/2004
10/12/2005
$35,784.00
184
133
858
184
10/13/2005
10/12/2006
$36,636.00
184
133
859
184
10/13/2006
10/12/2007
$37,488.00
184
133
860
184
10/13/2007
10/12/2008
$38,340.00
184
133
861
184
10/13/2008
10/12/2009
$39,192.00
184
133
862
184
10/13/2009
10/12/2010
$40,044.00
184
133
863
184
10/13/2010
10/12/2011
$40,896.00
184
133
864
184
10/13/2011
10/12/2012
$41,748.00
184
133
865
184
10/13/2012
10/12/2013
$42,600.00
184
133
866
185
10/15/2003
10/14/2004
$13,435.70
185
133
867
185
10/15/2004
10/14/2005
$13,763.40
185
133
868
185
10/15/2005
10/14/2006
$14,091.10
185
133
869
185
10/15/2006
10/14/2007
$14,418.80
185
133
870
185
10/15/2007
10/14/2008
$14,746.50
185
133
871
185
10/15/2008
10/14/2009
$15,074.90
185
133
872
185
10/15/2009
10/14/2010
$15,401.90
185
133
873
185
10/15/2010
10/14/2011
$15,729.60
185
133
874
185
10/15/2011
10/14/2012
$16,057.30
185
133
875
185
10/15/2012
10/14/2013
$16,385.00
185
133
876
183
10/16/2003
10/15/2004
$3,987.25
183
133
877
183
10/16/2004
10/15/2005
$4,084.50
183
133
878
183
10/16/2005
10/15/2006
$4,181.75
183
133
879
183
10/16/2006
10/15/2007
$4,279.00
183
133
880
183
10/16/2007
10/15/2008
$4,376.25
183
133
881
183
10/16/2008
10/15/2009
$4,473.50
183
133
882
183
10/16/2009
10/15/2010
$4,570.75
183
133
883
183
10/16/2010
10/15/2011
$4,668.00
183
133
884
183
10/16/2011
10/15/2012
$4,765.25
183
133
885
183
10/16/2012
10/15/2013
$4,862.50
183
133
886
186
6/1/2004
6/30/2006
$18,100.00
186
138
887
186
7/1/2006
1/8/2007
$19,865.00
186
138
888
186
1/9/2007
12/31/2007
$25,979.00
186
138
889
186
1/1/2008
12/31/2008
$25,979.00
186
138
890
186
1/1/2009
12/31/2009
$27,651.89
186
138
891
186
1/1/2010
12/31/2010
$27,651.89
186
138
892
186
1/1/2011
12/31/2011
$26,973.90
186
138
893
187
6/1/2007
5/31/2008
$5,234.50
187
139
894
187
6/1/2008
5/31/2009
$5,391.53
187
139
895
187
6/1/2009
5/31/2010
$5,553.28
187
139
896
187
6/1/2010
5/31/2011
$5,719.87
187
139
897
187
6/1/2011
5/31/2012
$5,891.47
187
139
898
188
2/1/2012
1/31/2013
$58,773.60
188
142
899
188
2/1/2013
1/31/2014
$60,536.80
188
142
900
188
2/1/2014
1/31/2015
$60,536.80
188
142
901
188
2/1/2015
1/31/2016
$62,352.91
188
142
902
188
2/1/2016
1/31/2017
$62,352.91
188
142
903
189
2/1/2012
1/31/2013
$3,936.00
189
142
904
189
2/1/2013
1/31/2014
$4,054.08
189
142
905
189
2/1/2014
1/31/2015
$4,054.08
189
142
906
189
2/1/2015
1/31/2016
$4,175.70
189
142
907
189
2/1/2016
1/31/2017
$4,175.70
189
142
908
190
10/1/2009
9/30/2010
$3,132.65
190
146
909
190
10/1/2010
9/30/2011
$2,745.00
190
146
910
190
10/1/2011
9/30/2012
$2,790.75
190
146
911
190
10/1/2012
9/30/2013
$2,836.50
190
146
912
190
10/1/2013
9/30/2014
$2,882.25
190
146
913
190
10/1/2014
9/30/2015
$2,928.00
190
146
914
191
1/1/2006
6/30/2006
$22,101.92
191
148
915
191
7/1/2006
6/30/2007
$22,224.13
191
148
916
191
7/1/2007
6/30/2008
$22,871.84
191
148
917
191
7/1/2008
6/30/2009
$23,541.55
191
148
918
191
7/1/2009
6/30/2010
$24,229.59
191
148
919
191
7/1/2010
12/31/2011
$24,938.41
191
148
920
192
5/1/2010
4/30/2011
$4,798.64
192
149
921
192
5/1/2011
4/30/2012
$4,798.64
192
149
922
192
5/1/2012
4/30/2013
$4,798.64
192
149
923
192
5/1/2013
4/30/2014
$5,114.34
192
149
924
192
5/1/2014
4/30/2015
$5,114.34
192
149
925
193
5/1/2010
4/30/2011
$2,786.16
193
113
926
193
5/1/2011
4/30/2012
$2,786.16
193
113
927
193
5/1/2012
4/30/2013
$2,786.16
193
113
928
193
5/1/2013
4/30/2014
$2,969.46
193
113
929
193
5/1/2014
4/30/2015
$2,969.46
193
113
930
194
5/1/2008
6/30/2008
$0.00
194
153
931
195
$670.00
195
154
932
194
7/1/2008
6/30/2009
$2,778.75
194
153
933
194
7/1/2009
6/30/2010
$2,862.11
194
153
934
194
7/1/2010
6/30/2011
$2,947.97
194
153
935
194
7/1/2011
6/30/2012
$3,036.41
194
153
936
194
7/1/2012
6/30/2013
$3,127.51
194
153
937
196
4/20/2007
4/30/2008
$22,000.00
196
165
938
196
5/1/2008
4/30/2009
$22,880.00
196
165
939
196
5/1/2009
4/30/2010
$23,795.20
196
165
940
196
5/1/2010
4/30/2011
$24,747.00
196
165
941
196
5/1/2011
4/30/2012
$25,736.89
196
165
942
197
5/1/2012
8/31/2012
$13,442.76
197
166
943
197
9/1/2012
9/30/2012
$0.00
197
166
944
197
10/1/2012
8/31/2013
$9,957.60
197
166
945
197
9/1/2013
9/30/2013
$0.00
197
166
946
197
10/1/2013
8/31/2014
$9,957.60
197
166
947
197
9/1/2014
8/31/2015
$10,289.52
197
166
948
197
9/1/2015
8/31/2016
$10,289.52
197
166
949
197
9/1/2016
8/31/2017
$10,621.44
197
166
950
197
9/1/2017
2/28/2018
$10,621.44
197
166
951
200
2/1/2008
11/30/2008
$19,462.57
200
166
952
200
12/1/2008
11/30/2009
$20,052.03
200
166
953
200
12/1/2009
11/30/2010
$20,652.01
200
166
954
200
12/1/2010
11/30/2011
$21,062.53
200
166
955
200
12/1/2011
11/30/2012
$21,486.57
200
166
956
200
12/1/2012
3/31/2013
$21,486.57
200
166
957
198
12/1/2006
11/30/2007
$14,020.31
198
166
958
198
12/1/2007
11/30/2008
$15,394.66
198
166
959
198
12/1/2008
11/30/2009
$16,128.56
198
166
960
198
12/1/2009
11/30/2010
$16,575.72
198
166
961
198
12/1/2010
11/30/2011
$17,037.69
198
166
962
201
5/1/2009
4/30/2010
$16,488.04
201
167
963
201
5/1/2010
4/30/2011
$14,378.03
201
167
964
201
5/1/2011
4/30/2012
$14,793.58
201
167
965
201
5/1/2012
4/30/2013
$15,209.13
201
167
966
201
5/1/2013
4/30/2014
$15,624.68
201
167
967
201
5/1/2014
4/30/2015
$16,123.34
201
167
968
202
5/1/2009
4/30/2010
$2,380.65
202
167
969
202
5/1/2010
4/30/2011
$2,076.00
202
167
970
202
5/1/2011
4/30/2012
$2,136.00
202
167
971
202
5/1/2012
4/30/2013
$2,196.00
202
167
972
202
5/1/2013
4/30/2014
$2,256.00
202
167
973
203
4/1/2012
3/31/2013
$5,400.00
203
169
974
203
4/1/2013
3/31/2014
$5,400.00
203
169
975
203
4/1/2014
3/31/2015
$5,550.00
203
169
976
203
4/1/2015
3/31/2016
$5,550.00
203
169
977
203
4/1/2016
3/31/2017
$5,700.00
203
169
978
204
3/1/2009
2/28/2010
$2,874.90
204
172
979
204
3/1/2010
2/28/2011
$2,965.55
204
172
980
204
3/1/2011
2/29/2012
$3,043.25
204
172
981
204
3/1/2012
2/28/2013
$3,133.90
204
172
982
204
3/1/2013
2/28/2014
$3,233.73
204
172
983
205
6/1/2012
5/31/2013
$2,844.00
205
173
984
205
6/1/2013
5/31/2014
$2,844.00
205
173
985
205
6/1/2014
5/31/2015
$2,995.68
205
173
986
205
6/1/2015
5/31/2016
$2,995.68
205
173
987
205
6/1/2016
5/31/2017
$3,058.88
205
173
988
206
10/1/2009
11/30/2009
$0.00
206
175
989
206
12/1/2009
11/30/2010
$52,734.25
206
175
990
206
12/1/2010
11/30/2011
$54,316.28
206
175
991
206
12/1/2011
11/30/2012
$55,945.77
206
175
992
206
12/1/2012
11/30/2013
$57,624.14
206
175
993
206
12/1/2013
11/30/2014
$59,352.86
206
175
994
206
12/1/2014
11/30/2015
$61,133.45
206
175
995
207
6/1/2008
7/31/2008
$0.00
207
177
996
207
8/1/2008
5/31/2009
$5,837.40
207
177
997
207
6/1/2009
5/31/2010
$6,012.52
207
177
998
207
6/1/2010
5/31/2011
$6,192.90
207
177
999
207
6/1/2011
5/31/2012
$6,378.68
207
177
1000
207
6/1/2012
5/31/2013
$6,570.05
207
177
1001
207
6/1/2013
7/31/2013
$6,767.15
207
177
1002
208
7/31/2008
12/31/2008
$9,595.00
208
183
1003
208
1/1/2009
7/31/2009
$14,337.40
208
183
1004
208
8/1/2009
7/31/2010
$14,767.52
208
183
1005
208
8/1/2010
7/31/2011
$15,210.55
208
183
1006
208
8/1/2011
7/31/2012
$15,666.86
208
183
1007
208
8/1/2012
7/31/2013
$16,136.87
208
183
1008
209
1/1/2010
12/31/2010
$676.33
209
1
1009
209
1/1/2011
12/31/2011
$1,352.66
209
1
1010
209
1/1/2012
12/31/2012
$1,352.66
209
1
1011
210
12/1/2006
11/30/2007
$1,643.99
210
1
1012
210
12/1/2007
11/30/2008
$1,693.31
210
1
1013
210
12/1/2008
11/30/2009
$1,744.11
210
1
1014
210
12/1/2009
11/30/2010
$1,796.43
210
1
1015
210
12/1/2010
11/30/2011
$1,850.32
210
1
1016
211
7/1/2011
6/30/2012
$628.30
211
7
1017
211
7/1/2012
6/30/2013
$628.30
211
7
1018
212
11/20/2009
11/30/2009
$0.00
212
15
1019
212
12/1/2009
11/30/2010
$2,791.00
212
15
1020
212
12/1/2010
11/30/2011
$2,875.00
212
15
1021
212
12/1/2011
11/30/2012
$2,961.00
212
15
1022
212
12/1/2012
11/30/2013
$3,050.00
212
15
1023
212
12/1/2013
11/30/2014
$3,142.00
212
15
1024
213
7/1/2011
6/30/2012
$150.00
213
22
1025
214
12/1/2004
11/30/2014
$6,000.00
214
33
1026
215
3/1/2010
$325.00
215
26
1030
84
3/21/2011
3/31/2011
$0.00
84
40
1031
84
4/1/2011
$1,250.00
84
40
1032
216
2/15/2010
2/28/2010
$0.00
216
41
1033
216
3/1/2010
2/28/2011
$2,480.00
216
41
1034
216
3/1/2011
2/29/2012
$2,480.00
216
41
1035
216
3/1/2012
2/28/2013
$2,540.00
216
41
1036
216
3/1/2013
2/28/2014
$2,540.00
216
41
1037
216
3/1/2014
2/28/2015
$2,620.00
216
41
1038
217
2/1/2012
1/31/2013
$5,277.36
217
45
1039
217
2/1/2013
1/31/2014
$5,277.36
217
45
1040
217
2/1/2014
1/31/2015
$5,437.28
217
45
1041
217
2/1/2015
1/31/2016
$5,437.28
217
45
1042
217
2/1/2016
1/31/2017
$5,597.20
217
45
1043
218
7/1/2010
6/30/2011
$650.00
218
46
1044
218
7/1/2011
6/30/2012
$650.00
218
46
1045
218
7/1/2012
6/30/2013
$650.00
218
46
1046
218
7/1/2013
6/30/2014
$650.00
218
46
1047
219
4/1/2010
3/31/2011
$1,150.96
219
54
1048
219
4/1/2011
6/30/2011
$1,173.98
219
54
1049
219
7/1/2011
3/31/2012
$1,381.16
219
54
1050
219
4/1/2012
3/31/2013
$1,408.77
219
54
1051
219
4/1/2013
3/31/2014
$1,436.95
219
54
1052
220
3/1/2012
2/28/2013
$1,700.00
220
59
1053
220
3/1/2013
2/28/2014
$1,700.00
220
59
1054
220
3/1/2014
2/28/2015
$1,700.00
220
59
1055
222
7/1/2010
6/30/2011
$2,131.46
222
77
1056
222
7/1/2011
6/30/2012
$1,939.50
222
77
1057
222
7/1/2012
6/30/2013
$1,939.50
222
77
1058
222
7/1/2013
6/30/2014
$1,991.22
222
77
1059
221
1/1/2010
12/31/2010
$900.00
221
77
1060
221
1/1/2011
12/31/2011
$900.00
221
77
1061
221
1/1/2012
12/31/2012
$900.00
221
77
1062
221
1/1/2013
12/31/2013
$900.00
221
77
1063
221
1/1/2014
12/31/2014
$900.00
221
77
1064
223
7/1/2007
9/30/2007
$2,866.50
223
77
1065
223
10/1/2007
9/30/2008
$2,866.50
223
77
1066
223
10/1/2008
9/30/2009
$2,952.19
223
77
1067
223
10/1/2009
9/30/2010
$3,041.07
223
77
1068
223
10/1/2010
9/30/2011
$3,132.30
223
77
1069
223
10/1/2011
9/30/2012
$3,226.27
223
77
1070
224
1/1/2010
3/31/2010
$2,970.52
224
81
1071
224
4/1/2010
12/31/2010
$2,673.47
224
81
1072
224
1/1/2011
12/31/2011
$2,753.68
224
81
1073
224
1/1/2012
12/31/2012
$2,836.28
224
81
1074
225
10/1/2010
9/30/2011
$150.00
225
84
1075
225
10/1/2011
9/30/2012
$150.00
225
84
1076
225
10/1/2012
9/30/2013
$150.00
225
84
1077
225
10/1/2013
9/30/2014
$150.00
225
84
1078
226
1/21/2011
1/31/2011
$1,275.00
226
90
1079
226
2/1/2011
3/31/2011
$1,275.00
226
90
1080
226
4/1/2011
3/30/2012
$1,313.00
226
90
1081
226
4/1/2012
3/30/2013
$1,353.00
226
90
1082
226
4/1/2013
3/30/2014
$1,393.00
226
90
1083
226
4/1/2014
3/30/2015
$1,435.00
226
90
1084
227
12/20/2004
12/31/2006
$245.00
227
91
1085
227
1/1/2007
12/31/2007
$288.00
227
91
1086
227
3/1/2008
5/31/2009
$293.00
227
91
1087
227
6/1/2009
5/31/2010
$293.00
227
91
1088
227
6/1/2010
5/31/2011
$293.00
227
91
1089
227
6/1/2011
$293.00
227
91
1090
228
7/1/2011
6/30/2012
$575.92
228
91
1091
228
7/1/2012
6/30/2013
$575.92
228
91
1092
229
4/1/2006
3/31/2007
$4,550.00
229
92
1093
229
4/1/2007
3/31/2008
$4,686.50
229
92
1094
229
4/1/2009
3/31/2009
$4,827.10
229
92
1095
229
4/1/2009
3/31/2010
$4,971.91
229
92
1096
229
4/1/2010
3/31/2011
$5,121.07
229
92
1097
230
7/1/2010
6/30/2011
$1,005.04
230
93
1098
231
1/1/2004
12/31/2004
$200.00
231
95
1099
232
10/1/2004
9/30/2006
$420.00
232
95
1100
230
7/1/2011
6/30/2012
$1,005.04
230
93
1101
230
7/1/2012
6/30/2013
$1,025.14
230
93
1102
230
7/1/2013
6/30/2014
$1,025.14
230
93
1103
230
7/1/2014
6/30/2015
$1,045.64
230
93
1104
233
9/1/2011
9/30/2011
$0.00
233
96
1105
233
10/1/2011
9/30/2012
$7,128.00
233
96
1106
233
10/1/2012
9/30/2013
$7,128.00
233
96
1107
233
10/1/2013
9/30/2014
$7,392.00
233
96
110
I cant’ believe you really posted your 1000+ records here. It doesn’t really help much, and doing something like that it is not recommended.
Your question about ‘SELECT or WHERE’ shows that you are absolutely new to SQL. I would really recommend to search for a basic course on SQL. Even if you get your answer and solution here, you will most likely needed it in the future.
If I understand correctly, you could need a simple GROUP BY query like this one:
select leaseid,rentalrate,min(startdate),max(enddate)
from tblrents
group by leaseid,rentalrate
order by <something>
An example including a small number of records (5 records could suffice) with the results you would want from those records would help us better understand your requirement.