Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Billy
Billy asked in Computers & InternetProgramming & Design · 9 years ago

How can I hide any records that a condition is not met in Access 2003?

I am using Access 2003.

I am looking for a way to hide any records in a database that a specific condition is not met.

e.g. If [Age] = "25" then

Record.visible = true

Else

Record.visible = false

I don't know how to go about doing this and I will be grateful for any help.

1 Answer

Relevance
  • Cyrus
    Lv 4
    9 years ago
    Favorite Answer

    Create a query

    Add the table you want to filter

    Double-Click on the * to add all fields to your query

    Drag the field (e.g. age) you want to filter by, and in the "Criteria" box underneath it put

    Not 25

    or you could also put

    <> 25

    Now you can view the results of the query, and if you like you can also base a form or report on this query

    Source(s): http://acsdb.com/
Still have questions? Get your answers by asking now.