Unanswered: how to create a filter in a report that will show/not show information
I created a basic database without using code (because I haven't figured that out yet). The form allows the user to input information on an award. The query is set up to filter if the user has more than one award or if it is the first award. In my report I set the prompt [is this the first award]. Here is where I am having trouble. If the user selects 'NO' i want the report to annotate XXth award. If the user selects 'YES' i dont want this line to show up at all. Any help?