Saving value of an expression

[Guest]

I'm working in a report based of off 4 queries. Basically what I have to do
is count the number of entries in each query and create totals so my basic
design looks like this.

Type Number"
A =Dcount(..A..)
B =Dcount(..B..)
Total : =Dcount(A)+Dcount(B)

C =Dcount(C)
D =Dcount(D)
Total : =Dcount(c) +Dcount(D)
Grand Total: =Dcount(a)+....+ Dcount(D)

I've figured out how to create all these totals using the DCount function,
but right now in order to create the totals I have to recalculate each query
total 3 times which I have a feeling could get very expensive to do as more
and more records get added.

My question then is this... Is there a way to save each of the totals into a
dummy variable this way the expressing for the totals would just be "=dummyA
+ dummyB + dummyC + dummyD"?

Thanks, Keith

 

[Wayne Morgan]

Which report section(s) are these textboxes in? It may be easiest to just
have the following textboxes refer to the preceding ones.

Example:
Type Number
A =Dcount(..A..) displayed in textbox txtA
B =Dcount(..B..) displayed in textbox txtB
Total : =txtA+txtB

 

[Guest]

That is exactly what I wanted to do, I just didn't know how. It worked
perfectly... Thank you.

Keith