calculations in Query/Reports

[nitwit]

I'm trying to make a report that will show when a member of an organization
is due for renewal. The membership is good for one year, and I have fields
that show how much they've paid, and when.

What calculation do I need to compile a list of names of people who expire
in any given month?

Thanks,

 

[Jeff Boyce]

Let's hope that it is their memberships and not them that are expiring in
any given month...

Everything starts with the data in Access. Unless you give us some idea of
what data you are collecting and how you have it stored (i.e., table
structure), it's going to be tough to offer specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[nitwit]

1st - Thanks for the quick reply. I'm sorry I wasn't more specific.

I have all data stored in an access table. Nothing fancy. Name, address,
etc. but I put in fields for amount paid, and date of payment. I figured
this would alow us to run a report showing who is paid, and When does their
MEMBERSHIP :+) expire.

I assumed it would have something to do with calculating when they had paid,
adding 12 months to that date, and comming up with when they're membership is
up for renewal?

thanks again,

 

[Jeff Boyce]

If you have a [DatePaid] field, you can use a query and the DateAdd()
function to find a date 12 months after [DatePaid].

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[nitwit]

what would that calculation formula look like?

thanks

NW

If you have a [DatePaid] field, you can use a query and the DateAdd()
function to find a date 12 months after [DatePaid].

Regards

Jeff Boyce
Microsoft Office/Access MVP

1st - Thanks for the quick reply. I'm sorry I wasn't more specific.

I have all data stored in an access table. Nothing fancy. Name, address,
etc. but I put in fields for amount paid, and date of payment. I figured
this would alow us to run a report showing who is paid, and When does
their
MEMBERSHIP :+) expire.

I assumed it would have something to do with calculating when they had
paid,
adding 12 months to that date, and comming up with when they're membership
is
up for renewal?

thanks again,

 

[Jeff Boyce]

Check Access HELP for the exact syntax to use with "DateAdd()".

Your expression will look something like:

DateAdd("m",12,[DatePaid])

Regards

Jeff Boyce
Microsoft Office/Access MVP

what would that calculation formula look like?

thanks

NW

If you have a [DatePaid] field, you can use a query and the DateAdd()
function to find a date 12 months after [DatePaid].

Regards

Jeff Boyce
Microsoft Office/Access MVP

1st - Thanks for the quick reply. I'm sorry I wasn't more specific.

I have all data stored in an access table. Nothing fancy. Name,
address,
etc. but I put in fields for amount paid, and date of payment. I
figured
this would alow us to run a report showing who is paid, and When does
their
MEMBERSHIP :+) expire.

I assumed it would have something to do with calculating when they had
paid,
adding 12 months to that date, and comming up with when they're
membership
is
up for renewal?

thanks again,



:

Let's hope that it is their memberships and not them that are expiring
in
any given month...

Everything starts with the data in Access. Unless you give us some
idea
of
what data you are collecting and how you have it stored (i.e., table
structure), it's going to be tough to offer specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I'm trying to make a report that will show when a member of an
organization
is due for renewal. The membership is good for one year, and I have
fields
that show how much they've paid, and when.

What calculation do I need to compile a list of names of people who
expire
in any given month?

Thanks,

 

[nitwit]

thanks for your help with this.
I appreciate that its taken quite a few replys.

Thanks again,
Jeff

Check Access HELP for the exact syntax to use with "DateAdd()".

Your expression will look something like:

DateAdd("m",12,[DatePaid])

Regards

Jeff Boyce
Microsoft Office/Access MVP

what would that calculation formula look like?

thanks

NW

If you have a [DatePaid] field, you can use a query and the DateAdd()
function to find a date 12 months after [DatePaid].

Regards

Jeff Boyce
Microsoft Office/Access MVP

1st - Thanks for the quick reply. I'm sorry I wasn't more specific.

I have all data stored in an access table. Nothing fancy. Name,
address,
etc. but I put in fields for amount paid, and date of payment. I
figured
this would alow us to run a report showing who is paid, and When does
their
MEMBERSHIP :+) expire.

I assumed it would have something to do with calculating when they had
paid,
adding 12 months to that date, and comming up with when they're
membership
is
up for renewal?

thanks again,



:

Let's hope that it is their memberships and not them that are expiring
in
any given month...

Everything starts with the data in Access. Unless you give us some
idea
of
what data you are collecting and how you have it stored (i.e., table
structure), it's going to be tough to offer specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I'm trying to make a report that will show when a member of an
organization
is due for renewal. The membership is good for one year, and I have
fields
that show how much they've paid, and when.

What calculation do I need to compile a list of names of people who
expire
in any given month?

Thanks,