Data loss when re sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The database was created in Access 2000, running on W2K Pro. The grouped
report was sorted on 2 levels, the second of which turned out to be
incorrect. I then opened the file in Access 2002 running on WinXP Pro and
re-did the second level sort. I lost the first data item in the report.
Does anyone know why this happened?
 
No, I'm not the author. Just a student.

The first item in the report was the data which was lost. Sorry for
the confusion.
 
You didn't answer my question. What is an "item"? What makes you think it is
lost? What are your records and how are they displayed? What are your
sorting and grouping levels? What are your sections?
 
I aplolgise for the lack of clarity. Thank you for your continued
interest.

The item is the first result in the Report. All the data is on my own
PC (not this one); I'll get into the files & get back to you with more.

If you like, I could try sending the Access files to your email as
attachments. Would this work? - Access is not installed on this PC.
Alternatively, I could use screenshots.

John Marsh.
 
You only need to describe your issue better. I assume by "item" and "result"
you mean "record".

Attachments and personal emails are not generally acceptable. If we can't
resolve this issue in a few more exchanges, I would probably accept a file
but only after an agreement (not financial, just format).
 
OK. Here's some more detail.

The database was built to show information on Nobel Prize winners. The
relevant Query found UK and USA winners from 1991 to 2001. The Report
Wizard was set to group the results under category (e.g CHM for
chemistry, ECM for economics etc), then under year of award. This
process produced a Grouped Report which included a single winner from
1992. In this Report, the category and year of award results are in
ascending order; this happened automatically. All this work was done
on a PC running Access 2000 on W2k Pro.

Subsequently, I realised that I was required to sort the age at award
results into ascending order, in report design view. I did this on my
own PC, running Access 02 on WinXP Pro. After doing this sort, I
noticed that the entry for 1992 had disappeared from the report.

John Marsh.
 
Records don't generally "disappear" from a report without some assistance. I
would first look at the datasheet view of the report's record source. Find
the disappearing record and count all records.

Then add a text box to your Report Header or Footer Section with a control
source of
=Count(*)
Does this number correspond with the number of records in the datasheet
view?
Is there any Filter property set?
Are you displaying information in the detail section?
Is there any code that cancels printing of a record?
 
Solved it.

I put the counting text box in the Header; result = 72. This is the
same as the total number of Records in the Query used to generate the
Report.

(The total number of Records in the Datasheet is 218.)

The 'missing' Record is present in the Query; also in the Report; it's
just not where I expected it to be! But it IS where it should be.

As must be evident, I'm still new to Access. Thank you for your
interest and patience.

John Marsh.
 
Back
Top