Results 1 to 2 of 2
2003-09-08, 17:50 #1
- Join Date
- Apr 2001
- New York, New York, USA
- Thanked 0 Times in 0 Posts
Rank Calls to Helpdesk each week by category (Access XP)
I am trying to create a report that gives me the top 10 ten helpdesk problems for each week. The data was imported from Excel and contains 17 weeks and 46 problem categories. I split out the Categories into their own table, and did the same for the weeks (3/10/2003, 3/17/2003, etc.) as you will see in the attached file. The query works for the week of 3/10/2003, but I need to be able to specify a week and run the report.
Any advice on where I'm going wrong would be greatly appreciated.
Be advised, if you send this file back to me, please zip it, as our servers do not accept .mdb files.
2003-09-25, 12:13 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Rank Calls to Helpdesk each week by category (Access XP)
I don't know if the problem is still relevant. If so, can you explain a few things?
- Why is Week_Of in tblWeekOf always 3/10/2003, regardeless of the value of WeekID?
- What is the relation, if any, between tblData_From_Excel and tblWeek_Of?