Query Population with or without specific criteria from Form Field

bbarrene

New member
Local time
Today, 08:24
Joined
Aug 29, 2011
Messages
4
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.
 

Users who are viewing this thread

Back
Top Bottom