By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Is This Query Possible?

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.