How do I calculate overdue member fees?

[Guest]

I downloaded a template the other day,
Templates > Home and Community > Community and Fundraising > Volunteer and
Membership Materials >> Membership Database
I've been entering our membership list. There is a field for Date Joined,
Member Dues and there's a payment button, to enter payment information. It
will print an invoice to send the member to pay their dues, but it does not
show up they are due. Somewhere I need to add in a one year time frame and
have the invoice print out that it's time to pay their dues. As the database
is now, I would have to each month manually go through the dtatabase to see
who is due.

 

[bob]

Use a calculated field in a query. Run your billing - which will be a
Report - using the query.

Bob Galway


(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

Ok, Got the query figured out and a new report created. I have the query
calculating a year out and setting a new due date based on the Payment date.

Due Date: DateAdd("yyyy",1,[Payments]![PaymentDate])

Then the Criteria for this is 90 days overdue.

<Date()-90

Problem now is that is shows past payments as being late, instead of being
renewd.. This is a yearly fees due and this set up shows previous years as
being late and on the member page the amount due is showing they have a
credit since they've paid the fee more than once.

Still stuck, but still working on it!