looping through recordset (columnwise)

[pradeep.sands]

Hi guys,
I have a query("batdetails") interlinked with several tables, which looks like this:
Attachment 12878
also I hav a table ("factors") which looks like this:


Attachment 12879

My questions is, suppose if I consider the entire field/column "Lk_T0max" from the query "batdetails", every record in this field should pass a range check (error should be reported with msgbox). The parameters for this range check should be taken from the table "factors". For this example, every record of the field Lk_T0max from batdetails, should satisfy the range between 'min' and 'max' where ID=4 (i.e. for the respective Lk_T0max from the table "factors").
And similarly for other fields too.

Can someone help me out with this.

[rzw0wr]

Ok, to clarify you question.
You want to take a single row of data from batdetails and compare that to a column of data in factors.
If a problem is found report the problem to the user.
Correct?

Dale