After examining your ACCDB file, I suggest you consider setting up the tables differently.  

Table Health_Professionals:



ID First Name Second Name Position hospital_id
1  John       Doe         PI                 2
2  Joe        Smith       Co-PI              1
3  Sarah      Johnson     Nurse              3


Table Hospitals:

hospital_id Hospital
          1 Beaumont
          2 St James
          3 Letterkenny Hosptial


A key point is to avoid storing both the hospital ID and name in the Health_Professionals table.  Store only the ID.  When you need to see the name, use the hospital ID to join with the Hospitals table and get the name from there.

A useful side effect of this design is that if anyone ever misspells a hospital name, eg "Hosptial", you need correct that error in only one place.  Same holds true whenever a hospital is intentionally renamed.

Based on those tables, the query below returns this result set.

ID Second Name First Name Position hospital_id Hospital
1  Doe         John       PI                 2 St James
3  Johnson     Sarah      Nurse              3 Letterkenny Hosptial
2  Smith       Joe        Co-PI              1 Beaumont

SELECT
    hp.ID,
    hp.[Second Name],
    hp.[First Name],
    hp.Position,
    hp.hospital_id,
    h.Hospital
FROM
    Health_Professionals AS hp
    INNER JOIN Hospitals AS h
    ON hp.hospital_id = h.hospital_id
ORDER BY
    hp.[Second Name],
    hp.[First Name];


How do I make a query for if value exists in row add a value to another field?
I am kind of studying physics on my own now.
I choose University Physics (13th Edition) for myself,is it fine?
I am also studying Calculus using Thomas' textbook.

http://www.amazon.com/University-Physics-13th-Edition-Young/dp/0321696891/ref=sr_1_1?ie=UTF8&amp;qid=1352260382&amp;sr=8-1&amp;keywords=university+physics+13th+edition
