dues paid on a month with no future dues paid

[survivo01]

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

[June7]

Does this table have ALL members listed? Each member is unique in this table? Do you maintain history of payments?

Not really sure what the issue is but maybe:

SELECT * FROM tablename WHERE DatePaid<#3/31/2015#

[survivo01]

I did that but then I get records like paid 3/31/14. I have one table where all members are listed. Then I have another table where they paid there dues. I want to do twp things find members who paid for March but not yet paid for April. I also want to create a query for current members for the month but does not list future payments

[June7]

What's wrong with that? It complies with the criteria you stated. Need to more clearly explain the issue.