Assigning data to text box

[jon_iam]

I have a database I use to track certain items. Overall i might have 300 items to check, but I split these items over 3 years. I have a query that I can pull up the count of those items each year. What I would like to do is show a report of items done by month within a given year.

So, I have 12 text boxes on the report. If I only did items in June, then I would have some figure in the corresponding text box to show that in June I checked N items.

I thought I could use the Select Case function, but I'm getting an error message on one of my fields. I have a date field that I reformat in a query to show me only the first three letters of the month. This is the field I'm trying to look at with the Select Case. The error message I get says it can't find the field even though Access recognizes it.

Can anyone explain this error or suggest a way to sort out my data into monthly slots? I appreciate your attention to this.

[SJ McAbney]

Can you post your code?

[Norie]

Can you not use a Totals query and group on the expression that returns the month?

[flavo]

jon_iam,

Can you post your table structure please.. Have you tried basing a report on a cross tab query. Using the cross tab query wizard makes this easy as pie!

Dave :-)