Property Record Query

homevestors

New member
Local time
Today, 15:04
Joined
Oct 8, 2004
Messages
6
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 code" that have been sold in the past 24 months. Each record in my table contains a "neighborhood code", "Sale Month", "Sale Year", "Sale Price", as well as many other fields relative to the property. 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
 
Select *
From YourTable
Where DateDiff("m", [Sale Year] & "/" & [Sale Month] & "/1", Date()) <= 24 AND [Neighborhood Code] = [Enter Neighborhood Code];

This query will prompt for you to enter the neighborhood code. Make to change the table and field names as necessary.

Rob,
I am looking for investment property and would be interested in incorporating something like that into the db I am developing. Right now the evaluations are all based on income and expense data. If you wouldn't mind sharing a few rows of data so I can see what's available, please PM me.
Pat
 

Users who are viewing this thread

Back
Top Bottom