I have a report that I need to pull accounts that contain services done together but only list those 2 services and not any other service on the account. The way I have it written now it will do that but also list other accounts because those others contain one of the services I have in the criteria. How can I modify my criteria and/or exclude the unwanted accounts?
{TRX_SERV_DT} in DateTime (2013,01,01) to DateTime (2013,01,03) and
({TRX_PROC_NO}=2418655 or
{TRX_PROC_NO}=240840)
acct# service code date of service
111 2418655 2013 01 01
111 2402840 2013 01 01
222 2418655 2013 01 02
333 2418655 2013 01 03
444 2402840 2013 01 03
This is my results on the above criteria/formula and I only want acct 111 to list on the report (accts in red should not appear on the report)
IP Logged
