-
Assigning data to text box
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.
-
-
Can you not use a Totals query and group on the expression that returns the month?
-
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 :-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules