My apologies if this question has been answered already. I have searched but have been unable to find a solution.
I am currently generating a query that populates it's data based on the value (Team Name) of a form field. Now, let's say I want to use the same query to take it one step further and only populate the data from both a Associate Name value and Team Name value. How is this done? What formula should i be writing in the Criteria section?
I want to give users the option to generate a report for a specific team or for a specific associate within a specific team. If the user chooses not to set a team but chooses an associate, it will display all the results of the associate (whether they were in TEAM A, TEAM B, TEAM C, etc). If the user chooses not to select an Associate but selects a team, the report will display the data of all the results for all associates within a specific team. And if they decide to not select any associate or team, the report will display the data for all the associates of all the teams.
Thanks in advance.
I am currently generating a query that populates it's data based on the value (Team Name) of a form field. Now, let's say I want to use the same query to take it one step further and only populate the data from both a Associate Name value and Team Name value. How is this done? What formula should i be writing in the Criteria section?
I want to give users the option to generate a report for a specific team or for a specific associate within a specific team. If the user chooses not to set a team but chooses an associate, it will display all the results of the associate (whether they were in TEAM A, TEAM B, TEAM C, etc). If the user chooses not to select an Associate but selects a team, the report will display the data of all the results for all associates within a specific team. And if they decide to not select any associate or team, the report will display the data for all the associates of all the teams.
Thanks in advance.