Experience level: Just above novice.
I have a table called "Presentations" that have a field called "CoalitionMeeting" with three options (ALF Coalition, SNF Coalition, ALF/SNF Coalition) to choose from when entering my data.
I have a query called "Coalition Presentations" where I pull in all of the data that I need for my report. The query is currently includes the field "CoalitionMeeting" but no specific criteria is identified.
In my report I have an unbound text box with the control source "CoalitionMeeting". What I need is for this box to pull one of the three options listed above in my table, e.g., ALF Coalition.
I have written 3 queries to get around this issue, but I know this is not the way to go. I know there is a simple expression I can probably use to pull in from one query, but I don't know what it is.
Thanks!