Crosstab Query - Report

  • Thread starter Thread starter TTownYankee
  • Start date Start date
T

TTownYankee

Guest
I have a table of procedures including name, date, staff and locationcovering several years.. I want to create a report with a column for each month and i want to count the number of procedures by nbamje for each staff and summ those by location. I also want horizontal totals. I used a crosstab query and thought I had everything working fine including a parameter query asking user to enter the desired year. Now, when I run the query< i get an undefined function in expression error (3085). I created query using crosstab quesry wizard. Now I al most....


Help!!!
 

Users who are viewing this thread

Back
Top Bottom