Search results

Really sorry to bother you again, If I use a form to get the mystery wt, how to pass that value into this query to use in the enter parameter field.

Thank you Paul. It worked. I'll remove the spaces in the field names. I should have known better. Thank you again.

Thank you for your reply. It worked, however I do not want other fields to show up in the ressults. I have angler name, different fish types, their wt. I want only the angler name and mystery wt field to be returned. I want only angler name and the Mystery weight to show in the results. Here...

Hi I have a table called Fish Data with anglers name and fish weight. I want to run a parameter query where the user will enter fish weight and the query should bring the closest match from the Fish data table. How do you get the closest number match. The fish weights are entered with two...

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...