MS Access question

[dancerjodi]

I'm creating a report to show why a discharge from the hospital was delayed, and there are 15 or so potential reasons it could have happened. Does anyone know a way (either through a query or report) I can just exclude a variable altogether from the results if its null? Poking around a bit last week I couldn't find anything. I could easily just manually delete columns I don't need after the fact, but I'm trying to come up with something that's a bit less manual. I'm not sure if there's some kind of VB thing I can do in my query that I'm unaware of.

Thanks in advance! :)

Comments

Re: ColumnHidden Property

[sajuka.livejournal.com]

THANK YOU! You huge geek! :) (I mean that in the nicest way possible).

And I'll take it in the nicest way possible :) You're very welcome.