Parametric Query Problem
Hello Everyone, I'm trying to develop a parametric query in Access that will be able to display an element and its associated info without having to type in the complete name of the element.
For example: I have this project where I have to build a database which would allow us to query for deductions made to employees payroll accounts for their cafeteria transactions, State Income Taxes, Federal Income Taxes, etc, etc...
The transactions in this case are the elements. So if we want to extract all data/info relate to cafeteria, my query prompts me for that. But then I have to type in "cafeteria" completely before it will pull the related info. So I want to know how I can modify my query in the criteria section so that when I type in "caf" or "Ban" it can display all elements or transactions whose names begin with "caf" or "ban"; in this case cafeteria or bankruptcy.
I have tried using the "like" operator with the wild cards but I want to know how to incorporate that into my parametric query. Help. Thanks:)