G Guest Mar 29, 2007 #1 I have a "branch header", there is blank data with in. How do I keep these from showing up on report so that only those with data show.
I have a "branch header", there is blank data with in. How do I keep these from showing up on report so that only those with data show.
J Jeff Boyce Mar 29, 2007 #2 Start with a query that returns the rows you want to see in your report. You can use the query to exclude those with blanks for [branch header]. By the way, a 'blank' could be a null, or could be a zero-length string... Regards Jeff Boyce Microsoft Office/Access MVP
Start with a query that returns the rows you want to see in your report. You can use the query to exclude those with blanks for [branch header]. By the way, a 'blank' could be a null, or could be a zero-length string... Regards Jeff Boyce Microsoft Office/Access MVP