*** Reports - HORIZONTAL Totals ! *** [message #88681] |
Thu, 23 January 2003 10:18 |
a
Messages: 22 Registered: March 2002
|
Junior Member |
|
|
Hello fellow geeks !
im new to reports and have this question.
i have one query and a group with - TEvent, TCost fields in it.
another different query and a group with - BEvent, BCost fields in it
a third query with a group and a field Event in it that links to these two queries.
For every Event that likns TEvent and BEvent i print TCost and BCost. I can get the vertical total. But i want a horizontal total.
For every TCost, BCost row (which can be one or more) under Event i want TCost + BCost...
what ever i do i keep getting the invalid reference errors.
Give me some ideas !
|
|
|
Re: *** Reports - HORIZONTAL Totals ! *** [message #88682 is a reply to message #88681] |
Thu, 23 January 2003 22:23 |
Ravi
Messages: 251 Registered: June 1998
|
Senior Member |
|
|
Hi,
i think you can do this in Query itself (Horizontal total) because i am not getting what exactly you are doing, i think you need to have one more column in the Query for horizontal total.
Regards
|
|
|