Rows in table...is there a way to hide them

LeahT wrote:
Thank you everyone!! I see now that I need to really get a better handle on
Access and its capabilities. I have purchased a few (7) books on how to use
Access...and I plan on really getting a better understanding. You al have
started me in the right direction though...VERY VERY much appreciated.

"LeahT" wrote:

Hmmm...this is where my novice REALLY shows. No...we work directly in the
tables...no forms to speak on in this one. OH if only I knew how to use
Access!

I like the idea that Clifford suggested, but clearly that won't work cuz we
don't use forms...so until I can figure out how to use the forms...is there a
simple way to just hide the rows in the table?

"Jeff Boyce" wrote:

Leah

An alternate approach to what Clifford offers is to use a query to only see
the non-Destroyed rows. Then use that query to feed your form. You ARE
using forms to display the data, and not working directly in the table,
right?!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"LeahT" wrote in message
...
I am really a seriously novice Access user. My company uses Access to keep
track of files and what box they are in and on what rack in what bldg
(stored
at). So, the problem is...we frequently destroy boxes. In the Box Table
there
is an option in the "Stored At" column for "Destroyed" to show that we
have
gotten rid of that box. Unfortunately, now our (very large) box table is
riddled with destroyed boxes. We don't want to delete the record (in case
we
need to know what happened to a file)...but I would like to hide them
somehow
if that is possible. Any thoughts?



Another good source is Microsoft. They have a number of tutorials that
could be quite helpful to a "newbie". But they will all be for Access
2007. If you google for Access 2003 tutorial or Access 2007 tutorial
depending on your version you should get some helpful sites.
Most will step you through the basic steps of creating tables, queries,
and forms.

Here's a link to Microsoft's site
http://office.microsoft.com/en-us/tr...744471033.aspx


gls858