Results 1 to 11 of 11

Thread: Property Search

  1. #1
    Join Date
    Oct 2004
    Posts
    7

    Unanswered: Property Search

    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

  2. #2
    Join Date
    Oct 2004
    Location
    Tunbridge Wells, Kent. UK
    Posts
    24
    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.

    Cheers, Matt

  3. #3
    Join Date
    Oct 2004
    Location
    Tunbridge Wells, Kent. UK
    Posts
    24
    Sorry, field is not called condition, but 'Criteria'

  4. #4
    Join Date
    Oct 2004
    Posts
    7

    Limit results by date

    Thanks Matt,

    That worked perfectly!

    Unfortunately this search gives me every record in that neighborhood #. How can I limit the search results to only sales made in the past 24 months?

    Each record in my table contains a "SALE_MM", and "SALE_YY". Can I use those to bring up only the last 24 months?

    Rob

  5. #5
    Join Date
    Oct 2004
    Location
    Tunbridge Wells, Kent. UK
    Posts
    24
    What is the format of the data in the SALES_MM field

    is it for e.g. October, 11, Oct, or ?????

    Matt

  6. #6
    Join Date
    Oct 2004
    Location
    Tunbridge Wells, Kent. UK
    Posts
    24
    Also, are you using 4-digit dates?

  7. #7
    Join Date
    Oct 2004
    Posts
    7
    I am attaching a sample spreadsheet in .txt formet with the first row identifying the field names and the second row with data.

    To answer your question, the years are in 4-digit and the months are 2-digit.

    Thanks
    Attached Files Attached Files
    Last edited by homevestors; 10-11-04 at 10:56. Reason: Trying to upload attachment

  8. #8
    Join Date
    Oct 2004
    Location
    Tunbridge Wells, Kent. UK
    Posts
    24
    from the spreadsheet, the year appears to be 2-digit (e.g. 02)

    For a very quick and simple solution, in the query you wrote, put the following in the criteria field for SALE_YY:

    >[Later than Year]


    this will then prompt you for a year that you want to see all records since that year. This gives yo more flexibility, in case you should need to see 1, 2, 3 etc, years records at any given time.

  9. #9
    Join Date
    Oct 2004
    Posts
    7
    That did it!

    Thanks so much. You have no idea how valuable this little query is for us.

    Thanks

  10. #10
    Join Date
    Oct 2004
    Location
    Tunbridge Wells, Kent. UK
    Posts
    24
    How about a small 5 bed/pool house in Florida as a gift, to show your appreciation!

    Cheers, Matt

  11. #11
    Join Date
    Oct 2004
    Posts
    7
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •