Last 7 Days Record

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Last 7 Days Record

Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

October 21st, 2006, 02:43 AM

prasanta2expert prasanta2expert is offline

prasanta2expert is offline

Authorized User

Join Date: Oct 2006

Posts: 63

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Last 7 Days Record

Hi Frnd,

Can you please tell me how to retreive last 7 days record from current date?

It will be very helpful if you provide your solution with sample code.

Thanks in Advance...

Old

October 23rd, 2006, 05:38 AM

sola

sola is offline

Authorized User

Join Date: Jan 2006

Posts: 38

Thanks: 0

Thanked 0 Times in 0 Posts

Default

hi
you will have to design a report
while designing the report,in the design grid,under date field(the date that u want to use as criteria),go to criteria row and enter
>=date()-7and <=date()

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
days-from-duration	Dinghus	XSLT	1	November 21st, 2007 04:05 AM
Help with sorting by days out	dbartelt	Access	1	November 25th, 2005 08:31 AM
convert to days	khautinh	SQL Server 2000	4	September 8th, 2005 02:09 PM
Days in a Month	jmss66	Classic ASP Basics	3	April 11th, 2005 05:57 PM
No of days	anandham	SQL Server 2000	2	March 21st, 2005 01:20 AM