ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 3 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 22 May 2017 My Price 8.00

Access to return a list from multiple tables

I'm trying to build queries in Access to return a list from multiple tables. I have names in one table, and several additional table with a list of names and values. I would like to build a query that would evaluate the fist list of names and return only those that meet a given criteria from multiple tables. Some tables even have the original list of names with duplicates.

 

Table 1Table 2Table 3NameClient IDClient IDAccomplishment 1Client IDBill122122 no122Mary123122 yes122Joe124123 yes123Luis125123 no123123 yes123Table 3124 no124Client IDYrs of Service124 no1241224124 no1241237124 no1241246125 yes12512510Query should find clients that have not earned an Accomplishment 1 butwho have earned Accomplishment 2.

Attachments:

Answers

ComputerScienceExpert
(11)
Status NEW Posted 22 May 2017 07:05 AM My Price 8.00

-----------

Attachments

file 1495438719-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------
Not Rated(0)