Saving the value returned from an expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
You didn't describe the structure of the data underlying your query -- "how
to" depends on your data. Given the construction you are describing, I'm
wondering if the data doesn't lay out more like a spreadsheet than a
relational database.
 
Back
Top