h2opololea
New member
- Local time
- Today, 06:37
- Joined
- Jul 15, 2013
- Messages
- 5
Exclude individuals from "false" list if they are in the "true" list
Hi all - I am brand new to Access (2010 is the version I'm using) and trying to use Access to create a research database to make daily research entries for individuals in my year-long experiment (don't worry - not humans!).
I have created my tables and form and am now trying to run reports to organize the data. I have figured out how to group the individuals by group and treatment, but can't figure out how exclude individuals from the final list if they are already in another. As background, some of the individuals are eventually excluded from the experiment, though I keep the initial data. When the exclude individual checkbox is checked ("True" on the report) I do not want the individual to be listed in the "False" list, even though there are entries for that individual when that checkbox wasn't checked (when it was "True"). This is so I can get an idea of the current totals in each group. Does that make sense?
Here's a schematic of my report:
Implant Period
>Treatment
>>Exclude individual?
>>>Individual ID
I feel like this should be a fairly simple task, but I cannot figure it out... :banghead: Maybe there is coding to exclude individuals from the "False" list if they are already listed in the "True" list?
Thank you for any help!!!
Hi all - I am brand new to Access (2010 is the version I'm using) and trying to use Access to create a research database to make daily research entries for individuals in my year-long experiment (don't worry - not humans!).
I have created my tables and form and am now trying to run reports to organize the data. I have figured out how to group the individuals by group and treatment, but can't figure out how exclude individuals from the final list if they are already in another. As background, some of the individuals are eventually excluded from the experiment, though I keep the initial data. When the exclude individual checkbox is checked ("True" on the report) I do not want the individual to be listed in the "False" list, even though there are entries for that individual when that checkbox wasn't checked (when it was "True"). This is so I can get an idea of the current totals in each group. Does that make sense?
Here's a schematic of my report:
Implant Period
>Treatment
>>Exclude individual?
>>>Individual ID
I feel like this should be a fairly simple task, but I cannot figure it out... :banghead: Maybe there is coding to exclude individuals from the "False" list if they are already listed in the "True" list?
Thank you for any help!!!