In Access I have a report that is based on query filters...to generate the data for the report... I need to count the number of employee per supv. WITHOUT a major overall of the existing report/query.
Let me see if I can explain this clearly...
2 tables...joined by ssn 4 filter queries when this query runs I have the data for my report all nice and neat... except now I need to count each employee per supervisor and use that number in an avg calculation. each supv has an assign supvnbr that each page is grouped on footer ..
heres my thought...
part of the overall report includes employee name...count the employeenames... so if I create a new query that includes tblemplinfo...[employee name], [supvnbr ]
this query would count for me... then add this new query to the old one
my problem... HOW?
this is a select query with no option to count on any field...and the fact that the filter queries use * getting err msg...cant count on asteriks...blahblah
I need to update this query on the fly meaning...i cant rebuild the entire report/queries...
what i do have is the total for each employee already on the report if I could somehow get the avg of all of them without re-inventing the wheel...but without counting the empl per group i cant see how to get the calc. HELP!!
ANYONE WITH AN IDEA WOULD BE MUCH APPRECIATED!!!
Let me see if I can explain this clearly...
2 tables...joined by ssn 4 filter queries when this query runs I have the data for my report all nice and neat... except now I need to count each employee per supervisor and use that number in an avg calculation. each supv has an assign supvnbr that each page is grouped on footer ..
heres my thought...
part of the overall report includes employee name...count the employeenames... so if I create a new query that includes tblemplinfo...[employee name], [supvnbr ]
this query would count for me... then add this new query to the old one
my problem... HOW?
this is a select query with no option to count on any field...and the fact that the filter queries use * getting err msg...cant count on asteriks...blahblah
I need to update this query on the fly meaning...i cant rebuild the entire report/queries...
what i do have is the total for each employee already on the report if I could somehow get the avg of all of them without re-inventing the wheel...but without counting the empl per group i cant see how to get the calc. HELP!!
ANYONE WITH AN IDEA WOULD BE MUCH APPRECIATED!!!