This SHOULD be SIMPLE!?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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!

Allen Browne said:
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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Rick said:
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!
Click to expand...
Click to expand...
 
Back
Top