Hide a row

[Guest]

MS Access -- DWCS3

Is there a SQL function to unconditionally hide a specific row (or more) from output view, possibly by it's primary key ID#?  I don't want to eliminate the row from the table, I only want to hide it from view when published.

[Ben M]

christinett wrote:

MS Access -- DWCS3

Is there a SQL function to unconditionally hide a specific row (or more) from output view, possibly by it's primary key ID#?  I don't want to eliminate the row from the table, I only want to hide it from view when published.

I'm no Access expert by any means, but I do have a good understanding of databases.  Is this the only row you can foresee this happening?  If not, it might be worthwhile to just create another field and give it a 0/1 true/false type of test and only publish when the criteria is met.  But if you don't foresee this happening, why would you want to keep one outlier in your database?

[Guest]

I was hoping to 'reuse' a table that outputs all records in one project, for another project that may require some records to be unviewable.

[Lon_Winters]

If you're using a repeat region, you could try an IF statement somewhere in the repeat loop code. Otherwise it really would be easier to filer the recordset itself so that it only produces the desired records. If you need the values from these hidden records to perform some sort of other function on the page, just create another recordset that contains all records.m

[bregent]

If you don't want the row to be viewable, then don't have it returned in the result set. Use the SQL where clause to eliminate that row by its ID.

[Guest]

That's exactly what I was hoping to do and I'm trying to figure out how.

[Guest]

Thanks for confirming it could be done that way..... I just figured it out using Not Equal To.  Thanks!