var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: automatically generate report
I have a research study database and I want a report to generate 2 weeks after the date in which an event took place. That is, today i should get a report with the people that did xxx 2 weeks ago. Let's say i want it at the end of each week. What's the easiest way to go about doing this?
WHERE datefield = DateAdd("d", datefield, -14)
you can also use docmd.sendobject to send the report as e-mail to yourself.
dateadd doesn't work
Not sure i'm doing this right. I did Dateadd("d", -14, Now()) and this doesn't work.
the function in access says to enter dateadd(interval, number, date). i also tried ("w", -2, now())
I don't know what docmd.sendobject is or what to do with that??? where do i enter that? Sorry, not too familiar with this stuff. But thanks for the suggestions!
sendobject method is a functuon that lets you send any access object (reports, tables, etc) as an email through internet. you can refer sendobject subject in Access help.
I don't know what docmd.sendobject is or what to do with that??? where do i enter that?
Be sure to use the (=) sign first, like this:
=DateAdd("d",-14, [name of your date field])
If your DateField had a name like uh...let's say, ProcessDate this would be how you do it:
Have a nice one,