I have a simple monthly accounting report which is based on a query,
which in turn is based on a parameter query. In the report footer I am
trying to use the DSun function to sum up the values in one field, but
I keep getting an error. I did a little reading and found that you
cannot use the DSun fnction in a report based on a parameter query. I
know however that at some of you gurus out there have found a way
around this obsticle. Please be so kind as to share the benefits of
your knowledge and exerience with this lowly novice.

Charles,

The function is DSum not DSun (which as I recall was the name of a
song). Are you sure the error you got is not the result of misspelling?

I have never based a report on a parameter query, so I am not aware of
other problems. I would recommend you do the same.

In any case, do you mean to get the sum of a field that is included in
the report? In this case, I think an unbound textbox in the Footer
section, with its Control Source set to =Sum([NameOfYourField]) should
do it, unless I have misunderstood.

--
Steve Schapel, Microsoft Access MVP


(E-Mail Removed) wrote:
> I have a simple monthly accounting report which is based on a query,
> which in turn is based on a parameter query. In the report footer I am
> trying to use the DSun function to sum up the values in one field, but
> I keep getting an error. I did a little reading and found that you
> cannot use the DSun fnction in a report based on a parameter query. I
> know however that at some of you gurus out there have found a way
> around this obsticle. Please be so kind as to share the benefits of
> your knowledge and exerience with this lowly novice.
>