2 records, 1 report

T

Thomas Tutko

I have a database that contains data for 2 experiments, a base case and a
modified case. Each case has multiple runs giving about 5 different
numerical results. I currently have a query setup that groups by the case
and averages all the runs for that case. What I am left with is a dataset
containing 2 records, one for the base case's 5 averages and one for the
modified cases 5 averages. How can I display data from both of these rows on
1 report? Currently it only allows for the data from one row on the first
report and then the data from the second row on the second report. I don't
think this is too complex but I have never worked with reports before.

- Tom
 
G

Guest

hi,
confused. you say you have 1 dataset with 2 records.
seems you should be able to use the dataset as the
reports record source.
if you are using 2 queries, then you need to dump the
results in a temp table then use the temp table as the
reports record source.
 
T

Thomas Tutko

The dataset is being used as the reports record source. However, as
mentioned there are 2 rows in the dataset, how do I access both values of a
column in the report? The report is custom made not one of the wizard
created ones. Currently, I dragged the fields from the field list in the
report design to the report but it only shows data from one row until I
advance to the next report. I need to show data from both rows on the same
page.
 
T

Thomas Tutko

Perhaps some further clarification:
I have a powerpoint presentation that displays everything that I want this
report to display. This powerpoint primary slide is used for several tests
that are always comparing two things. Currently, everyone takes the numbers
from an excel spreadsheet and manually types them into the fields on the
power point slide which is a long tedious process. I am trying to streamline
things for them and to keep all the data in a database.

The format for the one page report they came up with and designed in
powerpoint is great and would take a long time to reproduce in access pieces
by piece so I higlighted all the controls of the powerpoint slide and copy
this as an image into the report in Access. This gave me the background
template for me to drag and drop what I need on top of it for display. There
are two tables so far in the database. One of them holds the general data for
each experiment such as what was compared, date the experiment was conducted,
analysis of results, etc. The second table holds all the data from the
multiple times the experiment was conducted and the averages are used in the
final report. Since there is a base case expirment and a modified base case
experiment, each with 5 different averages, that leaves me with 10 numbers
needing to be displayed on the report (There are more but this is the primary
problem).

As the report stands now, it is based on a query that provides me with 2
rows. One for the base case and it's 5 averages, the other for the modified
base case and it's 5 averages. Each row also has the text fields shared by
both cases from the other table. When I print preview the report, all the
text fields from table1 are showing up how I need them to in the proper
locations. In the middle of the report is where the average values are to be
displayed, first the base case average values, and then the modified base
case average values directly underneath.

The problem is that both values, base case average1 and modified base case
average1 directly below it, are the same when I display the report. They are
first showing the base case average1 value and then when I advance the report
to the next page/record, both values change to the modified base case
average1 value. I need both of these to be on the same one page report, one
beneath the other. Hopefully that clarifies things. This is my first time
working with reports so I apologize if this is simple and I'm missing
something. If any further clarification is needed, please ask. Thank you!

- Tom
 
Top