Skipping a line by condition
in [Reports]
|
From: Afrosheen via AccessMonster.com on 10 Feb 2010 09:14 Thanks for reading this. I have a report that is grouped by [positiontitle] in a two column report. It prints out ok. The thing is what I want it to do is when a new [positiontitle] comes up I want it to skip a line in the report. For example: Worker George Fred Non Worker Bill Tom The way it comes up now is: Worker George Tom Non Worker Bill Tom The [positiontitle] is located in the header of the report. Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1
From: Gina Whipp on 10 Feb 2010 10:26 Afrosheen, I believe what you are looking for is a group footer. Add a group footer for [positiontitle] to your report and set it to the spacing you want between the titles. -- 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:a36d57e17e105(a)uwe... Thanks for reading this. I have a report that is grouped by [positiontitle] in a two column report. It prints out ok. The thing is what I want it to do is when a new [positiontitle] comes up I want it to skip a line in the report. For example: Worker George Fred Non Worker Bill Tom The way it comes up now is: Worker George Tom Non Worker Bill Tom The [positiontitle] is located in the header of the report. 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 10 Feb 2010 18:45 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, > >I believe what you are looking for is a group footer. Add a group footer >for [positiontitle] to your report and set it to the spacing you want >between the titles. > >Thanks for reading this. > >I have a report that is grouped by [positiontitle] in a two column report. >It >prints out ok. The thing is what I want it to do is when a new >[positiontitle] >comes up I want it to skip a line in the report. For example: > >Worker >George Fred > >Non Worker >Bill Tom > >The way it comes up now is: > >Worker George >Tom >Non Worker Bill >Tom > >The [positiontitle] is located in the header of the report. > >Thanks for your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1
From: Gina Whipp on 10 Feb 2010 19:08 Afrosheen, Where is the [positiontitle]? Is it in a Group Header and the names in the Detail 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:a37254af4513b(a)uwe... 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, > >I believe what you are looking for is a group footer. Add a group footer >for [positiontitle] to your report and set it to the spacing you want >between the titles. > >Thanks for reading this. > >I have a report that is grouped by [positiontitle] in a two column report. >It >prints out ok. The thing is what I want it to do is when a new >[positiontitle] >comes up I want it to skip a line in the report. For example: > >Worker >George Fred > >Non Worker >Bill Tom > >The way it comes up now is: > >Worker George >Tom >Non Worker Bill >Tom > >The [positiontitle] is located in the header of the report. > >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 10 Feb 2010 19:51 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
|
Next
|
Last
Pages: 1 2 3 4 5 6 Prev: Form filter with multi-column combo box in report Next: Access 2007 Pivot Table Chart |