CHapter 4 - using DatePart in query

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > BOOK: Beginning Access VBA
CHapter 4 - using DatePart in query

BOOK: Beginning Access VBA

This is the forum to discuss the Wrox book Beginning Access 2002 VBA by Robert Smith, Dave Sussman, Ian Blackburn, John Colby, Mark Horner, Martin Reid, Paul Turley, Helmut Watson; ISBN: 9780764544026

Read more about Beginning Access 2002 VBA or buy the book from your favorite retailer
Download the code for Beginning Access 2002 VBA

Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Access VBA 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

June 2nd, 2005, 02:48 PM

vgebha03

Registered User

Join Date: Jun 2005

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

CHapter 4 - using DatePart in query

I'm attempting the "Try it Out" activity on page 108 and am getting a Compile error when i try to enter this statement into a query.

SalesMonth: DatePart("m",[DateOrdered])

Anyone have any insight?

Thanks

dialerguy :D

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DatePart Calculations	ninel	SQL Language	2	February 29th, 2008 03:08 AM
Datepart	Vision G	Access	2	October 18th, 2006 06:56 AM
Make table Query and Datepart	marshaji	Access	1	June 21st, 2005 12:36 PM
DatePart	pab006	Classic ASP Basics	1	July 8th, 2004 12:50 PM
Datepart expression	[email protected]	Access	2	August 12th, 2003 07:31 AM