Query to return scored or weighted results based on user entered criteria

[Jasontm01]

Im wondering if I can create a query to return results in a specific way. What I want is to enter some search criteria from a few different fields that would match exactly then weight the results based on some other fields.

example:
custLocation 'dropdown box with different locations
custType 'dropdown box with different customer types

totalSales 'a number would be in this field
totalEmployees 'a number would be in this field
totalVehicles 'a number would be in this field
ContactName 'a name (text) goes here

What I would like is to be able to select something in the first 2 dropdown boxes as my search criteria then have the results returned with weighted results based on what was in the last 4 fields of the records. So the searcher could chose to weight totalSales as x4 and totalVehicles as x2 etc..

Ive seen this done on some web site searches but cant figure out how to do it for access.

Any ideas if this can be done??

 

[doran_doran]

Total Query...

1. You need to create a Total Query (new query, select the fields and then view total). Also, put [Forms]![nameOfTheForm]![combo1] for 1st combo in the criteria, and similar for 2nd criteria. Do a manual run to validate your total query.

2. Create a Form (add two combo box).

3. And QueryDef to call your query. and u can create export to Excel to view the result in a report.

Good Luck.

Dianna Goldsberg.