automatically omit certain records

[Nick T]

Hi,
Ill try & keep this as simple as poss.
I have a database which stores lots (thousands) of weight records. This
data is stored in a table (line 1). I also have a query which takes the data
from table 'line1'.
In my query, i want it to only display the records which have a value of
greater than 1.
eg, if a weight reading is 1.5 i want this to be displayed in my query, but
if it is 0.9 then i dont want this displayed in my query. However i dont want
any data to be deleted from my table.

Any suggestions greatly appreciated.

Nick

 

[Klatuu]

In Query Design, In the Criteria row for the field you want to filter on enter

 

[Tom van Stiphout]

On Thu, 23 Jul 2009 06:23:02 -0700, Nick T

Your query should be something like this:
select * from Line1
where myField > 1
(change myObjectNames to yours)

-Tom.
Microsoft Access MVP