Exclude individuals from "false" list if they are in the "true" list (1 Viewer)

[h2opololea]

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!!!

 

[h2opololea]

Re: Exclude individuals from "false" list if they are in the "true" list

Could my problem be related (or more easily solved) if the "Exclude Individual" was reported/communicated to the master table that contains all of the individuals for the daily research entries form? Currently it is only entered into the data transactions table.

 

[JHB]

Re: Exclude individuals from "false" list if they are in the "true" list

Could my problem be related (or more easily solved) if the "Exclude Individual" was reported/communicated to the master table that contains all of the individuals for the daily research entries form? Currently it is only entered into the data transactions table.

Without seeing you data, I think it would be the best way, how would you else classified/exclude if they both are mark with false and true, in the data for the report.

 

[h2opololea]

Re: Exclude individuals from "false" list if they are in the "true" list

Without seeing you data, I think it would be the best way, how would you else classified/exclude if they both are mark with false and true, in the data for the report.

Well, I was hoping there would be an If/Then type of code that I could use to have the list only populated form the most recent form entry for a particular individual.

Is there a way to update the master table whenever an individual is excluded? If I ran a query that looked only for excluded individuals, could the query update the correct individuals in the master table?

 

[h2opololea]

Re: Exclude individuals from "false" list if they are in the "true" list

Figured it out! Now just to figure out how to get the "False" count to work on the report... Works perfectly if "True", but always shows a 0 for the "False" total. But, that's something I can deal with. Thanks for your help!