If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Can I do this in Access? Please help
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. |
#3
|
|||
|
|||
Can I do this in Access? Please help
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. |
#5
|
|||
|
|||
Can I do this in Access? Please help
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 |
#6
|
|||
|
|||
Can I do this in Access? Please help
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. |
#7
|
|||
|
|||
Can I do this in Access? Please help
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 |
#8
|
|||
|
|||
Can I do this in Access? Please help
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 |
#9
|
|||
|
|||
Can I do this in Access? Please help
"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 |
#10
|
|||
|
|||
Can I do this in Access? Please help
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 |
Thread Tools | |
Display Modes | |
|
|