Skipping a line by condition

[Afrosheen via AccessMonster.com]

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.

 

[Gina Whipp]

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

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.

 

[Afrosheen via AccessMonster.com]

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.

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.

 

[Gina Whipp]

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

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.

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.

 

[Afrosheen via AccessMonster.com]

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.

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.

Afrosheen,

[quoted text clipped - 26 lines]

Thanks for your help.

 

[Gina Whipp]

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

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.

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.

Afrosheen,

[quoted text clipped - 26 lines]

Thanks for your help.

 

[Afrosheen via AccessMonster.com]

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

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.

Afrosheen,

[quoted text clipped - 14 lines]

 

[Gina Whipp]

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

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

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.

Afrosheen,

[quoted text clipped - 14 lines]

 

[Afrosheen via AccessMonster.com]

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

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

Afrosheen,

[quoted text clipped - 30 lines]

 

[Gina Whipp]

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

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

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

Afrosheen,

[quoted text clipped - 30 lines]

 

[Afrosheen via AccessMonster.com]

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.

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

Afrosheen,

[quoted text clipped - 13 lines]

 

[Gina Whipp]

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

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.

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

Afrosheen,

[quoted text clipped - 13 lines]

 

[Afrosheen via AccessMonster.com]

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
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.

What or who comes before George?

[quoted text clipped - 14 lines]

 

[Afrosheen via AccessMonster.com]

By the way I have the repeat section set to yes and I still get the report
that looks like I've explained.
Sorry.

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]

 

[Gina Whipp]

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

By the way I have the repeat section set to yes and I still get the report
that looks like I've explained.
Sorry.

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]

 

[Afrosheen via AccessMonster.com]

I would like to, but my employer will not let me due to sensitive information.


I'll just have to keep playing with it I guess.

When I was using single column the report was correct with everything in
place. It's just when I do two column that it "messes" up.

Can you zip that database up and send it to me?

By the way I have the repeat section set to yes and I still get the report
that looks like I've explained.
Sorry.

The group header is the [positiontitle] = the Worker
Tom & George are the workers.

[quoted text clipped - 10 lines]

 

[Gina Whipp]

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
contain a name or are you trying to skip lines between each 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

I would like to, but my employer will not let me due to sensitive
information.


I'll just have to keep playing with it I guess.

When I was using single column the report was correct with everything in
place. It's just when I do two column that it "messes" up.

Can you zip that database up and send it to me?

By the way I have the repeat section set to yes and I still get the report
that looks like I've explained.
Sorry.

The group header is the [positiontitle] = the Worker
Tom & George are the workers.

[quoted text clipped - 10 lines]

 

[Afrosheen via AccessMonster.com]

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.

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
contain a name or are you trying to skip lines between each record?

I would like to, but my employer will not let me due to sensitive
information.

I'll just have to keep playing with it I guess.

When I was using single column the report was correct with everything in
place. It's just when I do two column that it "messes" up.

Can you zip that database up and send it to me?

[quoted text clipped - 7 lines]

 

[Gina Whipp]

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.
--
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

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.

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
contain a name or are you trying to skip lines between each record?

I would like to, but my employer will not let me due to sensitive
information.

I'll just have to keep playing with it I guess.

When I was using single column the report was correct with everything in
place. It's just when I do two column that it "messes" up.

Can you zip that database up and send it to me?

[quoted text clipped - 7 lines]

 

[Afrosheen via AccessMonster.com]

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.

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.

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]