Need help with blanks...

P

Preston

I have a query that feeds a list and I need to put the
blanks at the bottom. Any help is greatly appreciated...

Preston
 
G

Greg Kraushaar

Do you want the blanks, or will just getting rid of them help

WHERE (((Items.Text) Is Not Null Or (Items.Text)<>""));

in your SQL feeding the list wil get rid of them for you
 
D

Duane Hookom

This is a reports News Group. Does your question have anything to do with
reports? By list, do you mean report? What do you mean by "blanks at the
bottom". Please take the time to be a little more descriptive.
 

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

Similar Threads

Mail Merge Switch - Dollars to Words 0
Blank Page After Envelope-Label Wizard 5
Publisher adding blank page when printing my booklet... 2
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Section and Page numbering 0
365 office launcher error 6
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
create a blank report 3

Top