Add a prompt for Dept ID: On the Criteria tab, click the Criteria” button “Add Choose Expression 1 type of Field, and click the looking glass icon, and click the link for the DEPTID field You may have to click the arrow to get the next page of fields in “next” this record Choose Condition Type equal to For Expression 2 Type, select: Prompt Click on the New Prompt link Change the edit type to Prompt Table, and click the looking glass icon In the text box next to with” type dept, then search “begins
Add a prompt for Dept ID: On the Criteria tab, click the “Add Criteria” button Choose Expression 1 type of Field, and click the looking glass icon, and click the link for the DEPTID field You may have to click the “next” arrow to get the next page of fields in this record Choose Condition Type equal to For Expression 2 Type, select: Prompt Click on the New Prompt link Change the edit type to Prompt Table, and click the looking glass icon In the text box next to “begins with” type dept, then search
2017-10-Fin-Query-Training.docx