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.

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

Bob Galway


(E-Mail Removed)> wrote in message
news:B4D3F81E-0DD5-45D1-9EAD-(E-Mail Removed)...
>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.
>

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!


"bob" wrote:

> Use a calculated field in a query. Run your billing - which will be a
> Report - using the query.
>
> Bob Galway
>
>
> (E-Mail Removed)> wrote in message
> news:B4D3F81E-0DD5-45D1-9EAD-(E-Mail Removed)...
> >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.
> >
>
>
>