New member and need help

[vaidehikumar]

Hi I am an associate professor at a state college and I use access to create small databases.

Currently I am helping a friend to sep a DB for a fishing totrnament. I have a table with anglers and their fish weight. In the DB, user enters a weight (randomly selected) and the query should find the closest match. I will use Enter Parameter query to get the randomly selected weight and it should return the angler with the closest fish wt. The fish weight is in two decimal numbers. Thank you for the help.

 

[Alansidman]

Welcome to the forum. Please re-post your question in the proper area of the forum. In this way, a larger group of members will look and respond. Try to be as specific as possible when posting so that others will have a good understanding of what you are trying to accomplish

Alan