Access report date problem.

pinchin1

Guest

Posts: n/a

6th Jun 2010

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

« actualizaciones automaticas | Trying to calculate difference between two times in an access repo »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting date from date/time field in access report	PatB	Microsoft Access Reports	3	5th Mar 2009 09:27 PM
Date format problem in ACCESS VBA report filter	Palatini	Microsoft Access	4	3rd Apr 2008 09:03 AM
Access Date in Report...PLEASE HELP!!!!!!!!!!	=?Utf-8?B?SGFuc2ZvcmQgY29ybmV0dA==?=	Microsoft Access Forms	2	15th Sep 2006 08:29 PM
Access Date in Report	=?Utf-8?B?SGFuc2ZvcmQgY29ybmV0dA==?=	Microsoft Access Forms	0	15th Sep 2006 08:03 PM
set date in access report	=?Utf-8?B?R3JhaGFtIChUaGUgSm9jaykgVGhvbXNvbi4=?=	Microsoft Access Reports	1	30th Mar 2005 01:37 PM