 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / February 2006Data loss when re sorting
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? John, I cant help you, but is this the John Marsh from HTGuide etc? -Paul John, I cant help you, but is this the John Marsh from HTGuide etc? -Paul John, I cant help you, but is this the John Marsh from HTGuide etc? -Paul Can you tell us what you mean by "lost the first data item in the report"?  SignatureDuane Hookom MS Access MVP -- > 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? SignatureDuane Hookom MS Access MVP -- > 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. 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). SignatureDuane Hookom MS Access MVP -- >I aplolgise for the lack of clarity. Thank you for your continued > interest. [quoted text clipped - 7 lines] > > John Marsh. 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? SignatureDuane Hookom MS Access MVP -- > OK. Here's some more detail. > [quoted text clipped - 13 lines] > > John Marsh. 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.