trying to make report

I'm trying to make a monthly report. I have a form with a combo box where the user selects the month that he/she wants in the report and after clicking the ok button the report should show all of the information the table has with that month no matter what day (in the table the date is written: mm/dd/yyyy)

I have to do the same thing for a annual report and for a customer report

hope you can help

I will assume your question is "How do I do this?"

In your query create an expression of converts you record date to a month for comparison

SelectedMonth:Month(RecordDate)

Don't forget to look at year on you monthly report or you will get lastyears data as well
SelectYear:Year(RecordDate)


S-

can you give me an example cause I can't seem to get it right.

in the table I have a column called "date" wich stores the date like "dd/mm/yyy"
in the form that the user uses to select the month I have a combobox wich has the 12 months
after clicking the ok btn a report shows and it is supposed to show all of the info from that month(name,add,date,...)

I did the query but the report shows blank

I appreciate your help, thanks

SELECT Table1.tabledate, Month([tabledate]) AS QueryMonth
FROM Table1
WHERE (((Month([tabledate]))=[Form Object Month Criteria as a number]));

S-

thanks for the help. it worked