Question about filtering a datasheet on MS Access (via VB)?

The way I am filtering my (subform) datasheet is by manipulating its SourceRecord property. “SELECT x, y, z FROM [table] WHERE [filter]”

I find it is easy to filter data that is organic to the table. For example:

=TABLE 1=
[ID], Project Name, ProjectStatus
[1] Project A, Complete
[2] Project B, In Progress
[3] Project C, In Progress

=TABLE2=
[ID], PersonName
[1], John
[2], Bill

=Table 3= ‘relationship table
[ProjectID], [PersonID]
[2], [1] ‘shows that john works both projects (B & C))
[3], [1]
[2]. [2] ‘bill works only project B.

I find that I can filter the status of the projects because it is a part of the data. Yeah, I can define status by a value, but let’s say I define it as text. I can filter it with WHERE ([table].ProjectStatus = ‘Complete’).

What if I want to filter by all the jobs that John has done? How do I do that?

Now, I know I can create a recordlist “SELECT * FROM [Table3] WHERE PersonID = 1″

This yields all the projects that John is affiliated with. But then how do I use this filtered Table 3 to filter Table 1? I want the result to show all the jobs that John has completed.

If there is a different method, or I’m taking the long route, please let me know. Thank you.

what are good and evil?

Are good an evil just factors of a social and moralistic values set by different people, can good an evil be manipulated within a social community, or are good and evil just factors that we use to present certain things we would affiliate them with?
Therefore if this is true then good and evil are only what we perceive them to be which means that they can be manipulated (setting aside moral values of human nature, nurture debate would go on forever) by who sees fit, so can this effect the choices we make as people towards a social community and can change our perceptive of life because if we cannot define the good and the bad on a psychological level (taking into account bad experiences and good release certain chemical hormones within the brain), then how do we define reality itself as being a constant with conciseness with no right or wrong?

What say you about this: Just 53% of Americans believe Capitalism is better than Socialism?

Here’s the article (released 4/9/09):

Only 53% of American adults believe capitalism is better than socialism.

The latest Rasmussen Reports national telephone survey found that 20% disagree and say socialism is better. Twenty-seven percent (27%) are not sure which is better.

Adults under 30 are essentially evenly divided: 37% prefer capitalism, 33% socialism, and 30% are undecided. Thirty-somethings are a bit more supportive of the free-enterprise approach with 49% for capitalism and 26% for socialism. Adults over 40 strongly favor capitalism, and just 13% of those older Americans believe socialism is better.

Investors by a 5-to-1 margin choose capitalism. As for those who do not invest, 40% say capitalism is better while 25% prefer socialism.

There is a partisan gap as well. Republicans – by an 11-to-1 margin – favor capitalism. Democrats are much more closely divided: Just 39% say capitalism is better while 30% prefer socialism. As for those not affiliated with either major political party, 48% say capitalism is best, and 21% opt for socialism.

The question posed by Rasmussen Reports did not define either capitalism or socialism

It is interesting to compare the new results to an earlier survey in which 70% of Americans prefer a free-market economy. The fact that a “free-market economy” attracts substantially more support than “capitalism” may suggest some skepticism about whether capitalism in the United States today relies on free markets.

Other survey data supports that notion. Rather than seeing large corporations as committed to free markets, two-out-of-three Americans believe that big government and big business often work together in ways that hurt consumers and investors.

Fifteen percent (15%) of Americans say they prefer a government-managed economy, similar to the 20% support for socialism. Just 14% believe the federal government would do a better job running auto companies, and even fewer believe government would do a better job running financial firms.

Most Americans today hold views that can generally be defined as populist while only seven percent (7%) share the elitist views of the Political Class.
____________________________________

Thoughts?

Is my paper owned by MTV?

I went on my newspaper’s website and found this under about us. Does this mean that MTV either owns our paper and/or the articles we submit?

3. OWNERSHIP OF INTELLECTUAL PROPERTY The contents of this Site, including all Site software, design, text, images, photographs, illustrations, audio and video material, artwork, graphic material, databases, proprietary information and all copyrightable or otherwise legally protectible elements of the Site, including, without limitation, the selection, sequence and ‘look and feel’ and arrangement of items, and all trademarks, service marks and trade names (individually and/or collectively, “Material”), are the property of the Parent Companies, and their Affiliates, and any of their successors and assigns, and any of their respective licensors, Advertisers (as defined below), suppliers, and operational service providers and are legally protected, without limitation, under U.S. Federal and State, as well as applicable foreign laws, regulations and treaties. Unless the context clearly requires otherwise or we explicitly say so in writing, the term “Site” includes “Material” as well. The Site is to be used solely for your noncommercial, non-exclusive, non-assignable, non-transferable and limited personal use and for no other purposes. You must not alter, delete or conceal any copyright or other notices contained on the Site, including notices on any Material you download, transmit, display, print or reproduce from the Site. You shall not, nor will you allow any third party (whether or not for your benefit) to reproduce, modify, create derivative works from, display, perform, publish, distribute, disseminate, broadcast or circulate to any third party (including, without limitation, on or via a third party website), or otherwise use, any Material without the express prior written consent of MTVN or its owner if MTVN is not the owner. Any unauthorized or prohibited use of any Material may subject you to civil liability, criminal prosecution, or both, under applicable federal, state and local laws. We require users to respect our copyrights, trademarks, and other intellectual property rights. We likewise respect the intellectual property of others. On notice, we will act expeditiously to remove content on the Site that infringes the copyright rights of others and will disable the access to the Site and its services of anyone who uses them to repeatedly to infringe the intellectual property rights of others.

We take protection of copyrights, both our own and others, very seriously. We therefore employ multiple measures to prevent copyright infringement over this Site and to promptly end any infringement that might occur. If you believe that the Site contains elements that infringe your copyrights in your work, please follow the procedures set forth in our Copyright Compliance Policy.

Is my newspaper owned by MTV?

I went on my newspaper’s website and found this under about us. Does this mean that MTV either owns our paper and/or the articles we submit?

3. OWNERSHIP OF INTELLECTUAL PROPERTY The contents of this Site, including all Site software, design, text, images, photographs, illustrations, audio and video material, artwork, graphic material, databases, proprietary information and all copyrightable or otherwise legally protectible elements of the Site, including, without limitation, the selection, sequence and ‘look and feel’ and arrangement of items, and all trademarks, service marks and trade names (individually and/or collectively, “Material”), are the property of the Parent Companies, and their Affiliates, and any of their successors and assigns, and any of their respective licensors, Advertisers (as defined below), suppliers, and operational service providers and are legally protected, without limitation, under U.S. Federal and State, as well as applicable foreign laws, regulations and treaties. Unless the context clearly requires otherwise or we explicitly say so in writing, the term “Site” includes “Material” as well. The Site is to be used solely for your noncommercial, non-exclusive, non-assignable, non-transferable and limited personal use and for no other purposes. You must not alter, delete or conceal any copyright or other notices contained on the Site, including notices on any Material you download, transmit, display, print or reproduce from the Site. You shall not, nor will you allow any third party (whether or not for your benefit) to reproduce, modify, create derivative works from, display, perform, publish, distribute, disseminate, broadcast or circulate to any third party (including, without limitation, on or via a third party website), or otherwise use, any Material without the express prior written consent of MTVN or its owner if MTVN is not the owner. Any unauthorized or prohibited use of any Material may subject you to civil liability, criminal prosecution, or both, under applicable federal, state and local laws. We require users to respect our copyrights, trademarks, and other intellectual property rights. We likewise respect the intellectual property of others. On notice, we will act expeditiously to remove content on the Site that infringes the copyright rights of others and will disable the access to the Site and its services of anyone who uses them to repeatedly to infringe the intellectual property rights of others.

We take protection of copyrights, both our own and others, very seriously. We therefore employ multiple measures to prevent copyright infringement over this Site and to promptly end any infringement that might occur. If you believe that the Site contains elements that infringe your copyrights in your work, please follow the procedures set forth in our Copyright Compliance Policy.
MTVN = MTV Networks, fyi