View Single Post
  #2  
Old June 6th, 2010, 11:18 AM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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]