Report Counting Problem ** Please Help **

[Guest]

I have a report that pulls info from a query. The query gets acct_num (count), total_charges (sum), acct_bal (sum), trans_code (group by), trans_date (group by), and expr1: Month(trans_date) (expression). The expr1 prompts the user to enter the number of the month.

In the report I am trying to get the count only certain trans_codes. This is a summary report and for two fields of the summary I need to count 5 different trans_codes in each field. Example: In Total No Precert I want to count the number of accounts for the month entered that have specific trans_codes. There are 5 different trans_codes that relate to No Precert. I need the corresponding dollar amount for each of the two fields.

I can do this by creating a query for each field and then do a subreport in my main report but it asks for the Number of the Month for each subreport. There are 3 subreports that I have.

This is killing me! I have been trying to do this for 2 day without any luck!

Any help will be appreciated!

TIA,

John

 

[Annelie]

I would try to create a table which has to relate so your main table on some
field. In the new table I would create that related field, then the
trans_code, or any other report criteria as different fields.
Lets say trans_code1 relates to report_code1, etc.
You have to include this table in your query. But with that you should be
able to get out of your report anything you want.
RelatedCode Report1 Report2 Report3
code1 1 2 3
code2 1 1 1
code3 1 2 4
In the query, if you want to show all code in report1, just do:
iif([report1]=1,[report1],"")
In your report you can filter by: report1=1

I have a report that pulls info from a query. The query gets acct_num

(count), total_charges (sum), acct_bal (sum), trans_code (group by),
trans_date (group by), and expr1: Month(trans_date) (expression). The expr1
prompts the user to enter the number of the month.

In the report I am trying to get the count only certain trans_codes. This

is a summary report and for two fields of the summary I need to count 5
different trans_codes in each field. Example: In Total No Precert I want to
count the number of accounts for the month entered that have specific
trans_codes. There are 5 different trans_codes that relate to No Precert.
I need the corresponding dollar amount for each of the two fields.

I can do this by creating a query for each field and then do a subreport

in my main report but it asks for the Number of the Month for each
subreport. There are 3 subreports that I have.