Need help with blanks...

  • Thread starter Thread starter Preston
  • Start date Start date
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
 
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
 
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.
 
You must log in or register to reply here.

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

create a blank report 3
Excel Match two columns/rows within multiple sheets then paste answer... 0
Completely Blank Report...no title, data, etc. 3
Number formatting... 1
#error - Blank 3
Multiple SUM's in a column 15
Field Not Printing 6
Avoiding blank lines in report 2

Back
Top