Hi John, Maybe an example then using the query designer.
Here is the table I will query: http://www.oucv.org/download/Drugs/Screenshot-Drugs_Table_Data_View_Beta.png Here is the query designer, input and results http://www.oucv.org/download/Drugs/Parameter-query.png When you enter your search criteria it is not necessary to enter the single quotes, front and back, they are added by application - but entering them will not cause a problem either. Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
