MS Access Question
I know there are programmers out there and I have a question for them. I used to be a programs years ago and I'm very rusty.
I have built a db that I can import all the new mls listing and all the houses that have sold in my area over the last year. I have built a form that goes thru the new MLS listing, and I need to add a subform of all the past sold houses, but the filter is not working.
I want to use the oncurrent event and just rewrite the query that the subform is using, but I can't remember how to write the statement. Here is the sql statement
SELECT www.CompsSold.MLSNUM, [MapBook] & "/" & [MapPage] & "/" & [MapCoord] AS Map, [Area] & "/" & [SubArea] AS MLSArea, [StreetNum] & " " & [StreetName] & " " & [City] & ", " & [ZipCode] AS Address, www.CompsSold.ListPriceOrig, CompsSold.SqFtTotal, CompsSold.SalesPrice, www.CompsSold.MapPage, www.CompsSold.MapCoord, CompsSold.StreetName, CompsSold.Subdivision, ([SalesPrice]/[ListPriceOrig]) AS AskingPriceRatio, ([SalesPrice]/[SqFtTotal]) AS PricePerSqFt, ([StatusChangeDate]-[ListDate]) AS SoldIn
FROM CompsSold;
What I want to do is filter by street, subdivision, mapsco grid #, mapsco page. I also want the sq ft of the sold houses to be +/- 10% of the house that I'm looking to put an offer on.
By breaking down by street, subdivision and so I can get a really good feel for the Market Value of the house and what my first offer should be and the Max. offer I can submit.
If there is anyone that can help that would be great.
Also, if there are any programmers out there that want to work on this with me and post it free on the site that would be great.
It's been a long time since I worked with Access, but I might be able to help you. I need more info, though; the SQL statement doesn't do me any good without an idea of the DB structure and the other queries affecting the form!
PM me, if you still need help with this.
- Mandi
The programming that you are discussing is way over my head, but the end result sounds very beneficial.
You mentioned sharing it on the site when you are done. Good Luck and let us know!!!!