Distinct calculations on a form to be shown in a report

C

coreydan

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?
 
S

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
*
 
C

coreydan

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
 
S

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
*
 
C

coreydan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Copy previous record into form field 0
Converting GPS coordinates to decimal in Report 0
How do I clear a form? 0
Report based on criteria form 5
Year to date expression/calculation 2
Subreport Keeps Repeating Itself 6
Using a Calculated Control in a Report 2

Top