Skipping a line by condition
in [Reports]
|
From: Afrosheen via AccessMonster.com on 13 Feb 2010 11:07 The word Tom. The lay out is: Worker {skips line} {spaces} Tom George {is next line} {spaces} {Fred} who is a NonWorker. NonWorker {Next Header} I'm sorry I can't send you an attachment. I'd let you look at it as it is printed. The way it should look is: Worker Tom George NonWorker Fred and so on. Gina Whipp wrote: >What or who comes before George? > >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, >> >[quoted text clipped - 13 lines] >>>>> >>>>>Thanks for your help. -- Message posted via http://www.accessmonster.com
From: Gina Whipp on 13 Feb 2010 17:53 This is a two column report correct? And PostitionTitle is a Group Header correct? If those two factors are correct then using the Repeat Section for the Group Header should keep the names underneath it. So what am I missing? Are George and Tom records, as in George has a record and Tom has a 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:a3940d9e6cbcb(a)uwe... The word Tom. The lay out is: Worker {skips line} {spaces} Tom George {is next line} {spaces} {Fred} who is a NonWorker. NonWorker {Next Header} I'm sorry I can't send you an attachment. I'd let you look at it as it is printed. The way it should look is: Worker Tom George NonWorker Fred and so on. Gina Whipp wrote: >What or who comes before George? > >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, >> >[quoted text clipped - 13 lines] >>>>> >>>>>Thanks for your help. -- Message posted via http://www.accessmonster.com
From: Afrosheen via AccessMonster.com on 14 Feb 2010 00:10 The group header is the [positiontitle] = the Worker Tom & George are the workers. Non Worker Fred is a non worker. Maybe I'm missing something? Gina Whipp wrote: >This is a two column report correct? And PostitionTitle is a Group Header >correct? If those two factors are correct then using the Repeat Section for >the Group Header should keep the names underneath it. So what am I missing? >Are George and Tom records, as in George has a record and Tom has a record? > >The word Tom. > >The lay out is: > >Worker {skips line} >{spaces} Tom >George {is next line} > >{spaces} {Fred} who is a NonWorker. >NonWorker {Next Header} > >I'm sorry I can't send you an attachment. I'd let you look at it as it is >printed. > >The way it should look is: >Worker >Tom George > >NonWorker >Fred > >and so on. > >Gina Whipp wrote: >>What or who comes before George? >> >[quoted text clipped - 14 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 00:20 By the way I have the repeat section set to yes and I still get the report that looks like I've explained. Sorry. Afrosheen wrote: >The group header is the [positiontitle] = the Worker >Tom & George are the workers. > >Non Worker >Fred is a non worker. > >Maybe I'm missing something? > >>This is a two column report correct? And PostitionTitle is a Group Header >>correct? If those two factors are correct then using the Repeat Section for >[quoted text clipped - 30 lines] >>>>>>> >>>>>>>Thanks for your help. -- Message posted via http://www.accessmonster.com
From: Gina Whipp on 14 Feb 2010 09:45
Can you zip that database up and send it to me? -- 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:a39af9bf04031(a)uwe... By the way I have the repeat section set to yes and I still get the report that looks like I've explained. Sorry. Afrosheen wrote: >The group header is the [positiontitle] = the Worker >Tom & George are the workers. > >Non Worker >Fred is a non worker. > >Maybe I'm missing something? > >>This is a two column report correct? And PostitionTitle is a Group Header >>correct? If those two factors are correct then using the Repeat Section >>for >[quoted text clipped - 30 lines] >>>>>>> >>>>>>>Thanks for your help. -- Message posted via http://www.accessmonster.com |