Skip to main content
A
Anonymous
August 8, 2011
Question

Hide a row

  • August 8, 2011
  • 2 replies
  • 904 views

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.

This topic has been closed for replies.

2 replies

B
bregent
Participating Frequently
August 14, 2011

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.

A
Anonymous
August 15, 2011

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

B
Community Expert
Ben MCommunity Expert
Community Expert
August 8, 2011

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?

A
Anonymous
August 8, 2011

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
Lon_Winters
Inspiring
August 8, 2011

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices