Property Record Search

[Rob]

Hello,

I have recently purchased a spreadsheet from the county tax assessors office
that I will use to search for comparable property values for properties I am
looking to purchase. This spreadsheet has over 100k records in it. I have
created a table for this in access. Now I am wanting to create a way to
search for properties in a specific "Neighborhood #" that have been sold in
the past 24 months. I am not versed in Access, so I will need a step by step
approach.

Each record in my table contains a "Neighborhood #", "SALE_MM", "SALE_YY",
and "SALE_PRICE". I would like for my search results to contain all of the
fields for each record it finds.

Can anyone tell me how to do this?

Thanks,

Rob Caldwell

 

[[MVP] S.Clark]

There are a 1000 books that will teach you the art of querying data. Please
visit Amazon.com or your local bookstore.

Other than that, you may want to try using the Query Wizard to build your
first query, then work up from there.

Good luck,