same data in different records on a report

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

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??
 
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??
Click to expand...

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
 
are you having a bad day..geeezz.
I did the best I could
Click to expand...

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
 
Back
Top