same data in different records on a report

[Guest]

I have a form where I am entering and calculating approx. 10 fields of data.
At the end of this report, I want a running total based on data I've input,
which I have a calculated field (text box) and it works fine. I have a
report which I want to pull this total info from the different records. I
keep getting the same total for all records as one of the records from my
form. For example, in the report all records say $1.00, and in the form they
might have $1.00, $0.50, $0.75. What am I doing wrong??

 

[Larry Linson]

I have a form where I am entering
and calculating approx. 10 fields of data.
At the end of this report, I want a running
total based on data I've input, which I
have a calculated field (text box) and it
works fine. I have a report which I want
to pull this total info from the different
records. I keep getting the same total for
all records as one of the records from my
form. For example, in the report all records
say $1.00, and in the form they might have
$1.00, $0.50, $0.75. What am I doing wrong??

Calculated Controls on Forms are not stored in the underlying recordset. You
have to take specific action to save the values. So, my guess would be that
you are trying to use information that does not exist in the Report's Record
Source, or was not properly saved.

But, your discussion of the Form and the Report, without details on the
stored information, is insufficient for anyone to accurately diagnose the
problem.

Larry Linson
Microsoft Access MVP

 

[Guest]

are you having a bad day..geeezz. I did the best I could

VERY PROFESSIONAL!

 

[Larry Linson]

are you having a bad day..geeezz.
I did the best I could

No, LOLO, sometimes we just have to tell you when you didn't provide us
enough information to help. I thought I explained what additional
information (on the stored data) was needed for anyone to be able to assist.
Sorry if I was impolite -- that was not my intention.

If someone can help without additional clarification, I'd be happy for them
to do so, and will "stand corrected".

Larry Linson
Microsoft Access MVP