Access report date problem.
in [Reports]
|
Prev: actualizaciones automaticas
Next: Trying to calculate difference between two times in an access repo
From: pinchin1 on 6 Jun 2010 05:42 I have created a lot of graphs to show various information. The problem I'm having is that I need the graphs to show the last 14 days of data. The criteria I have used is >Now()-15. This seems to work fine until it comes to the end of the month and then it will not cross over into the next month untill it has 14 days for that month instead of, say, 23/5/10 - 6/5/10. it only shows up to 31st. Any help would be greatly appreciated. Thanks
From: Marshall Barton on 6 Jun 2010 06:18
pinchin1 wrote: >I have created a lot of graphs to show various information. The problem I'm >having is that I need the graphs to show the last 14 days of data. The >criteria I have used is >Now()-15. This seems to work fine until it comes to >the end of the month and then it will not cross over into the next month >untill it has 14 days for that month instead of, say, 23/5/10 - 6/5/10. it >only shows up to 31st. There is something else causing that problem. Perhaps you some calculation that compares the month of two dates or your graph only displays one month or ... BTW, I think you want to use >Date()-15 or >DateAdd("d", -15, Date()) -- Marsh MVP [MS Access] |