If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Skipping a line by condition
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/For...ports/201002/1 |
#2
|
|||
|
|||
Skipping a line by condition
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@uwe wrote in message news:a36d57e17e105@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/For...ports/201002/1 |
#3
|
|||
|
|||
Skipping a line by condition
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/For...ports/201002/1 |
#4
|
|||
|
|||
Skipping a line by condition
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@uwe wrote in message news:a37254af4513b@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/For...ports/201002/1 |
#5
|
|||
|
|||
Skipping a line by condition
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 |
#6
|
|||
|
|||
Skipping a line by condition
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@uwe wrote in message news:a372e82c8f183@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 |
#7
|
|||
|
|||
Skipping a line by condition
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 |
#8
|
|||
|
|||
Skipping a line by condition
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@uwe wrote in message news:a3787e5e97f03@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 |
#9
|
|||
|
|||
Skipping a line by condition
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/For...ports/201002/1 |
#10
|
|||
|
|||
Skipping a line by condition
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@uwe wrote in message news:a3850e6903b3f@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/For...ports/201002/1 |
Thread Tools | |
Display Modes | |
|
|