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.
Create a new query
Add the table
Drag each field (not the '*') into the query grid
In the 'Neighbourhood#' column there is a row called 'Condition'
In this box type: [Enter Neighbourhood#]
Save the query
When you run it, you will be prompted for a Neighbourhood#
Type it in and bingo!
If you want it to be more sophisticated, and to select from a drop down list, let me know.
I wish I could. Unfortunately the houses I buy are run down and usually full of roach's and flees. Of course we clean them up and bring them back to better than then other houses on the neighborhood, but no 5 bdrms / pools in my inventory.