S
Sammy Hoelscher via AccessMonster.com
I'm working on a database. I import listings of house sold in different
subdivisions daily along with new listing. I'm trying to get a query that
will look at each new listing and tell me from looking at the sold table
that houses in X subdivision are selling for Y dollars a sq. ft. so the new
house should sell for Z.
Sold Table
Address
Subdivion
SoldPrice
SqFt
NewListing Table
NewListing_Address
NewListing_Subdivion
ListPrice
NewListing_SqFt
I want a query that returns
NewListing_Address
NewListing_SqFt
ListPrice
AveragePriceSqFtofSubdivision
MarketValue (AveragePriceSqFtofSubdivision * NewListing_SqFt)
Please help
subdivisions daily along with new listing. I'm trying to get a query that
will look at each new listing and tell me from looking at the sold table
that houses in X subdivision are selling for Y dollars a sq. ft. so the new
house should sell for Z.
Sold Table
Address
Subdivion
SoldPrice
SqFt
NewListing Table
NewListing_Address
NewListing_Subdivion
ListPrice
NewListing_SqFt
I want a query that returns
NewListing_Address
NewListing_SqFt
ListPrice
AveragePriceSqFtofSubdivision
MarketValue (AveragePriceSqFtofSubdivision * NewListing_SqFt)
Please help