R
Rose B
I have a table with clients, a table of jobs that have been 'ordered' by
clients (with a 'job type' field) and a table of events that they have
attended (with an 'event type' field). What I need to do is to produce a
report, which takes in from/to date parameters, that shows all clients and
then for each one the number of times that they have oredered a particular
job type and how many times they have attended an event type, within the
date period specified. So, I would end up with one line per client and then
counts in each job type and event type column for that particular client. (I
then need total these job types and event types at the end of the report -
but I am hoping that this is the easy bit!).
Can anyone please suggest how I might best go about achieving this? I have
tried a few things but nothing seems to work. Will I have to create something
before running the report or on opening the report?
clients (with a 'job type' field) and a table of events that they have
attended (with an 'event type' field). What I need to do is to produce a
report, which takes in from/to date parameters, that shows all clients and
then for each one the number of times that they have oredered a particular
job type and how many times they have attended an event type, within the
date period specified. So, I would end up with one line per client and then
counts in each job type and event type column for that particular client. (I
then need total these job types and event types at the end of the report -
but I am hoping that this is the easy bit!).
Can anyone please suggest how I might best go about achieving this? I have
tried a few things but nothing seems to work. Will I have to create something
before running the report or on opening the report?