Working with dates

[John]

Hi Folks,
I have succeeded in building my small database for
collecting regular subscriptions from members of a society, but now have
been asked to add a few extra features. I started with two tables
(Households,Payments) and have designed some really nice forms to allow data
input,review and editing. I added a subform to the "Households" form to
allow viewing of payments by each Household.

One of the columns in the households table shows "Payment Category"
(weekly,monthly,annually) and another shows Payment Due Date. I now need to
add a button to my Households/Payments form to flag payments which are
overdue or have not been made. I presume it will run a query on the
Households and Payments tables to filter out payments which are due but
which have not been made. What search expression do I need to write to
effect this query. I have used a wizard to write a few queries but when I
come to the sharp end of the query I am stumped by the expression
builder.Thanks in advance, John

 

[John]

Maybe the first part of this question should have been "How do I
automatically generate Payment Due dates based on the Members Payment
Category.(i.e.weekly,monthly,ect).Their Payment Category is entered in the
Households Table.......so the Payment Due Date should be shown in the
Payments Made Table. If thy are late to make a payment then to output a
report of overdue payments I would need to filter out all Payments Due Dates
= to or < today's date where the Payment Amount is null or =0.?????
or am I going about this all wrong.