UPDATE Sheet1 SET Imagename = 'charlotte.gif' WHERE Imagename = 'charlotte' SELECT HomeName, squareFootage, bedrooms, bathrooms, levels, pdflink, imagename FROM Sheet1 WHERE 1 = 1 AND squarefootage >= 0 AND squarefootage <= 1000 AND squarefootage >= 1000 AND squarefootage <= 2000 AND squarefootage >= 2000 AND squarefootage <= 3000 AND squarefootage >= 3000 AND squarefootage <= 4000 AND squarefootage >= 4000 AND squarefootage <= 5000 AND squarefootage >= 5000 AND bedrooms = #form.bedrooms# AND bathrooms = #form.bathrooms# AND levels = #form.levels# AND homeid = #form.homeid# order by squarefootage asc select DISTINCT homeid, homename from Sheet1
Home Name:
Square Footage:
Bedrooms:
Bathrooms:
Levels:

#qryDisplay.recordcount# Results Found
Please broaden your search criteria and try again.
#qryDisplay.homename# #Homename#
Square Footage: #NumberFormat(qryDisplay.squareFootage,'9999')#
Levels: #NumberFormat(qryDisplay.levels,'9999')#
Bedrooms: #NumberFormat(qryDisplay.bedrooms,'9999')#
Bathrooms: #NumberFormat(qryDisplay.bathrooms,'9999')#
View Brochure