Hello All:

I have ordered MS Access 2002 step by step but until it comes
hope you don't mind these questions.
I have a data base that i imported from excel.
I want to be able to do searches for example

2 bedroom apartments - costing $2000 -$3000 a month

--
http://www.diabetes.org
Sushi-Boy
Diabetics Do It
With Out The Sweets

It sounds like you need to learn how to create some simple queries? The
queries that you create are dependant on the structure of your current
database, which may not be normalized yet. In general, it is going to be
harder to ask questions of your data (ie. create queries) if the data is not
properly normalized. But, to get started for now, search Access Help for
Creating Queries. You can also go to the Contents tab in Help, and open up
the topic on Queries.

Assuming all of the rental rates are stored in one field (column), as they
should be, you will use a criteria to limit the recordset to the range that
you desire. For instance, lets say that you have a table named
tblApartments, which includes a field named RentalRate. You would first add
the tblApartments table to the query, and then add the RentalRate field to
the QBE (Query by Example) grid. In the criteria row for the RentalRate
field, you could enter either:

Between 2000 And 3000

(I'm making an assumption that the RentalRate is datatype number, rather
than text).

Tom
____________________________________

"Sushi-Boy" <mrgantlet (AT) acedsl (DOT) com> wrote

Hello All:

I have ordered MS Access 2002 step by step but until it comes
hope you don't mind these questions.
I have a data base that i imported from excel.
I want to be able to do searches for example

2 bedroom apartments - costing $2000 -$3000 a month

--
http://www.diabetes.org
Sushi-Boy
Diabetics Do It
With Out The Sweets