B
balaji
Guest
Hi,
I created a table with several string fields. I am trying to write a filter that would match some fields in the table while matching case and other fields in the table without matching case (case-insensitive). Is there anyway to do it easily? The user enters the search criteria in a form (search strings as well as whether it should be matched with respect to case or not) and so I want to be able to decide on the fly what fields to match on with case-sensitivity and what fields to match without respect to case. BTW, I use the user entered criteria from the form to create a filter that is then used as the filter property of a report. The report gets its data from a query that just selects all records from the underlying table. Hope that came out clear. Please feel free to ask questions if it did not. I would appreciate any help anyone can provide me. Thank you.
I created a table with several string fields. I am trying to write a filter that would match some fields in the table while matching case and other fields in the table without matching case (case-insensitive). Is there anyway to do it easily? The user enters the search criteria in a form (search strings as well as whether it should be matched with respect to case or not) and so I want to be able to decide on the fly what fields to match on with case-sensitivity and what fields to match without respect to case. BTW, I use the user entered criteria from the form to create a filter that is then used as the filter property of a report. The report gets its data from a query that just selects all records from the underlying table. Hope that came out clear. Please feel free to ask questions if it did not. I would appreciate any help anyone can provide me. Thank you.
