J
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
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