I have an Access database app that runs a query on real estate sold listings to determine market prices for new properties that come up on the market. It then figures out the list price per square foot vs. average sales price per square foot for a new listing and then filters out those new records where it is over 80% of the average price, all using data from properties that have sold within the same subdivision (and filters using the subdivision field in the database).
Now I need to add a new module and query to the database. This will require adding a few new fields to the database structure where all the data will be held. The data to be imported will have a couple fields different than what has been built in currently. I want a new module that takes records where status=L (meaning it was leased), then compare average lease prices per sqft to the sales price of a property, all that are within the same subdivision. Then, using a formula that spits out a number, it filters out those records where status=A (for sale) where the calculation is less than a certain percentage (I'm thinking 10% is that number). In other words, instead of finding an average Sales Price like the software does now, I want the new module to find this "Gross Margin" number for properties that potentially can be rentals. The data will be imported the exact same way as it is now. I will only be importing records where Status=L. The calculations to be done on import will only be a Lease $/sqft number. All the data stored is easily sortable and has been created using generally accepted programming standards. I also need to be able to ignore records that I have reviewed, but have those previously ignored records pop back up once the ListPrice has been updated through an import. It will have to be a different type of ignore than what has been coded currently, as there is an ignore feature in the current report.
The database has live data so that will have to be converted to accommodate the few new data fields. Capture1 is the main screen. Capture2 shows the import dialog box. Capture3 shows the reports to be generated (where I would like to choose to generating "Rental Property Report". Capture4 is the 80% report that shows properties whose list price is 80% or less than the average within its subdivision.