Geting mont name in combo box

[Jayesh Tejani]

hello geniuses....



i have a database with date filed and i want a report month wise form that, for that i want to create form with combo box which contain month name form the date value in database please can u help me..................................

[ranman256]

In a 'report form', frmRpts, put a combo box for the months, and a box for year
The query will use limit using items in the form....
select * from table where month([DateFld]) = forms!frmRpts!cboMonth and year([DateFld]) = forms!frmRpts!txtYr

also in the query the report uses, create an extra virtual field:
Month([DateFld]) as Month
or
Format([DateFld],"mmmm") as Month

[Jayesh Tejani]

In a 'report form', frmRpts, put a combo box for the months, and a box for year
The query will use limit using items in the form....
select * from table where month([DateFld]) = forms!frmRpts!cboMonth and year([DateFld]) = forms!frmRpts!txtYr

also in the query the report uses, create an extra virtual field:
Month([DateFld]) as Month
or
Format([DateFld],"mmmm") as Month

THANKS.ranman256;312093
i understand last changes for query and i have successfully don that the the new filed show month name in every record, but please can u alebrate(more detail discprition) first part of your answer