By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Date Query

matrekz42
P: 37
Good afternoon,

Maybe this is an easy task but I cant seem to figure it out. I want to create a query that will be linked to a list in a form, which has years ie: 2007,2008,etc...

I want to query a field that has 01/02/2007 but get everything that's in 2007 by only the year that the user selected in the form.

I know how to link it to the form ie:[Forms]![Report Form]![List27], but what formula or what should I use for the query to only recognize a piece of the by the year?
Oct 29 '08 #1
Share this Question
Share on Google+
1 Reply


DonRayner
Expert 100+
P: 489
Good afternoon,

Maybe this is an easy task but I cant seem to figure it out. I want to create a query that will be linked to a list in a form, which has years ie: 2007,2008,etc...

I want to query a field that has 01/02/2007 but get everything that's in 2007 by only the year that the user selected in the form.

I know how to link it to the form ie:[Forms]![Report Form]![List27], but what formula or what should I use for the query to only recognize a piece of the by the year?
Take a look at the datepart() function
Oct 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.