Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Group Total

Status
Not open for further replies.

kcn

Programmer
Jul 5, 2002
27
Hi,

I have a report based on a query with two tables in one-to-many relationship.

The table on the many side (Table B) contains criteria for report as well as the field I want to group on.

In the report, I want to group on the field in Table B, and then give totals for fields from both tables for the group.

I'm able to get accurate data for Table B, but not for Table A.

Any ideas?

Thanks

kcn (very new programmer!)
 
:-(

Responding to own query. Have realized the totaling worked after all! Sorry for confusion!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top