Pivot Grand total on Selected columns only

From: dim1ann@xxxxxxxxx
Date: 30 Nov 2005 10:35:54 -0800

Guys,
need a little help with row grand total :

my tbl :
columns as dates (about a week or two ) ,
each day has 4 data fileds (fieldA, FieldB, fieldC, FieldD)+ extra
field (field E)
which is sum of first 4 fields (fieldA+ FieldB+ fieldC+
FieldD).=FieldE.

i need to find a way of showing Grand total (rows) which sum up ONLY
FieldE. for each visible day without adding the first 4 fields.. does
not matter how: eigher through VBA or as some sort of calculate
GrandTotal..
thank u in advance
Dim

.

Prev by Date: RE: Need VB Code Help
Next by Date: Re: How to view the dimension of an open array in VBA ?
Previous by thread: Error Handling
Next by thread: RE: Data From Excel Range To Existing Access Table
Index(es):
- Date
- Thread

Relevant Pages

Re: Percentage at group level of Crystal Report.
... FieldC is a formula field, dividing FieldA by FieldB. ... > as to how to create a group level value for FieldC, ...
(microsoft.public.vb.crystal)
Re: Query:When 1 field in a table is not = to another field (same tab
... WHERE NOT(fieldA IN(fieldB, fieldC) OR fieldB IN) ... saved as, say, qu1, then ...
(microsoft.public.access.queries)
Forms & Calcs & Populating a table
... Does anyone know whether or not this is possible without writing code for it. ... Now back on the form, FieldC is set up, for the moment, to visually display the product of FieldA and FieldB through the Control Source in Properties being set to do a calculation. ...
(microsoft.public.access.forms)
Re: Percentage at group level of Crystal Report.
... >I have three fields on a Crystal report, FieldA, FieldB and FieldC. ... At a group level, I ...
(microsoft.public.vb.crystal)
Re: insert variables into Query
... Learning SQL and Access ... from tableX ... fieldA <= tableY.EndDate ... fieldB>= tableY.EndDate ...
(microsoft.public.access.queries)