summing values in a form using criteria

[tish]

I'm using a form to give a summary of the dollar values of different
transactions. I would like to show the totals of the various subtypes
of a certain transaction type, then show the grand total of each
transaction type. Example: All "Incoming" items have a transaction
code of "6", but its subtypes "Adjustment"and "Reinvest" have a "D/R"
code of 64 and 7, respectively. Am I able to have the form break out
each individual subtype with its total (Adj. = X, Reinvest = Y), then
show a grand total for "Incoming" items?

By the way, I am using a form for no particular reason, so if it's not
doable as a form, I can do a report. Sorry, I did a search for this
question but found it difficult to find exactly what I was looking
for.

Thanks!

 

[Klatuu]

Create a text box for each value you want to Sum then write a DSum function
with the criteria to return the value you want. That DSum should be in the
Control Source of the text box.