hi all !

i need a user to select a year from a list eg . 2007,2008,2009 when
searching in a form that will run a query .
however the date format in the table is eg. "31/3/09" .
how can i just search through the year part of the date using this
method ?
i think there is some simple code you have to type in the query but im
not sure what it would be.

thanks

Assuming the date field is named SomeDate, include in your Query Builder
Grid, define a calculated field as YearToSelect: Year([SomeDate]) and
assuming the control where the user selects a date is "cboSelectDate" on
Form frmMyQuery, in the Criteria line underneath the calculated field
"YearToSelect" enter Forms!frmMyQuery!cboSelectDate. That ought to do what
you want.

I generally do not run Queries in applications, but show the data either in
Forms or Reports, and I use the "WhereCondition" argument of the
DoCmd.OpenReport or DoCmd.OpenForm statement in a similar way to select the
data.

Larry Linson
Microsoft Office Access MVP


"brino" <bdsolutions2002 (AT) yahoo (DOT) com.au> wrote

On Mar 31, 1:03*pm, "Larry Linson" <boun... (AT) localhost (DOT) not> wrote:
thats brilliant !!

thanks for your help

"brino" <bdsolutions2002 (AT) yahoo (DOT) com.au> wrote

Thanks for your kind words.

How many records in the table? If there are tens or hundreds of thousands,
you should use an approach as described by Rick Brandt. But, if performance
were a significant factor, I might go even farther, and use VBA code to
construct SQL with the _values_ from the Form Controls, rather than using a
reference to those controls. If you have no more than hundreds or thousands
of records, the performance difference is not likely to be significant --
but, in any case, Rick's approach will be faster than the one I gave you.

You are welcome.

Larry Linson
Microsoft Office Access MVP




__________ Information from ESET Smart Security, version of virus signature database 3979 (20090331) __________

The message was checked by ESET Smart Security.

http://www.eset.com