calculations in Query/Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
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,
 
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
 
what would that calculation formula look like?

thanks

NW



Jeff Boyce said:
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 said:
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,
Click to expand...
Click to expand...
 
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

nitwit said:
what would that calculation formula look like?

thanks

NW



Jeff Boyce said:
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 said:
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,
Click to expand...
Click to expand...
Click to expand...
 
thanks for your help with this.
I appreciate that its taken quite a few replys.

Thanks again,
Jeff



Jeff Boyce said:
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

nitwit said:
what would that calculation formula look like?

thanks

NW



Jeff Boyce said:
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,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top