finding the Closest match

[vaidehikumar]

Thank you Paul. You were great in timely help. You made my day! Everything is working now after I followed your advice to hit enter key.

 

[pbaldy]

No problem. I mentioned that early on because I still have a flat spot on my head from running into that very problem and banging my head against the desk.

 

[vaidehikumar]

Paul if you see this could you please assist me with this.

I have decided to store the MysteryWt entered in the form to a table called MysteryWeight under the field name MysteryWt. If I want to pass the MysteryWt (from the MysteryWeight table) to the query to find the closest match from the FishData table, how do I do that? Thank you again for your help.

 

[pbaldy]

A one-record table for the criteria? You could add that table to the query and change the form reference to the field name.

 

[vaidehikumar]

Thank you Paul. It is working now. You are a GREAT help.

 

[pbaldy]

Happy to help!