How to create form for entries for querying table

[Twinnie]

Hello,



I have a simple table of fields: S/N, Staff, Metrics 1, Metrics 2, Metrics 3, Metrics 4, Metrics 5. Table name is called StaffInfo.

I want to specify a range of numbers to display per metric depending on the value supplied in the form.

My challenge is that I don't know how to map the form input to the query criteria and secondly it is possible that I want to specify a range for the metric value e.g. for metric 1, the value could be between 5 and 8.

Please find attached a sampleDB.

Thank you.

[NTC]

I do not look at attachments. A query has criteria i.e. the metric value >=5 and <=8

Criteria can be 'called' in from a text box in a form by entering the proper syntax: Forms!FormName.TextboxName

Forms! is literal the other must be your names.

So you can have: >= Forms!FormName.TextboxName1 AND <= Forms!FormName.TextboxName2

[orange]

You should research Normalization. It will help you structure you table(s) to make querying easier.