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!)
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!)