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

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]