Use the DSum() built-in function in Access on your report calling the field
that contains the "totals." Launch the report off a QBF form that has
date-range boxes used to parameterize the underlying query. Your total now
should be a one-liner in your report. Add this one-liner to your other
totals on the report to produce the grand total. See the sample database I
e-mailed you previously. It has an example demonstrating exactly what I am
explaining above. The only difference is the "total" is not added to any
another total to give you a grand total. Open that sample database and
reverse engineer it and you see what I mean.
Denny G.
"Dalan" <ot***@safe-mail.net> wrote in message
news:50*************************@posting.google.co m...
I have a form that contains a lot of individual rows of text boxes
with dates and totals. Although one can view the form to see the
accumulative totals, what I would like to do without redoing the form
and creating multiple subforms is to be able to query any of the dates
(beginning/ending) and the resulting accumulative totals - like one
line per record.
The goal is to merge the one line piece of data with another form's
report to simply derive a grand total of both. Is there anyway to
construct a query that could dump the contents into another table or
query and then construct the data? Any suggestions will be
appreciated. Thanks.