Query

[Emma]

I have a field called intake coordinator where I get my statistics from.
Intake coordinator has a parameter ["Staff Name"]. This works great.
Unfortunately I now have a second field called secondary worker. If the
secondary worker is Emily or Jackie then count the client twice. Not sure how
to add this to my query?

 

[Golfinray]

Is it JUST Emily or Jackie? If so, I would suggest you add a field to your
table called, maybe, Client_count. Client_count would be eiither 1 or 2
depending if Jackie or Emily was there. Then try in a separate field of your
query:
Client_count:IIF([secondary worker]="Emily" OR "Jackie", "2", "1")

 

[Emma]

Yes that's good for my statistics however I'm still limited ie when I print a
client list for Emily the client should show up in her list as well as the
intake coordinators list. thanks for the help

Is it JUST Emily or Jackie? If so, I would suggest you add a field to your
table called, maybe, Client_count. Client_count would be eiither 1 or 2
depending if Jackie or Emily was there. Then try in a separate field of your
query:
Client_count:IIF([secondary worker]="Emily" OR "Jackie", "2", "1")

I have a field called intake coordinator where I get my statistics from.
Intake coordinator has a parameter ["Staff Name"]. This works great.
Unfortunately I now have a second field called secondary worker. If the
secondary worker is Emily or Jackie then count the client twice. Not sure how
to add this to my query?