Multi Criteria Search

[fraser_lindsay]

Hello,

I have been trying to produce a front end for a multi criteria search. I have used one of the sample databases from the site and amended the code as necessary, but obviously not correctly. I can't get it to show me the records based on my search criteria.

I would be grateful if somebody could have a look and let me know what I've done wrong (cut down DB attached). If I can crack this I want to do another multicriteria search for other parameters.

One other question - is it possible to take those filtered records and dump them into a report? For example, say I select one parameter and want tpo print all records associated with that parameter?

Thanks

 

[le888]

In your query "qrySearchCriteria", the "PersonnelNo" field type does not match with your "Occupational Profile Ref" fieldt ype . One is a number field type and other is a text field type. First, you have to fix this.

Hope this will help,

Le

 

[fraser_lindsay]

Hello again Le,

I have put a right join from PersonnelNo to OccProfileID now.

However, when I run the query it list everyone but strips out the Business and Business unit for some reason. If you remove the link and run it with no link it lists everyone with all details as normal.

Still makes no difference to my selection form though.

F

 

[le888]

See attachement.. I have fixe the query. But still the Search form seems not working.

Le

 

[fraser_lindsay]

Thanks Le.