Hiding records

[Guest]

Is there a simple way to "hide" records as you can do in the Works database
program?


I have "sibling" records and "inactive" records that are identified by
fields: Y and I respectively. I want to hide the records that have an Y or
and I so that I can print labels.

Any suggestions on how to "hide" those records while I print labels?

Thanks

 

[Guest]

By "hide" do you mean "omit"?

Further, I'm assuming you have query to select which records to print...is
this correct? Also, are Y and I fields or field values?

In either case, simply use a WHERE clause in the SQL statement to omit them.
Alternatively, you can use an IIf statement to omit them as well.

 

[Guest]

Create a query then do your report to print. Select only the records that
you want to see.

 

[Guest]

I've never doe a query...just looked at "help" for query...what kind of query
do you mean?

 

[Guest]

No, I don't mean omit. In works, you can hide records so that they are not
visible and, for example, will not print if you print the current database

y and I are the field values for sibling and inactive. I put a y is there
is a sibling and an I if the record is inactive. I want to print all the
records without a y or I. I don't understand how to use a query to do that,
if that is the proper solution.

 

[Guest]

Linda, are you using Microsoft Access for your database, or some other
software?

 

[Guest]

yes, I'm using access

Linda, are you using Microsoft Access for your database, or some other
software?

 

[Guest]

Linda--How are you currently printing your records?

 

[Joseph Meehan]

No, I don't mean omit. In works, you can hide records so that they
are not visible and, for example, will not print if you print the
current database

y and I are the field values for sibling and inactive. I put a y is
there is a sibling and an I if the record is inactive. I want to
print all the records without a y or I. I don't understand how to
use a query to do that, if that is the proper solution.

Assuming that you have a sibling field and a inactive field (two
different fields, which is what I would suggest) and assuming that each
record has y in the sibling field or is blank, and has a I in the inactive
filed or is blank, you could put both fields in the query and in the
criteria row use " Is Null" Then only records with nulls in both fields
would show.

A possible problem is a space or blank is not the same as null. In
addition a field with one letter like this is not a good design generally.
You can have null, I, i, c, z. yes, no etc. If you were to make it a
simple yes - no filed it would be better.

 

[Guest]

I'm sorry, I'm missing something. I've done the query (i believe). But
when I print the labels, all the records print even though only the
appropriate records are visible.

 

[Joseph Meehan]

I'm sorry, I'm missing something. I've done the query (i believe).
But when I print the labels, all the records print even though only
the appropriate records are visible.
"Joseph Meehan" wrote:

Make sure the report is based on the query not the table.