Access Report ??

[Guest]

I have a query that show customers, checking account num, and available
balance. I have a not query that pulls customers and all accounts opened
opened. I need pull in these 2 result set onto on report. I need to show
customer name, number of checking accounts, and combined available balance.
In other column of the report I need to show the
percentage of count(checking account)/count(All types of account)

percentage of sum(checking acct bal )/sum(all type of acct bal)

Can anyone suggest how to do this without using subreports. I don't think
subreports would be useful because I don't need to show the details from
second query just use it to calculate a feild.

Thanks in advance for your help

 

[Guest]

As you don't want to use subforms - then you must establish all the key info
via a query...

With a query you can create calculated values using the data of a record i.e.

Field1 Field2 Field3 Calc1:[Field1]+[Field2]


With the Report Wizard you can sum columns in the report (also find Max/Min
and percent)