A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data showing incorrectly in report



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old August 13th, 2009, 08:39 PM posted to microsoft.public.access.reports
Tim
external usenet poster
 
Posts: 780
Default Data showing incorrectly in report

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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.