Distinct calculations on a form to be shown in a report

[Guest]

I hope you can help with the following report problem with my Access
database. The database is called Rqmts Data Analysis. I have created a
report, Requirements Statistics Report, that includes calculated values from
a form (Requirements Analysis). In order for the report to include the
calculated values from the form, the form has to be open when I run the
report. This is normal in Access 2003.

Currently, I have 2 records (Idea 1000 and Idea 2000) in the database with
very distinct values in the calculated fields on the form. The problem is
that although each record's data (in the calculated fields) is unique in the
form, the report pulls the same data for each record in the calculated fields
only.

The data that is duplicated on the report depends upon which record I am
"sitting" on in the form when the report is run. If I am "sitting" on the
record for idea 1000, the report uses that record's data for both ideas. If
I am "sitting" on the record for idea 2000, the report uses that record's
data for both ideas. If I am 'sitting" on a blank record, the report doesn't
display any values.

How do I get the report to show the calculated values that are specific to
each record?

 

[strive4peace]

you will need to put the calculations in your report as well

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Crystal,

Thanks for your response! I followed your instructions, but I am still
getting the same results as before. Any other ideas to resolve my problem?

Sincerely,

Corey

 

[strive4peace]

Hi Corey,

can you post your code/calculations, describe what your tables contain
(as far as the calculations go) and how the tables are related and how
they are being used in the RecordSources of your report and
subreport(s)? Please also explain exactly what you are hoping to
achieve. Thanks

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Crystal,

I was able to resolve my problem with assistance from a fellow employee.
Thank you so much for your willingness to help me! Have a great day!

Corey