I'm trying to emphasize that dealing with 1.1+ million records could be slow.
Things will improve a lot if Value and sq_Ft fields are indexed. I calculated the .9 and 1.1 % values for Value and SQ_ft since I wanted to avoid doing these 4 calculations in each of the records involved.
You could have a form where an account number is entered:
Account Number _________ and type in the account number,
behind the scenes vba gets the Value and SQ_FT values for the account. It then calculates the .9 and 1.1 values
for Value (say X and Y) and SQ_ft (say A and B), and creates some SQL to build the query.
The idea is to do the calculations of .9 and 1.1 once and then put in the actual values.
Also, since you want his account figures included, I think I would add an OR to the query
and if you want his numbers to be within the data being displayed I'd suggest a SORT BY.
The basic query is along this line, but I'd still do it behind the scenes (vba code) to avoid the extra (potential) 4 million calculations.
---untested---
Code:
SELECT theFieldsYouWant FROM Table
WHERE
(Value BETWEEN X and Y AND
Sq_ft BETWEEN A and B) OR
(acctNo = AcctNo That was typed in)
ORDER BY Value ;