I have a query where I am trying to see who is a member whose dues were paid last month but not this month. I don't want anyone who paid after 3/31/15.
ID DatePaid DateEnd Number of days paid First Name Middle Initial Last Name Monthly Yearly Lifetime 11 4/1/2014 3/31/2015 364 Adam
Frank Yes No No 6 3/1/2015 3/31/2015 30 Andrez
Velez Yes No No 5 3/1/2015 3/31/2015 30 Anna
Scott Yes No No 22 4/1/2014 3/31/2015 364 Bonnie
Lohman No Yes No 25 3/1/2015 3/31/2015 30 Bud
B Yes No No 29 3/1/2015 3/31/2015 30 Caroline
Hansen Yes No No 33 3/1/2015 3/31/2015 30 Chris
Moody Yes No No 30 3/1/2015 3/31/2015 30 Clay
Ruge Yes No No 39 3/1/2015 3/31/2015 30 Craig
Sinclare Yes No No 49 4/1/2014 3/31/2015 364 Dorna
Burrows No Yes No 52 3/1/2015 3/31/2015 30 Eryl
Jones Yes No No 65 3/1/2015 3/31/2015 30 Gary
Knecht Yes No No 64 3/1/2015 3/31/2015 30 Greno
S Yes No No 98 3/1/2015 3/31/2015 30 Jack
Upchurch Yes No No 99 3/1/2015 3/31/2015 30 Jedli
Vsriy Yes No No 89 3/1/2015 3/31/2015 30 Jim
Connolly Yes No No 192 3/1/2015 3/31/2015 30 Johnny
Arvoux Yes No No 104 3/1/2015 3/31/2015 30 K C Vber Yes No No 100 3/1/2015 3/31/2015 30 kathy
Reeck Yes No No 107 3/1/2015 3/31/2015 30 Kevin
Gibbons Yes No No 114 3/1/2015 3/31/2015 30 Lucille D Clark Yes No No 127 3/1/2015 3/31/2015 30 Mark
Yes No No 118 3/1/2015 3/31/2015 30 Matt
Meehan Yes No No 119 3/1/2015 3/31/2015 30 Melvin
Edman Yes No No 136 4/1/2014 3/31/2015 364 Michael
Sidebuttom No Yes No 117 3/1/2015 3/31/2015 30 Mike
Byrd Yes No No 138 3/1/2015 3/31/2015 30 Nathan
Bahman Yes No No 139 3/1/2015 3/31/2015 30 Nelson
Matcey Yes No No 143 3/1/2015 3/31/2015 30 Patty
Thomson Yes No No 144 3/1/2015 3/31/2015 30 Peggy
Mcloughlin Yes No No 159 3/1/2015 3/31/2015 30 Robin
Murrell Yes No No 158 4/1/2014 3/31/2015 364 Roger
Cousineav No Yes No 160 3/1/2015 3/31/2015 30 Roger
Pompei Yes No No 149 3/1/2015 3/31/2015 30 Ron
Rucker Yes No No 165 3/1/2015 3/31/2015 30 Sara
Curtis Yes No No 128 3/1/2015 3/31/2015 30 Shelby
Yes No No 163 3/1/2015 3/31/2015 30 Stacey
Carpenter Yes No No 175 4/1/2014 3/31/2015 364 Timothy P Cesolini No Yes No 3 3/1/2015 3/31/2015 30 Todd
H Yes No No 174 3/1/2015 3/31/2015 30 Tommy
V Yes No No 181 4/1/2014 3/31/2015 364 Valerie
Fabian No Yes No 185 3/1/2015 3/31/2015 30 Ward
S Yes No No 182 3/1/2015 3/31/2015 30 Wesley
Spagle Yes No No 187 4/1/2014 3/31/2015 364 Wil
T No Yes No