Sedang Disiapkan

Add on to Existing Access Database App - repost

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.

Kemahiran: Microsoft Access, Visual Basic untuk Aplikasi, Destop Windows

Lihat lebih lanjut: what is the meaning of data structure, what is data structure in programming, what is database programming, programming in access database, programming access database, price of app, microsoft access programming, meaning of data structure, i need an access database, different type of data structure, data structure meaning, access database software, access database module, rental properties for sale, market prices, sales app, real estate app, pop-up formula, database calculations, access database, sales report access, query pop, rental access, converted app, microsoft price list

Tentang Majikan:
( 30 ulasan ) United States

ID Projek: #4117649

Dianugerahkan kepada:

VBAWhizz

As discussed.

$200 USD dalam 7 hari
(9 Ulasan)
4.9