Skipping a line by condition

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

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@uwe wrote in message
news:a3940d9e6cbcb@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

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/For...ports/201002/1

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

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@uwe wrote in message
news:a39af9bf04031@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

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.

Gina Whipp wrote:
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]

Thanks for your help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201002/1

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

"Afrosheen via AccessMonster.com" u46942@uwe wrote in message
news:a3a099d03af7c@uwe...
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.

Gina Whipp wrote:
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]

Thanks for your help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201002/1

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.



Gina Whipp wrote:
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.

Gina Whipp wrote:
Can you zip that database up and send it to me?

[quoted text clipped - 7 lines]

Thanks for your help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201002/1

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

"Afrosheen via AccessMonster.com" u46942@uwe wrote in message
news:a3a3a6de91c82@uwe...
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.



Gina Whipp wrote:
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.

Gina Whipp wrote:
Can you zip that database up and send it to me?

[quoted text clipped - 7 lines]

Thanks for your help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201002/1

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.


Gina Whipp wrote:
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.

Gina Whipp wrote:
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]

Thanks for your help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201002/1