search records by month and year

[nurul]

hye all,



i would like to ask is there anyone know how to search records by month and year.
example i will have form that contain combobox that will list Jan-Dec.
and also unbound box for user to enter the year.

then, it will have search button. after the user click search button, it will show report of the selected month and year..

anyone know how can i get something like this..??

your help is much appreciate.

thank in advance.

[June7]

Presume you have a date/time field in table. Consider:

SELECT * FROM tablename WHERE Year([datefield]) & Format([datefield],"mmm") = [input year] & [input month];

Or:

DoCmd.OpenReport "reportname", , "Year([datefield]) & Format([datefield],'mmm') = '" & Me.[yeartextbox] & Me.[monthtextbox] & "'";

[nurul]

thank June7 for reply..

let me make clear of this..
this code i need to paste at query or else..?

SELECT * FROM tablename WHERE Year([datefield]) & Format([datefield],"mmm") = [input year] & [input month];

and the other one at search button..?am i right..?

DoCmd.OpenReport "reportname", , "Year([datefield]) & Format([datefield],'mmm') = '" & Me.[yeartextbox] & Me.[monthtextbox] & "'";


thank in advance

[nurul]

i already make use of the code that u give to me..

the problem is, when i search, instead showing the report in tab, it will automatically print the report..
i don't why it just print without showing the report first..as i see the code is DoCmd.OpenReport so, mean it will open the report not just print the report.

any idea about this..?

thank in advance.

[June7]

DoCmd.OpenReport "reportname", , acViewPreview, "Year([datefield]) & Format([datefield],'mmm') = '" & Me.[yeartextbox] & Me.[monthtextbox] & "'";

[nurul]

thank June7, it work great now..

if you don't mind, i want to ask how to set the report instead after we search it show in print preview, it will show in report view itself..?

thank in advance

[alansidman]

Look here

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[nurul]

thank alansidman.

it show in report view now..

but i think something is wrong here..i don't know why..even if i select for example dec, it will show all the records that in my db..
this code is correct right..?

DoCmd.OpenReport "historyReport", acViewReport, "Year([date_taken]) & Format([date_taken],'mmm') = '" & Me.[TextYear] & Me.[comboMonth] & "'"

i put it in my search button event procedure..?

thank in advance

[alansidman]

This should help also

http://www.datapigtechnologies.com/f...mtoreport.html

Alan