Access 2003 Query

20 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • carlosdl
    Providing some example data and the results you would expect from it could also help.
    69,510 pointsBadges:
    report
  • kgonzales
    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
    20 pointsBadges:
    report
  • carlosdl
    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>  
    69,510 pointsBadges:
    report
  • carlosdl
    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.
    69,510 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following