C
ChuckW
Hi,
I have an application that will run weekly reminder
letters in the form of an MS Access Report for everyone
that had a treatment at our clinic a month ago but has
not rebooked. What I did was add 30 days to the
transaction date and called this reminder date and
filtered out everyone who has resceduled. I then used the
following date restrictor against the reminder date field.
Between Date()-Weekday(Date(),7)+1 And Date()-Weekday(Date
(),7)+7
We then run this report once a week. It will create a
letter for everyone who's reminder date falls into the
current week.
What I want to do is to create a report that will run
this bi-monthly rather than once a week. I may need to
create two buttons on my application. One for the first
half of the month and second for the second half. I would
need a date restrictor that starts at the first of the
month to the 15th for the first button. The second
button would have a date restrictor that goes from the
16th through the 30th or 31st (or 28th for February).
Can anyone give me a suggestion on the best way of doing
this?
Thanks,
Chuck
I have an application that will run weekly reminder
letters in the form of an MS Access Report for everyone
that had a treatment at our clinic a month ago but has
not rebooked. What I did was add 30 days to the
transaction date and called this reminder date and
filtered out everyone who has resceduled. I then used the
following date restrictor against the reminder date field.
Between Date()-Weekday(Date(),7)+1 And Date()-Weekday(Date
(),7)+7
We then run this report once a week. It will create a
letter for everyone who's reminder date falls into the
current week.
What I want to do is to create a report that will run
this bi-monthly rather than once a week. I may need to
create two buttons on my application. One for the first
half of the month and second for the second half. I would
need a date restrictor that starts at the first of the
month to the 15th for the first button. The second
button would have a date restrictor that goes from the
16th through the 30th or 31st (or 28th for February).
Can anyone give me a suggestion on the best way of doing
this?
Thanks,
Chuck