J
John Daily
Running Access 200
I was wondering if I can use DCount or DSum in a report that pulls other data from a query? Would I need a subreport
My report asks for user input (number of a month) parameter and I have a subreport that pulls data from another query and that info is also based on the same user parameter
Query 1 and 2 has its Unique Values set to YES and it pulls charges and balance information and does a count on account numbers.
There are 3 tables it pulls info from.
Patient Info (used to count the number of accounts
Payment Info (used to sum the payments for each account
Denial Codes (this is where it gets the denial date so that the user is prompted to enter the number of the month
It works great for just getting the total numbers for a whole month. I have 2 other summaries that pull specific payment and count information based on specific denial codes. I use the formula =Abs(Sum(([trans_code]) In ("T5001", "T5005"))*([total_charges])) to get the sum for the specific denial codes
If I put the subreport in that has its own query it prompts the user about 4 times for the number of the month
Can anyone help
TIA
John
I was wondering if I can use DCount or DSum in a report that pulls other data from a query? Would I need a subreport
My report asks for user input (number of a month) parameter and I have a subreport that pulls data from another query and that info is also based on the same user parameter
Query 1 and 2 has its Unique Values set to YES and it pulls charges and balance information and does a count on account numbers.
There are 3 tables it pulls info from.
Patient Info (used to count the number of accounts
Payment Info (used to sum the payments for each account
Denial Codes (this is where it gets the denial date so that the user is prompted to enter the number of the month
It works great for just getting the total numbers for a whole month. I have 2 other summaries that pull specific payment and count information based on specific denial codes. I use the formula =Abs(Sum(([trans_code]) In ("T5001", "T5005"))*([total_charges])) to get the sum for the specific denial codes
If I put the subreport in that has its own query it prompts the user about 4 times for the number of the month
Can anyone help
TIA
John