M
MichelleM via AccessMonster.com
Here's my situation. I have a parameter query (for date specific) set up to
track all inbound and outbound calls. Call Direction is the column heading
that states if the call was inbound or outbound. I'm trying to create a
report to do 3 things:
1. Give me the total contacts (Inbound and Outbound)
2. Give me the total of just Inbound
3. Give me the total of just Outbound
I have the total contacts text box set up and working, but now I'm stuck on
how to set up another text box to just bring back the total of the Inbound
contacts.
Here is my expression for the total
=Sum([qryBSC Inbound/Outbound Calls]!CountOfCallDirection)
I'm assuming I have to add in something with the CallDirection=Inbound, but
since I'm newer to Access and not real experienced with expressions, I'm
stuck. Any suggestions, would be great! Thanks!
track all inbound and outbound calls. Call Direction is the column heading
that states if the call was inbound or outbound. I'm trying to create a
report to do 3 things:
1. Give me the total contacts (Inbound and Outbound)
2. Give me the total of just Inbound
3. Give me the total of just Outbound
I have the total contacts text box set up and working, but now I'm stuck on
how to set up another text box to just bring back the total of the Inbound
contacts.
Here is my expression for the total
=Sum([qryBSC Inbound/Outbound Calls]!CountOfCallDirection)
I'm assuming I have to add in something with the CallDirection=Inbound, but
since I'm newer to Access and not real experienced with expressions, I'm
stuck. Any suggestions, would be great! Thanks!