Hi,
Within my database each record is owned by at least one staff member (I have a field called owner).
For a report I want to be able to provide a summary to say staff member 'x' owns 'y' records, staff member 'a' owns 'b' records, etc.
There are only 5 possible staff members so I'm happy to create calculated fields for each staff member in my query.
I'm having problems though - I cannot figure out how to create a calculated field which gives me the total number of records staff member 'x' owns.
Any ideas? Is there a better way of doing it? To complicate things, certain records could be owned by multiple staff members so ideally it needs to support wildcards.
Thanks in advance
Within my database each record is owned by at least one staff member (I have a field called owner).
For a report I want to be able to provide a summary to say staff member 'x' owns 'y' records, staff member 'a' owns 'b' records, etc.
There are only 5 possible staff members so I'm happy to create calculated fields for each staff member in my query.
I'm having problems though - I cannot figure out how to create a calculated field which gives me the total number of records staff member 'x' owns.
Any ideas? Is there a better way of doing it? To complicate things, certain records could be owned by multiple staff members so ideally it needs to support wildcards.
Thanks in advance