Microsoft access filtering tables?

im not very familar using microsoft access and i was wondering if someone could give me the steps on how to do filtering. for example i have a table with a range of postcodes and i need to know how many post codes come before 4333 any ideas? or how many locations have a postcode between 4000 and 4500.

Microsoft access filtering tables?free antivirus

Not sure what Henry is talking about.

Whether you want to simply view filtered records, or, create a filtered set of records for a form, you should create a query.

Create a new query. In the Show Table dialog box, select each the table in question, click Add, and then click Close.

Next, from the table now shown in the query design, drag down any fields you want to the grid (the columns at the bottom), including postcode.

If you want to sort on any field, make the appropriate selection in the Sort drop-down.

In the Criteria row under the postocde field, you can type, without the quotes, ''%26lt;4333'' or ''%26gt;=4000 and %26lt;=4500'' or any other criteria you like. This will limit the query results to those records that meet the criteria you specify.

One more thing. If you just want a count of those records with a postcode that is less than 4333, create a new query and show the table. Click the summation button (the Greek Sigma) on the toolbar. Now the query grid includes a total row. You can choose Count, Group By, Min, Max, Where and other summary fields. Drag down any field that is unique to each record (like the ID field), and select Count in the Total row. Drag down down postcode, select Where in the Total row, add the %26lt;4333 criteria to the postcode column, and uncheck the checkbox in the postcode column, which means don't show the postcode in the results.