Hiding certain rows in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all.

I have a database which has a lot of information which i dont want to see.
For example:

Expr1: Format(([TIME]>=60)*-1)

This will then put a "1" in all the fields where the time was greater than
60minutes. and the rest will be 0. For all those values where its 0, i dont
want to see the entire row. Is there a way to do this? (hide or delete makes
no difference)
ps i used the *-1 as it returned -1 and 0 before dunno why :(

I have a similar thing with another field. This field which just contains
one alphabetical letter. I only want to see the fields which have a "C" in.
So at the end of the day i want to see the rows where time is greater than 60
and the code letter is "C".

Any help is much appreciated!

Ernest
 
Use criteria in your fields. Put 1 in Expr1's criteria, and "C" in the
other field.

Hope that helps!
 
You build a query to do this. In the query you select which fields you want
to see and then use criteria to determine which rows of the data you want to
see.

The criteria for what you want seems simple. It should look like

Field: [Time]
Criteria: < 60

Field: OtherField
Criteria: "C"
 
Back
Top