If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Rows of fields to move up to next level
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 |
#3
|
|||
|
|||
Rows of fields to move up to next level
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 |
#4
|
|||
|
|||
Rows of fields to move up to next level
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 |
Thread Tools | |
Display Modes | |
|
|