Null Fields

[Brook]

I have having a problem i would like to delte empty fills
from my report and I am not sure how to make the query not
show any empty field

 

[John Vinson]

I have having a problem i would like to delte empty fills
from my report and I am not sure how to make the query not
show any empty field

It's not clear how your report is laid out, but try setting the Report
Textbox's Can Grow and Can Shrink properties to True. The field will
vanish if there is nothing in it (provided it is not horizontally
lined up with a field which doesn't vanish).

 

[Duane Hookom]

I'm not sure how you would ever "show" an empty field. Empty generally means
there is nothing there to show.
You probably have some other meaning but perhaps you could explain what you
expect to happen in your report.