Need help setting up a filter again.

[82280zx]

I'm a bit tired so I hope I make sense. I made a report to show calls for the current month, the report shows the call type, the users that had those call types and it counts how many of those calls each user had.

So example:
Call Type 1
Bob had 4


Billy had 3

I have the Report working... but I want to be able to make a form with two combobox's, one for year and one for month and filter my query so my report only shows a report for the Month and Year I selected via combo box's. I've done this with previous data but didn't have to work with dates yet.

My Call Query or Call Table has a date field formatted as 00/00/0000 . Does that make sense?

[June7]

Calculate fields in query to extract the month and year. Apply filter criteria to those constructed fields.

Year([date field])

Month([date field])

[82280zx]

Calculate fields in query to extract the month and year. Apply filter criteria to those constructed fields.

Year([date field])

Month([date field])

Those filters worked but how do I filter my combo box's to only show 1 month or 1 year based on the data? Right now it's showing a Month and Year for each record.

[June7]

Sorry, don't understand the question. Why should the combobox show only 1 year? It should list all years from the data. Limiting the month list to only those months that have data for each year is a cascading (dependent) combobox.

RowSource for each combobox:

SELECT DISTINCT Year([date field]) FROM tablename;

SELECT DISTINCT Month([date field]) FROM tablename WHERE Year([date field])=[cbxYear];

Will need code behind the year or month combobox to requery the month combobox.

Sub cbxMonth_GotFocus()
Me.cbxMonth.Requery
End Sub

Post the sql of the parameterized query if still have issue.

[82280zx]

No I wanted it to show all months all years, but the problem is it's showing January for each record, so when I drop the box down it shows January like 10 times in a row, same go's for the year. Does that make sense? I'll try what you listed here, thanks again for all your help June7.

[82280zx]

Sorry I forgot to close the post, your awesome btw June7! Wish I had the knowledge you have so I wouldn't have to bug ya so much. Thanks again!