OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Setting Up & Running Reports (http://www.officefrustration.com/forumdisplay.php?f=26)
-   -   Access report date problem. (http://www.officefrustration.com/showthread.php?t=1119775)

pinchin1 June 6th, 2010 10:42 AM

Access report date problem.
 
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

Marshall Barton June 6th, 2010 11:18 AM

Access report date problem.
 
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]


All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
OfficeFrustration.com