Are you using the date field as part of the link master/child? If so, is this
field used to set relationships? Or, is the another unique field you could
use other than the date?
--
Duane Hookom
Microsoft Access MVP


"Tim" wrote:

Yes, there two bound text box in the section with the subreport. Both fields
pull information from the Survey table. Survey_Key (Primary key for the
table) and used as with subreport. The other field shows information about
the survey.

I deleted that one field from the report and it did not seem to change how
Triple Divide is showing in the report.

I also just deleted the subreport. Unfortunately, it did not change how
Triple Divide is being displayed.

Before deleting and after deleting, I have a site that is similar with
surveys occurring on different dates. In all instances, it is being spilt by
date they way I'm trying to get Triple Divide. I just wish I knew why it
shows one correctly and the other un-correctly.

Would having three different header sections that pull information from the
same table cause the problem? Top most section Site_Name, then Survey_Date,
then Survey_Key. I don't see why that would be the case, but I'm missing
something.

Thanks,
t

"Duane Hookom" wrote:

I assume the subreport display is the issue. Do you have text boxes in the
same report section as the subreport that are bound to the link master fields?
--
Duane Hookom
Microsoft Access MVP


"Tim" wrote:

Thanks Duane,

I'll hopefully explain the choices on the report more fully.

First with the names. No, I did not use Date and Name in the database. The
full names are Site_Name and Survey_Date (At times, I tend to be a lazy at
typing).

The Detail and Site_Name Footer sections were originally Shown on the report
but the users of the database decided that they were not helpful when viewing
the report (too much information). I am still getting the report formatted
to how the users would like the report to look. I just have not removed the
Site_Name Footer section yet (I don’t see how it would cause my problem, but
though I would include it in case it was causing some problem - a case of too
much information).

The purpose of the report is to look at differences between observers
conducting the same survey. They currently do not want to see the
nitty-gritty details - only the overall results of each observer involved in
a Paired Survey (two or more people involved in the same survey, each keeping
separate record of what goats they observed). The report is grouped by Site
Name then Survey Date, so that surveys that occurred together are grouped
together.

The Detail section has data on when a group of goats were observed during a
survey (a separate survey record for each person involved). The data in
Detail section is time a group was observed along with numbers of different
ages and sexes comprising of the group. This data is counted (number of
groups) and summed in the Survey Footer section.

Why would you not have the survey footer information in the survey subreport?

I’m not sure what you are asking. The subreport in the Survey_Header pulls
the names of the observers; the subreport only has a Detail section with the
Observer Name and Survey_Key. The Observer table is in a Many-to-Many
relationship with the Survey table (Observers (1:M) xref_Survey_Observers
(M:1) Survey). The Survey_Key field is present in both the subreport and
main report’s Survey Header (not visible - autonumber field), and is used as
the Parent-Child field between the main report and subreport.

With Site_Name sorted ascending, the Triple Divide site is listed last in
the report. Two sets of paired surveys occurred. One set of surveys
occurred on 8/5; two people involved; two survey records (Survey_Keys 209 and
210). Another survey set occurred on 9/24; two people involved; two survey
records (Survey_Keys 207 and 208). For Triple Divide, I get all four surveys
back in the report, but they are all listed as having occurred on 9/24. The
control source query shows the correct dates for the respective surveys. I
am unable to figure out why the report is listed these under the same date.

Does this answer your questions,
Thanks for your input,
Tim

"Duane Hookom" wrote:

Maybe if you explained why you needed invisible text boxes in sections. These
shouldn't be necessary to the values displayed in the group sections.

Why would you not have the survey footer information in the survey subreport?

If you main report has the details of the surveys, why do you need a
subreport?

Do you really have fields named "Name" and "Date". These are reserved words
and can cause serious issues in your application.

--
Duane Hookom
Microsoft Access MVP


"Tim" wrote:

I am having trouble with a report giving back incorrect data.

The database was created in Access 2003 (*.mdb). I am using Access 2007 –
report was created in Access 2007.

The report is looking at surveys that occurred at the same place and time
(comparing differences among observers). There are two sites where a set of
surveys occurred on two different days. Only one site shows up properly in
the report with the different dates the surveys occurred. The other site has
the two survey sets under one date.

At Ole Creek a set of surveys was done on 7/10/2008 and 10/9/2008; both
dates show up in the report with corresponding surveys. Triple Divide
surveys were done on 8/5/2008 and 9/24/2008; both are listed on the report as
occurring on 9/24/2008. The control source query shows both dates for Triple
Divide.

The report layout is:
Site Header: Currently minimized – Site Name use to be here but moved so
that site name shows up at each different date a survey occurred.

Date Header: Text boxes for - Site Name and Survey Date. (The location of
Site Name between the different headers seemed to have to no effect on how
Triple Divide is shown).

Survey Header: Sub-report listing the Observers and Labels for data fields.

Detail: not visible – has the Text boxes.

Survey Footer: Text boxes that sums detail’s data fields.

Site Footer: not visible – text boxes that sums data for each site.

Group, Sort, and Total:
Group - Name
Group - Date
Group - Survey

Does anyone know why the report is doing this? Am I missing something in
the formatting or some other setting?

Thank you in advance,
Tim