Skipping a line by condition

  • Thread starter Afrosheen via AccessMonster.com
  • Start date
G

Gina Whipp

Leave everything the same except change

Keep Together = No

Whether it does it Across first or Down first should ot matter...

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

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 said:
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 said:
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]
 
A

Afrosheen via AccessMonster.com

Sorry Gina, that also didn't work. I guess it's like the phrase on your web
page. The impossible takes a little longer.

When I do the down, then across I a decent display/print preview. May just
have to live with that. Although that's not the way I wanted it.


Gina said:
Leave everything the same except change

Keep Together = No

Whether it does it Across first or Down first should ot matter...

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

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 said:
Let's go over report...
[quoted text clipped - 29 lines]
 
G

Gina Whipp

Afrosheen,

What you're doing should not be impossible as I do it all the time. I am
going to be out of town this week so hopefully someone will pick up this
thread and find what I am missing. Might help if you start a new thread and
see if you get any hits!

--
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, that also didn't work. I guess it's like the phrase on your web
page. The impossible takes a little longer.

When I do the down, then across I a decent display/print preview. May just
have to live with that. Although that's not the way I wanted it.


Gina said:
Leave everything the same except change

Keep Together = No

Whether it does it Across first or Down first should ot matter...

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

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 said:
Let's go over report...
[quoted text clipped - 29 lines]
 
A

Afrosheen via AccessMonster.com

Thanks for the help Gina. Have a safe trip.

Maybe I'll try redesigning the form and see what happens.


Gina said:
Afrosheen,

What you're doing should not be impossible as I do it all the time. I am
going to be out of town this week so hopefully someone will pick up this
thread and find what I am missing. Might help if you start a new thread and
see if you get any hits!

Sorry Gina, that also didn't work. I guess it's like the phrase on your web
page. The impossible takes a little longer.

When I do the down, then across I a decent display/print preview. May just
have to live with that. Although that's not the way I wanted it.

Gina said:
Leave everything the same except change
[quoted text clipped - 36 lines]
 
G

Gina Whipp

What have you decided? New form?

--
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 the help Gina. Have a safe trip.

Maybe I'll try redesigning the form and see what happens.


Gina said:
Afrosheen,

What you're doing should not be impossible as I do it all the time. I am
going to be out of town this week so hopefully someone will pick up this
thread and find what I am missing. Might help if you start a new thread
and
see if you get any hits!

Sorry Gina, that also didn't work. I guess it's like the phrase on your web
page. The impossible takes a little longer.

When I do the down, then across I a decent display/print preview. May just
have to live with that. Although that's not the way I wanted it.

Gina said:
Leave everything the same except change
[quoted text clipped - 36 lines]
 
A

Afrosheen via AccessMonster.com

I hope you had a nice trip.

I gave up. I ended up putting the categories in two columns printing down and
up. It looks good enough.

Thanks again for trying to help me out I really appreciate it.




Gina said:
What have you decided? New form?

Thanks for the help Gina. Have a safe trip.

Maybe I'll try redesigning the form and see what happens.

Gina said:
Afrosheen,
[quoted text clipped - 15 lines]
 
G

Gina Whipp

Afrosheen,

Yes I did thanks... Glad you got it working but sorry couldn't figure out
why it wouldn't work the other way.

You're welcome!
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 hope you had a nice trip.

I gave up. I ended up putting the categories in two columns printing down
and
up. It looks good enough.

Thanks again for trying to help me out I really appreciate it.




Gina said:
What have you decided? New form?

Thanks for the help Gina. Have a safe trip.

Maybe I'll try redesigning the form and see what happens.

Gina said:
Afrosheen,
[quoted text clipped - 15 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top