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

ColumnHidden Property

[sajuka.livejournal.com]

After a little digging, I found this page:

http://msdn2.microsoft.com/en-us/library/aa194141(office.10).aspx

which says there is a "ColumnHidden" property which applies to Column objects, and is accessible via VB.

Doing a lot of digging in that MSDN library, I find hints that it is possible to setup VB to run a query, grab the results, check for empty columns, and then hide the empty columns. Unfortunately the reference has a lot of holes in it, so without having Access in front of me, I'm not sure I can give you very helpful code hints...

Re: ColumnHidden Property

[dancer.livejournal.com]

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

I'm heading to some meetings, but I'll give it a try this afternoon and I'll let you know what I find.

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.