Rows of fields to move up to next level

I have a report that has several rows and colunms as follows. I have it set
up if a check box is true to shown all the colunms in that row. What I need
now is, if row 2 is null (all blank) I want row 3 and row 4 to move up into
row 2's position so it will not show a blank where row 2 once was. How do I
do this?

.............Column 1.......Column 2.......Column 3..........colunm 4

1................XX...............XX.............. ...XX........................XX

2. ................I want row 3 an 4 to move up to this position.......

3.................XX...............XX............. ....XX........................XX

4.................XX...............XX............. ....XX........................XX

TKM,
The easiest method would be to exclude those records in your recordset
query behind the report.
Very basically....
Ex. Column1 Column(2) ' ... etc as needed
Is Not Null Is Not Null
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."
"TKM" wrote in message
...
I have a report that has several rows and colunms as follows. I have it set
up if a check box is true to shown all the colunms in that row. What I
need
now is, if row 2 is null (all blank) I want row 3 and row 4 to move up
into
row 2's position so it will not show a blank where row 2 once was. How do
I
do this?

............Column 1.......Column 2.......Column 3..........colunm 4

1................XX...............XX.............. ...XX........................XX

2. ................I want row 3 an 4 to move up to this position.......

3.................XX...............XX............. ....XX........................XX

4.................XX...............XX............. ....XX........................XX

Al,

I am prettynew at this..

Are you saying to put the Is Not Null behind each column in the querys
criteria? Such as for every field (which their are 15) to put the IS Not Null
under each of the fields in the query?

Thank you for your help!
"Al Campagna" wrote:

TKM,
The easiest method would be to exclude those records in your recordset
query behind the report.
Very basically....
Ex. Column1 Column(2) ' ... etc as needed
Is Not Null Is Not Null
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."
"TKM" wrote in message
...
I have a report that has several rows and colunms as follows. I have it set
up if a check box is true to shown all the colunms in that row. What I
need
now is, if row 2 is null (all blank) I want row 3 and row 4 to move up
into
row 2's position so it will not show a blank where row 2 once was. How do
I
do this?

............Column 1.......Column 2.......Column 3..........colunm 4

1................XX...............XX.............. ...XX........................XX

2. ................I want row 3 an 4 to move up to this position.......

3.................XX...............XX............. ....XX........................XX

4.................XX...............XX............. ....XX........................XX

TKM,
Yes... unless you can determine that there may be one column... that if
Null... would logically imply that all the other columns are null too.
It's hard to say what other methods... within the query itself... might
be used to "drop" those null records, without actually seeing the tables and
fields and relationships.
My solution is crude... but... given your example... it will prevent any
record with "all" null column values.
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

"TKM" wrote in message
...
Al,

I am prettynew at this..

Are you saying to put the Is Not Null behind each column in the querys
criteria? Such as for every field (which their are 15) to put the IS Not
Null
under each of the fields in the query?

Thank you for your help!
"Al Campagna" wrote:

TKM,
The easiest method would be to exclude those records in your recordset
query behind the report.
Very basically....
Ex. Column1 Column(2) ' ... etc as needed
Is Not Null Is Not Null
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."
"TKM" wrote in message
...
I have a report that has several rows and colunms as follows. I have it
set
up if a check box is true to shown all the colunms in that row. What I
need
now is, if row 2 is null (all blank) I want row 3 and row 4 to move up
into
row 2's position so it will not show a blank where row 2 once was. How
do
I
do this?

............Column 1.......Column 2.......Column 3..........colunm
4

1................XX...............XX.............. ...XX........................XX

2. ................I want row 3 an 4 to move up to this
position.......

3.................XX...............XX............. ....XX........................XX

4.................XX...............XX............. ....XX........................XX