Is there a way I can hide a dynamic-data region within a recordset if no information is in that field? I know that I can hide a region if the entire recordset is empty. I want to show the recordset data only if a specific region has data in the table field.

Thanks.

filter your RS with this.

SELECT your_tbl
FROM dbo.yourDB
WHERE your_tbl IS NOT NULL

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
filter your RS with this.

SELECT your_tbl
FROM dbo.yourDB
WHERE your_tbl IS NOT NULL

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>


Does the SQL statement above resemble the following rule:

Show Region IF Recordset Field is NOT Empty

yes

That SQL statement appears to be table specific and not field specific. Correct me if I'm getting something wrong.

I tried the following statement:

SELECT your_tbl
FROM dbo.yourDB
WHERE your_tbl IS NOT NULL

All records appeared as though there was no filter. I think all my records are not "null" but blank or empty. Is there an alternative statement I can use as apposed to "null"? Something like ""?

if your fields are not NULL then they are blank in that case use this,

SELECT *
FROM yourTable
WHERE yourColumn = ''

That statement seems to filter out all the records I want to keep and show the records that have empty/blank values in the specified field. Is there a way to reverse that statement to filter out the records that have blank values in specific fields?

Thanks asp

Edited by - jackbnimble on 02 Mar 2003 19:09:53

you wana hide null fields right? try the &lt;&gt; this will hide all fields with noting.

SELECT *
FROM yourTable
WHERE yourColumn &lt;&gt; ''

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
you wana hide null fields right? try the &lt;&gt; this will hide all fields with noting.

SELECT *
FROM yourTable
WHERE yourColumn &lt;&gt; ''

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Thanks asp, you're boss

That statement successfully my requirement; in other words, it did the trick.