Skipping a line by condition
in [Reports]
|
From: Afrosheen via AccessMonster.com on 14 Feb 2010 11:04 I would like to, but my employer will not let me due to sensitive information. I'll just have to keep playing with it I guess. When I was using single column the report was correct with everything in place. It's just when I do two column that it "messes" up. Gina Whipp wrote: >Can you zip that database up and send it to me? > >By the way I have the repeat section set to yes and I still get the report >that looks like I've explained. >Sorry. > >>The group header is the [positiontitle] = the Worker >>Tom & George are the workers. >[quoted text clipped - 10 lines] >>>>>>>> >>>>>>>>Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1
From: Gina Whipp on 14 Feb 2010 11:09 What I told you should work, so I am guessing something is preventing it from working. So let's see if we can figure it out... Does every record contain a name or are you trying to skip lines between each record? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Afrosheen via AccessMonster.com" <u46942(a)uwe> wrote in message news:a3a099d03af7c(a)uwe... I would like to, but my employer will not let me due to sensitive information. I'll just have to keep playing with it I guess. When I was using single column the report was correct with everything in place. It's just when I do two column that it "messes" up. Gina Whipp wrote: >Can you zip that database up and send it to me? > >By the way I have the repeat section set to yes and I still get the report >that looks like I've explained. >Sorry. > >>The group header is the [positiontitle] = the Worker >>Tom & George are the workers. >[quoted text clipped - 10 lines] >>>>>>>> >>>>>>>>Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1
From: Afrosheen via AccessMonster.com on 14 Feb 2010 16:54 Every record contains a name and a position title. I went through every records and made sure of that. Maybe this may have something to do with it I don't know. It starts out with a count of one and no record showing up. I put a counter in the footer to keep track of the number of position titles for a particular position. Gina Whipp wrote: >What I told you should work, so I am guessing something is preventing it >from working. So let's see if we can figure it out... Does every record >contain a name or are you trying to skip lines between each record? > >I would like to, but my employer will not let me due to sensitive >information. > >I'll just have to keep playing with it I guess. > >When I was using single column the report was correct with everything in >place. It's just when I do two column that it "messes" up. > >Gina Whipp wrote: >>Can you zip that database up and send it to me? >> >[quoted text clipped - 7 lines] >>>>>>>>> >>>>>>>>>Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1
From: Gina Whipp on 14 Feb 2010 17:05 Let's go over report... Pages Header ( if you have one.. PositionTitle Header Repeat Section = Yes Keep Together = Yes Detail Section Keep Together = yes Can Shrink = Yes Sortings And Groupings (for entire Report) Keep Together = No Group On = Each Value ....see if yours matches. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Afrosheen via AccessMonster.com" <u46942(a)uwe> wrote in message news:a3a3a6de91c82(a)uwe... Every record contains a name and a position title. I went through every records and made sure of that. Maybe this may have something to do with it I don't know. It starts out with a count of one and no record showing up. I put a counter in the footer to keep track of the number of position titles for a particular position. Gina Whipp wrote: >What I told you should work, so I am guessing something is preventing it >from working. So let's see if we can figure it out... Does every record >contain a name or are you trying to skip lines between each record? > >I would like to, but my employer will not let me due to sensitive >information. > >I'll just have to keep playing with it I guess. > >When I was using single column the report was correct with everything in >place. It's just when I do two column that it "messes" up. > >Gina Whipp wrote: >>Can you zip that database up and send it to me? >> >[quoted text clipped - 7 lines] >>>>>>>>> >>>>>>>>>Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1
From: Afrosheen via AccessMonster.com on 14 Feb 2010 18:15
Everything matches except the Sorting And Grouping. When I right clicked I selected the Sortings and Groupings. This is what I have. Group Header: Yes Group Footer: Yes Group on: Each Value Note: It only gave two options. The other was: Prefix Char. Group Interval: 1 Keep Together: With first detail. Note: The other options: No and with whole group. Note: in the page set up, I have it printing Across, Then Down. Should that be Down, Then Across? I wanted to thank you for your help and sticking with me to try and figure this out. It's probably something simple. I'm using Access 2003 sp3 by the way. Gina Whipp wrote: >Let's go over report... > >Pages Header ( if you have one.. > >PositionTitle Header >Repeat Section = Yes >Keep Together = Yes > >Detail Section > >Keep Together = yes >Can Shrink = Yes > >Sortings And Groupings (for entire Report) > >Keep Together = No >Group On = Each Value > >...see if yours matches. >Every record contains a name and a position title. I went through every >records and made sure of that. Maybe this may have something to do with it I >don't know. It starts out with a count of one and no record showing up. I >put >a counter in the footer to keep track of the number of position titles for a >particular position. > >Gina Whipp wrote: >>What I told you should work, so I am guessing something is preventing it >>from working. So let's see if we can figure it out... Does every record >[quoted text clipped - 13 lines] >>>>>>>>>> >>>>>>>>>>Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1 |