You'll need to create a function that accepts a marker value, pulls the value for each allele, and goes through that recordset and eventually returns yes or no based on your criteria. The easiest way would probably just be to pull up any records with value greater than 1000, and return yes if there are any records, and no if there are not.
I would include that in a query that returns a result for each marker (field 1 is Marker, field two is include, with Include being the function's returned value). Then join that query to your main query, if you want, showing ID, Marker, Allele, Value, and Include.
Also, be aware that ID and Value are reserved words in Access, and using them as field names will cause you no end of difficulties in the future. I'd suggest adding something to them; in an Employees table, for example, you'd use EmployeeID instead of ID.