Skipping a line by condition
in [Reports]
|
From: Gina Whipp on 14 Feb 2010 18:55 Leave everything the same except change Keep Together = No Whether it does it Across first or Down first should ot matter... No problem... 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:a3a45dfd7aa04(a)uwe... 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
From: Afrosheen via AccessMonster.com on 15 Feb 2010 06:26 Sorry Gina, that also didn't work. I guess it's like the phrase on your web page. The impossible takes a little longer. When I do the down, then across I a decent display/print preview. May just have to live with that. Although that's not the way I wanted it. Gina Whipp wrote: >Leave everything the same except change > >Keep Together = No > >Whether it does it Across first or Down first should ot matter... > >No problem... >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 > >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... >> >[quoted text clipped - 29 lines] >>>>>>>>>>> >>>>>>>>>>>Thanks for your help. -- Message posted via http://www.accessmonster.com
From: Gina Whipp on 15 Feb 2010 08:34 Afrosheen, What you're doing should not be impossible as I do it all the time. I am going to be out of town this week so hopefully someone will pick up this thread and find what I am missing. Might help if you start a new thread and see if you get any hits! -- 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:a3aabf1babdd5(a)uwe... Sorry Gina, that also didn't work. I guess it's like the phrase on your web page. The impossible takes a little longer. When I do the down, then across I a decent display/print preview. May just have to live with that. Although that's not the way I wanted it. Gina Whipp wrote: >Leave everything the same except change > >Keep Together = No > >Whether it does it Across first or Down first should ot matter... > >No problem... >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 > >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... >> >[quoted text clipped - 29 lines] >>>>>>>>>>> >>>>>>>>>>>Thanks for your help. -- Message posted via http://www.accessmonster.com
From: Afrosheen via AccessMonster.com on 15 Feb 2010 09:47 Thanks for the help Gina. Have a safe trip. Maybe I'll try redesigning the form and see what happens. Gina Whipp wrote: >Afrosheen, > >What you're doing should not be impossible as I do it all the time. I am >going to be out of town this week so hopefully someone will pick up this >thread and find what I am missing. Might help if you start a new thread and >see if you get any hits! > >Sorry Gina, that also didn't work. I guess it's like the phrase on your web >page. The impossible takes a little longer. > >When I do the down, then across I a decent display/print preview. May just >have to live with that. Although that's not the way I wanted it. > >Gina Whipp wrote: >>Leave everything the same except change >> >[quoted text clipped - 36 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 22 Feb 2010 00:14
What have you decided? New form? -- 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:a3ac7ff3d3870(a)uwe... Thanks for the help Gina. Have a safe trip. Maybe I'll try redesigning the form and see what happens. Gina Whipp wrote: >Afrosheen, > >What you're doing should not be impossible as I do it all the time. I am >going to be out of town this week so hopefully someone will pick up this >thread and find what I am missing. Might help if you start a new thread >and >see if you get any hits! > >Sorry Gina, that also didn't work. I guess it's like the phrase on your web >page. The impossible takes a little longer. > >When I do the down, then across I a decent display/print preview. May just >have to live with that. Although that's not the way I wanted it. > >Gina Whipp wrote: >>Leave everything the same except change >> >[quoted text clipped - 36 lines] >>>>>>>>>>>> >>>>>>>>>>>>Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1 |