Grouping & Count Problem

[John Daily]

Hi!

I have a query that has the following fields: trans_code, trans_date, total_charges, acct_num. The total charges and acct num are as Sum.
In my report I want to group 5 specific trans_codes in one group and then group 4 others in another group. There are about 600 different trans codes. In the first group I want to get the total of all for a particular month. I have that part figrued out. I just can't get the other 2 groups. Now with each of these other 2 groups they will have a count of the specific trans_codes and total_charges, acct_bal associated with those codes. I can't get this to work at all.

Here is what is should look like:

Number of Total Acct
Denials Charges Balance
Total Denials: 3,787 $41 million $28 million

No Precert Denials: ? ? ?

Not Med Nesc. Denails: ? ? ?

Please help!

TIA,

John

 

[Gary Miller]

John,

An easy way is to add a trans_codes_group field to your
trans_codes table and then assign them all to a group with
group 1 being the first to display, 2 the second, etc... and
now use that in your report grouping by bringing that into
your report query.

Gary Miller
Sisters, OR

"John Daily" <dailyjo1 at memorialhealth dot com> wrote in
message

Hi!

I have a query that has the following fields: trans_code,

trans_date, total_charges, acct_num. The total charges and
acct num are as Sum.

In my report I want to group 5 specific trans_codes in one

group and then group 4 others in another group. There are
about 600 different trans codes. In the first group I want
to get the total of all for a particular month. I have that
part figrued out. I just can't get the other 2 groups. Now
with each of these other 2 groups they will have a count of
the specific trans_codes and total_charges, acct_bal
associated with those codes. I can't get this to work at
all.