This SHOULD be SIMPLE!?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick - 15 Mar 2005 16:35 GMT

I have a very simple report, most of the work is just a matter of a query and
a flat report with some totals . . . .totals is where I am running into the
problem.

I have some fields in a table, that are of "Currency" format. I am
reporting them and THEN I want to sum them in the page footer, then the
report footer. My guess is that my problem with both is the same.

I have done this before, successfully, but can't seem to now!

One of the fields, is being reported in a text field in the details as
"txtFieldOne", The data source is a currenct field called "principle".

In the footer I have a txtbox "TxtSumPrinciple". It data source is simply
=Sum([principle])

I have tried =sum([txtsumprinciple]) as well as several other variations,
all produce "error".

I have even tried =Sum(cdbl([principle])) to MAKE SURE that the field is
seen as a number, still no luck.

In a query I have done calculations with these values, so they DO appear to
be behaving as if they are numbers. None are null or anything else that
might make things "weird". Seems it is the simple things that can drive you
the "Nuts-est"!

Thanks for any direction!

Reply to this Message

Allen Browne - 15 Mar 2005 16:50 GMT

Access will not give you the page total, but it should work okay for the
report total (i.e. in the Report Footer section).

To get a page total, you need to collect the values programmatically.
Details in this article:
Reports: Page Totals
at:
http://allenbrowne.com/ser-11.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a very simple report, most of the work is just a matter of a query
>and
[quoted text clipped - 28 lines]
>
> Thanks for any direction!

Reply to this Message

Rick - 15 Mar 2005 17:21 GMT

That seemed to solve it . . . At least as far as the report footer went.

I could SWEAR I have put totals in page footers before, guess I was wrong .
. .

Will try the programatic approach but at least I know i am not crazy.
Something that simple IS that simple, I just ASSUMED to much!

Thanks again for the help. Saved my sanity greatly!

> Access will not give you the page total, but it should work okay for the
> report total (i.e. in the Report Footer section).
[quoted text clipped - 37 lines]
> >
> > Thanks for any direction!

Reply to this Message