 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / April 2008Wrong data!
I have a report that is linked to a query. The query is pulling the correct information. However, The report has part of the information from the query in the header (i.e. GP practice, patient name, DOB) and the rest in the detail. Each patient has one page in the report and can only have one GP but multiple information in the detail section. I'm finding that if the GP code (in the header section) is the same for page 1 and page 2 (i.e. 2 different patients with the same GP) the detail changes but the patient name and DOB doesn't - it stays as the first patient. Any suggestions on how to cure this? I think it might be connected to the sorting and grouping. If I change it to sort by name or auto ID it works OK, but I need it to be in Practice order to make it easy to distribute. > I have a report that is linked to a query. The query is pulling the correct > information. However, The report has part of the information from the query [quoted text clipped - 6 lines] > > Any suggestions on how to cure this? You've almost solved it yourself, I suspect. Although you posts are a little short on detail, I suspect that you've got the general information in the Report Header section. It needs to be in a Group Header, at the level at which you are grouping. I'm not quite sure whether you're wanting/needing to do this at Practice level, or at Patient level. You should put Practice-level data into a Practice group header, and Patient-level data (other than details) into a Patient-level group header. I think (IIRC) that you can only nest groups to 8 levels, but you can check that in Help; it shouldn't be a practical problem for you here. HTH, Rob >I think it might be connected to the sorting and grouping. If I change it >to [quoted text clipped - 18 lines] >> >> Any suggestions on how to cure this? Brilliant! Thanks Rob, that was exactly what I needed. I had it all in a Practice header and just needed to split the patient details into a separate header. > You've almost solved it yourself, I suspect. > [quoted text clipped - 34 lines] > >> > >> Any suggestions on how to cure this? |
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.