Skipping a line by condition
in [Reports]
|
From: Gina Whipp on 10 Feb 2010 20:06 Afrosheen, Add a Group Footer for the PositionTitle, space it about half an inch. Do not place anything in the Group Footer. What you should get is... Worker George Fred Tom Harry etc... Non Worker Bill Tom WAIT... do you have it set up for columns also? If yes then also set the Group Header for Repeat section = Yes. If all you intended was to have the names be lined up together forget the Group Footer part and just do the Repeat Section. -- 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:a372e82c8f183(a)uwe... The positiontitle field is in the sorting/ grouping section. Field: PositionTitle Group Header: yes Group Footer: no Group on: each value Group Interval: 1 Keep together: with first detail The names are in the detail. Gina Whipp wrote: >Afrosheen, > >Where is the [positiontitle]? Is it in a Group Header and the names in the >Detail section? > >Sorry Gina, it didn't work. The first column after the positiontitle still >prints on that line instead of putting a line feed or carriage return after >the positiontitle. > >I tried putting the positiontitle in the Detail section and all that did >was >put the positiontitle after the names. > >Gina Whipp wrote: >>Afrosheen, >> >[quoted text clipped - 26 lines] >> >>Thanks for your help. -- Message posted via http://www.accessmonster.com
From: Afrosheen via AccessMonster.com on 11 Feb 2010 06:30 Good morning Gina. I'm sorry I did not see any Group Header for Repeat section. Must be I'm not awake. Please advise. I tried adding the Group Footer and what I got is: Worker Tom George Fred Gina Whipp wrote: >Afrosheen, > >Add a Group Footer for the PositionTitle, space it about half an inch. Do >not place anything in the Group Footer. What you should get is... > >Worker >George Fred >Tom Harry >etc... > >Non Worker >Bill Tom > >WAIT... do you have it set up for columns also? If yes then also set the >Group Header for Repeat section = Yes. If all you intended was to have the >names be lined up together forget the Group Footer part and just do the >Repeat Section. > >The positiontitle field is in the sorting/ grouping section. > >Field: PositionTitle >Group Header: yes >Group Footer: no >Group on: each value >Group Interval: 1 >Keep together: with first detail > >The names are in the detail. > >Gina Whipp wrote: >>Afrosheen, >> >[quoted text clipped - 14 lines] >>> >>>Thanks for your help. -- Message posted via http://www.accessmonster.com
From: Gina Whipp on 11 Feb 2010 19:11 Afrosheen, Please reread the part about Repeat Section that is what you need! -- 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:a3787e5e97f03(a)uwe... Good morning Gina. I'm sorry I did not see any Group Header for Repeat section. Must be I'm not awake. Please advise. I tried adding the Group Footer and what I got is: Worker Tom George Fred Gina Whipp wrote: >Afrosheen, > >Add a Group Footer for the PositionTitle, space it about half an inch. Do >not place anything in the Group Footer. What you should get is... > >Worker >George Fred >Tom Harry >etc... > >Non Worker >Bill Tom > >WAIT... do you have it set up for columns also? If yes then also set the >Group Header for Repeat section = Yes. If all you intended was to have the >names be lined up together forget the Group Footer part and just do the >Repeat Section. > >The positiontitle field is in the sorting/ grouping section. > >Field: PositionTitle >Group Header: yes >Group Footer: no >Group on: each value >Group Interval: 1 >Keep together: with first detail > >The names are in the detail. > >Gina Whipp wrote: >>Afrosheen, >> >[quoted text clipped - 14 lines] >>> >>>Thanks for your help. -- Message posted via http://www.accessmonster.com
From: Afrosheen via AccessMonster.com on 12 Feb 2010 06:29 I did as you suggested. Now it shows up as Worker Tom George Fred {He's a non worker} Non Worker Thanks for your help Gina Whipp wrote: >Afrosheen, > >Please reread the part about Repeat Section that is what you need! > >Good morning Gina. I'm sorry I did not see any Group Header for Repeat >section. Must be I'm not awake. Please advise. > >I tried adding the Group Footer and what I got is: > >Worker Tom >George Fred > >Gina Whipp wrote: >>Afrosheen, >> >[quoted text clipped - 30 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 12 Feb 2010 22:36
What or who comes before George? -- 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:a3850e6903b3f(a)uwe... I did as you suggested. Now it shows up as Worker Tom George Fred {He's a non worker} Non Worker Thanks for your help Gina Whipp wrote: >Afrosheen, > >Please reread the part about Repeat Section that is what you need! > >Good morning Gina. I'm sorry I did not see any Group Header for Repeat >section. Must be I'm not awake. Please advise. > >I tried adding the Group Footer and what I got is: > >Worker Tom >George Fred > >Gina Whipp wrote: >>Afrosheen, >> >[quoted text clipped - 30 lines] >>>> >>>>Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1 |