Can I do this in Access? Please help

The basic idea is that I have to send letters 5 times a year at 1, 3, 6, 9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name Address(City-State-Zip).
The letters are slightly different from each other(based on length of time
since death, ie, 1 month, 3 months, etc(I would need to store 5 letters).
This data base of names would be processed at the first of each month.
Therefore any one person would only get one letter that month. Some would get
none.
If the processing month is 1 month from date of death, I need the program to
print out a 1 month form letter using the caregiver's name and address, and
so on depending on the matching criteria.
Also, would need, if possible, to sort data by deceased's name which could
be done separately anytime.
PLEASE help, this is a vital need. Many Thanks.
--
David

You could use a query with a calculated field to identify the records.
For instance the one month letters would be based on

Field: DateAdd("m",1,[DateOfDeath)
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) and
DateSerial(Year(Date()), Month(Date())+1,0)

Another way to handle this would be

Field: DateDiff("M",[DateOfDeath],Date())
Criteria: 1

Replace 1 with 3, 6, 9 or 12 to get the addresses for the other letters.



'================================================= ===
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'================================================= ===


caseysmydog wrote:
The basic idea is that I have to send letters 5 times a year at 1, 3, 6, 9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name Address(City-State-Zip).
The letters are slightly different from each other(based on length of time
since death, ie, 1 month, 3 months, etc(I would need to store 5 letters).
This data base of names would be processed at the first of each month.
Therefore any one person would only get one letter that month. Some would get
none.
If the processing month is 1 month from date of death, I need the program to
print out a 1 month form letter using the caregiver's name and address, and
so on depending on the matching criteria.
Also, would need, if possible, to sort data by deceased's name which could
be done separately anytime.
PLEASE help, this is a vital need. Many Thanks.

We are very new to Access. Where would the suggested query go?
Thanks
--
David


"John Spencer" wrote:

You could use a query with a calculated field to identify the records.
For instance the one month letters would be based on

Field: DateAdd("m",1,[DateOfDeath)
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) and
DateSerial(Year(Date()), Month(Date())+1,0)

Another way to handle this would be

Field: DateDiff("M",[DateOfDeath],Date())
Criteria: 1

Replace 1 with 3, 6, 9 or 12 to get the addresses for the other letters.



'================================================= ===
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'================================================= ===


caseysmydog wrote:
The basic idea is that I have to send letters 5 times a year at 1, 3, 6, 9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name Address(City-State-Zip).
The letters are slightly different from each other(based on length of time
since death, ie, 1 month, 3 months, etc(I would need to store 5 letters).
This data base of names would be processed at the first of each month.
Therefore any one person would only get one letter that month. Some would get
none.
If the processing month is 1 month from date of death, I need the program to
print out a 1 month form letter using the caregiver's name and address, and
so on depending on the matching criteria.
Also, would need, if possible, to sort data by deceased's name which could
be done separately anytime.
PLEASE help, this is a vital need. Many Thanks.

David,

If you need immediate help with this, I can create the database for you for
a very modest fee.

Steve



"caseysmydog" wrote in message
...
The basic idea is that I have to send letters 5 times a year at 1, 3, 6,
9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name
Address(City-State-Zip).
The letters are slightly different from each other(based on length of time
since death, ie, 1 month, 3 months, etc(I would need to store 5 letters).
This data base of names would be processed at the first of each month.
Therefore any one person would only get one letter that month. Some would
get
none.
If the processing month is 1 month from date of death, I need the program
to
print out a 1 month form letter using the caregiver's name and address,
and
so on depending on the matching criteria.
Also, would need, if possible, to sort data by deceased's name which could
be done separately anytime.
PLEASE help, this is a vital need. Many Thanks.
--
David

Create a new query
Select your table
Add the fields you want to see

In a blank field "cell" enter (replace DateOfDeath with the name of your field
DateAdd("m",1,[DateOfDeath)

Under that in the criteria cell enter
=1

RUn the query and you should get the data you want for the one month letter

Change the 1 to 3 to get the data for the 3-month letter

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

caseysmydog wrote:
We are very new to Access. Where would the suggested query go?
Thanks

ya got tables, queries, forms, macros, and modules.
so you have 5 guesses....;^)
you have a query designer that will help you assemble the data and include
your logic, but you might need to do some basic studying to understand the
concepts. it'll be time well spent.

"caseysmydog" wrote in message
...
We are very new to Access. Where would the suggested query go?
Thanks
--
David


"John Spencer" wrote:

You could use a query with a calculated field to identify the records.
For instance the one month letters would be based on

Field: DateAdd("m",1,[DateOfDeath)
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) and
DateSerial(Year(Date()), Month(Date())+1,0)

Another way to handle this would be

Field: DateDiff("M",[DateOfDeath],Date())
Criteria: 1

Replace 1 with 3, 6, 9 or 12 to get the addresses for the other letters.



'================================================= ===
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'================================================= ===


caseysmydog wrote:
The basic idea is that I have to send letters 5 times a year at 1, 3,
6, 9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name
Address(City-State-Zip).
The letters are slightly different from each other(based on length of
time
since death, ie, 1 month, 3 months, etc(I would need to store 5
letters).
This data base of names would be processed at the first of each month.
Therefore any one person would only get one letter that month. Some
would get
none.
If the processing month is 1 month from date of death, I need the
program to
print out a 1 month form letter using the caregiver's name and address,
and
so on depending on the matching criteria.
Also, would need, if possible, to sort data by deceased's name which
could
be done separately anytime.
PLEASE help, this is a vital need. Many Thanks.

what ever he quotes i'll do for half
;^P

"Steve" wrote in message
news
David,

If you need immediate help with this, I can create the database for you
for a very modest fee.

Steve



"caseysmydog" wrote in message
...
The basic idea is that I have to send letters 5 times a year at 1, 3, 6,
9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name
Address(City-State-Zip).
The letters are slightly different from each other(based on length of
time
since death, ie, 1 month, 3 months, etc(I would need to store 5 letters).
This data base of names would be processed at the first of each month.
Therefore any one person would only get one letter that month. Some would
get
none.
If the processing month is 1 month from date of death, I need the program
to
print out a 1 month form letter using the caregiver's name and address,
and
so on depending on the matching criteria.
Also, would need, if possible, to sort data by deceased's name which
could
be done separately anytime.
PLEASE help, this is a vital need. Many Thanks.
--
David

sorry, just being an arse....

"mcnewsxp" wrote in message
...
what ever he quotes i'll do for half
;^P

"Steve" wrote in message
news
David,

If you need immediate help with this, I can create the database for you
for a very modest fee.

Steve



"caseysmydog" wrote in message
...
The basic idea is that I have to send letters 5 times a year at 1, 3, 6,
9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name
Address(City-State-Zip).
The letters are slightly different from each other(based on length of
time
since death, ie, 1 month, 3 months, etc(I would need to store 5
letters).
This data base of names would be processed at the first of each month.
Therefore any one person would only get one letter that month. Some
would get
none.
If the processing month is 1 month from date of death, I need the
program to
print out a 1 month form letter using the caregiver's name and address,
and
so on depending on the matching criteria.
Also, would need, if possible, to sort data by deceased's name which
could
be done separately anytime.
PLEASE help, this is a vital need. Many Thanks.
--
David

"Steve" wrote in message
news
David,

If you need immediate help with this, I can create the database for you
for a very modest fee.

Steve


As little stevie full well knows, these newgroups are provided by Microsoft
for FREE peer to peer support. Stevie is a well known troll who enjoys
preying on unsuspecting posters with offers of help of questionable value.

As he says, he will "create the database", but it is doubtful it will work
and do what you want.

John... Visio MVP

Thanks, John...but tell you the truth, after struggling with this and not
being successful I'd be glad to pay! I sat up the table and ran the query
but got an error...said something about the fields not being compatible.
Question: after you run the query and get the data, how do you relate that
to the letter?
--
David


"John... Visio MVP" wrote:

"Steve" wrote in message
news
David,

If you need immediate help with this, I can create the database for you
for a very modest fee.

Steve


As little stevie full well knows, these newgroups are provided by Microsoft
for FREE peer to peer support. Stevie is a well known troll who enjoys
preying on unsuspecting posters with offers of help of questionable value.

As he says, he will "create the database", but it is doubtful it will work
and do what you want.

John... Visio MVP