MS access help
| PartnershipID | Country | Partner Institution | Faculty | AgreementType | Terms_Of_Review | Effective_Date | Expiry_Date: | Date_To_Review | ContactName | Comments | Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125 | Italy | University of Brescia | Review | 1/1/11 | 1/1/16 | 5/3/15 | true | |||||
| 126 | Japan | Chiba Institute of Technology | Review | 7/12/10 | 7/12/15 | 11/11/14 | true | |||||
| 127 | Japan | Gunma University | Review | 9/28/12 | 9/28/17 | 1/28/17 | true | |||||
| 128 | Japan | Kyoto University | Review | 5/15/13 | 5/15/18 | 9/14/17 | Ms. Yukari Mikami | [email protected] | true | |||
| 129 | Japan | Urawa University | Automatic | 3/13/11 | 3/13/14 | 7/13/13 | false | |||||
| 130 | Mexico | Tec de Monterrey (ITESM) | Automatic | 8/1/09 | 8/1/15 | 12/1/14 | Beatriz Medrano | [email protected] | false | |||
| 131 | Mexico | Universidad Iberoamericana | Review | 8/1/09 | 8/1/14 | 12/1/13 | Mtra. Catherine Fanning Woodruff | [email protected] | false | |||
| 132 | Netherlands | Hanzehogeschool van Groningen | Automatic | 8/1/09 | 8/1/15 | 12/1/14 | Andries Rodenboog | [email protected] | false | |||
| 133 | Netherlands | Hogeschool van Amsterdam (AMFI) | Automatic | 8/1/10 | 8/1/16 | 12/2/15 | false | |||||
| 134 | Netherlands | Hogeschool van Utrecht | Automatic | 8/1/11 | 8/1/14 | 12/1/13 | Ms. Carmela Criseo | [email protected] | false | |||
| 135 | Netherlands | InHolland University Amsterdam | Automatic | 8/1/09 | 8/1/15 | 12/1/14 | false | |||||
| 136 | Netherlands | Tilburg University | Review | 9/1/12 | 9/1/17 | 1/1/17 | Ms. Nadia Ptashchenko | [email protected] | false | |||
| 137 | Netherlands | Tio University of Applied Sciences | Review | 9/1/12 | 9/1/17 | 1/1/17 | Amsterdam and Utrecht Campuses | false | ||||
| 138 | New Zealand | Auckland University of Technology | Automatic | 1/1/11 | 1/1/14 | 5/3/13 | Kenneth Holt | [email protected] | false | |||
| 139 | Poland | Wroclaw University of Technology | Automatic | 12/5/07 | 12/5/12 | 4/6/12 | false | |||||
| 140 | Portugal | ISCTE-University Institute of Lisbon | Review | 7/1/12 | 7/1/17 | 10/31/16 | false | |||||
| 141 | Scotland | Glasgow Caledonian University | Automatic | 8/1/10 | 8/1/16 | 12/2/16 | Debbie Goodwill | [email protected] | false | |||
| 142 | Scotland | Napier University | Review | 9/1/12 | 9/1/17 | 1/1/17 | Claire Hope | [email protected] | false | |||
| 143 | Scotland | University of Stirling | Automatic | 8/1/09 | 8/1/15 | 12/1/14 | Stephanie Niven / Jo Hagerty | [email protected] | false | |||
| 144 | Singapore | Nanyang Technological University | Automatic | 10/1/09 | 10/1/14 | 1/31/14 | Ms. Pauline Ho | [email protected] | false | |||
| 145 | South Korea | Chung-Ang University | Review | 5/1/11 | 5/1/16 | 9/1/15 | false | |||||
| 146 | Spain | Universidad Carlos III de Madrid | Review | 10/1/11 | 10/1/16 | 2/1/15 | David Gil Pérez | [email protected] | false | |||
| 147 | Spain | Universidad de Zaragoza | Review | 8/1/08 | 8/1/13 | 12/1/12 | Ms. Lucia Garcia Cebrian | [email protected] | false | |||
| 148 | Spain | University of Mondragón | Review | 3/10/10 | 3/10/15 | 7/10/14 | false | |||||
| 149 | Sweden | Jonkoping International Business School | Automatic | 6/15/11 | 6/15/14 | 10/15/13 | false | |||||
| 150 | Sweden | Karlstad University | Automatic | 7/1/11 | 7/1/14 | 10/31/13 | false | |||||
| 151 | Sweden | Linköping University | Review | 1/1/11 | 1/1/16 | 5/3/15 | Anna Andersson | [email protected] | false | |||
| 152 | Sweden | Umeå University | Review | 11/1/08 | 11/1/13 | 3/3/13 | Ms. Ulla Blomqvist | [email protected] | false | |||
| 153 | Tunisia | University of Sfax | Review | 7/1/12 | 7/1/17 | 10/31/16 | false | |||||
| 154 | Turkey | Koc University | Review | 6/1/13 | 6/1/18 | 10/1/17 | Ms. Sedef Ercetin | [email protected] | false | |||
| 155 | United States | University of California, LA (UCLA) | Review | 5/23/12 | false | |||||||
| 156 | Wales | Royal Welsh College of Music and Drama | Automatic | 3/1/10 | 7/2/15 | false | ||||||
| 157 | Wales | University of Wales, Newport | Automatic | 4/1/11 | 4/1/14 | 8/1/13 | Claire Birney | [email protected] | false | |||
| 158 | Germany | University of Applied Sciences at Wuerzburg-Schweinfurt | Inactive | false | ||||||||
| 159 | India | National Institute of Fashion Technology (NIFT) | Automatic | 1/1/10 | 1/1/13 | 5/3/12 | Mrs. Anupreet Bhalla Dugal | [email protected] | Terminated | false | ||
| 160 | India | Indian Retail School | Review | 1/15/07 | 1/15/07 | Expired | false | |||||
| 161 | India | Pearl Academy of Fashion | Review | 1/15/07 | 1/15/07 | Expired | false | |||||
| 117 | India | The Angel Investors Consortium | Review | 1/1/12 | 1/1/15 | 5/3/14 | true | |||||
| 118 | India | University of Mumbai, College of Social Work, Mumbai | Review | 2/3/10 | 2/3/15 | 6/5/14 | Gracie Joseph | [email protected] | true | |||
| 119 | Ireland | Dublin Institute of Technology | Automatic | 3/1/10 | 3/1/16 | 7/2/15 | Roger Sherlock | [email protected] | true | |||
| 120 | Ireland | University of Haifa | Review | 7/23/13 | 7/23/18 | 11/22/17 | Ms. Ilanit Palace | [email protected] | true | |||
| 121 | Ireland | Tel Aviv University | Automatic | 11/28/12 | 11/28/17 | 3/30/17 | true | |||||
| 122 | Italy | Libera Università di Lingue e Comunicazione (IULM) | Review | 5/30/10 | 5/30/15 | 9/29/14 | true | |||||
| 123 | Italy | Universita degli Studi di Firenze (University of Florence) | Review | 8/29/12 | 8/29/17 | 12/29/16 | true | |||||
| 162 | Scotland | University of Abertay Dundee | Automatic | 1/1/11 | 1/1/14 | 5/3/13 | Frank Pullen | false | ||||
| 163 | Italy | Milan Polytechnic University | Review | 5/2/05 | 5/2/10 | 9/1/09 | Maria Perego | [email protected] | Expired, no interest was expressed in renewal. Research performed on programs, do not appear to have equivalent programs in english. | false | ||
| 164 | Mexico | Universidad Iberoamericana | Automatic | 7/20/09 | 7/20/12 | false | ||||||
| 165 | Brazil | Municipality of Belo Horizonte | Review | 8/1/08 | 8/1/10 | 12/1/09 | false | |||||
| 166 | Columbia | Universidad de Catagena | Review | 9/28/09 | 9/28/09 | 1/28/09 | false | |||||
| 167 | Canada | Canadian Manufacturers and Exporters | Review | 1/17/09 | 1/17/10 | 5/19/09 | false | |||||
| 168 | India | The Confederation of Indian Industry | Review | 1/17/07 | 1/17/10 | 5/19/09 | false | |||||
| 169 | France | Institut National de l'Audiovisuel | Review | 4/27/07 | 4/27/10 | 4/27/09 | false | |||||
| 170 | Taiwain | National Taipai University of Technology | Review | 10/2/07 | 10/2/12 | 2/2/12 | false | |||||
| 171 | United States | Pennsylvania State University | Automatic | 7/18/08 | 7/18/11 | 11/17/10 | false | |||||
| 172 | China | North China University of Technology | Automatic | 10/23/10 | 10/23/11 | 2/22/11 | false | |||||
| 173 | Canada | University of Prince Edward Island | Automatic | 8/1/10 | 8/1/13 | 12/1/12 | Dr. Vianne Timmons | [email protected] | false | |||
| 174 | India | The Hatch | Review | 1/1/12 | 1/1/12 | 5/3/14 | false | |||||
| 175 | true | |||||||||||
| 30 | Australia | Curtin University of Technology | Automatic | 12/1/12 | 12/1/17 | 4/2/17 | Julie-Anne Beasley | [email protected] | true | |||
| 31 | Australia | RMIT University | Review | 8/18/10 | 8/18/15 | 12/18/14 | Judi Cowie | [email protected] | true | |||
| 32 | Australia | RMIT University (Study Tour) | Review | 6/8/12 | 8/18/15 | 12/18/14 | Emilia Tabrizi | [email protected] | true | |||
| 33 | Australia | University of New England | None | 10/25/10 | true | |||||||
| 34 | Australia | University of South Australia (UniSA) | Automatic | 1/1/10 | 1/1/16 | 5/3/15 | Karen English | [email protected] | true | |||
| 35 | Australia | University of Technology, Sydney | Review | 3/19/13 | 3/19/18 | 7/19/17 | Ms. Tze Ay Chuah | [email protected] | true | |||
| 36 | Austria | Johannes Kepler University | Automatic | 9/1/11 | 9/1/14 | 1/1/14 | true | |||||
| 37 | Barbados, Jamaica, Trinidad and Tobago | University of the West Indies | Review | 1/1/09 | 1/1/14 | 5/3/13 | true | |||||
| 38 | Barbados, Jamaica, Trinidad and Tobago | University of the West Indies | Review | 1/1/09 | 1/1/14 | 1/13/13 | [email protected] | true | ||||
| 39 | Belgium | Université Libre de Bruxelles | Review | 2/17/10 | 2/17/15 | 6/19/14 | true | |||||
| 40 | Brazil | Sao Paulo Research Foundation | Review | true | ||||||||
| 41 | Brazil | SESI / SENAI / IEL | Review | 2/2/12 | 2/2/17 | 6/4/16 | true | |||||
| 42 | Canada | Université du Québec à Montréal (UQAM) | Review | 9/29/09 | 9/29/14 | 1/29/14 | Vice-doyen aux etudes | true | ||||
| 43 | Canada | Université Laval | Review | 9/1/08 | 9/1/13 | 1/1/13 | Patrick Hurley | [email protected] | true | |||
| 44 | Chile | Universidad de Artes, Ciencias y Communicacion (UNIACC) | Review | 1/1/10 | 1/1/15 | 5/3/14 | Ms. Grace Agosin | [email protected] | true | |||
| 45 | Chile | Universidad del Pacifico | Automatic | 5/25/07 | 5/25/13 | 9/24/12 | John Cowell | [email protected] | true | |||
| 46 | Chile | Universidad Técnica Federico Santa María | Review | 10/7/10 | 10/7/15 | 2/6/15 | true | |||||
| 47 | China | Beijing Jiaotong University | Review | 6/8/12 | 6/8/17 | 10/8/16 | true | |||||
| 48 | China | China Three Gorges University | Review | 3/15/10 | 3/15/15 | 7/15/14 | true | |||||
| 49 | China | City University Hong Kong | Review | 9/1/10 | 9/1/15 | 1/1/15 | Dr. Mike Yao | [email protected] | true | |||
| 50 | China | Communication University of China | Review | 12/1/11 | 12/1/16 | 4/2/16 | true | |||||
| 51 | China | Tsinghua U. Insitute of Economics, Arts and Sciences | Review | 3/1/13 | 3/1/18 | 7/1/17 | true | |||||
| 52 | China | The Institute of Ethnology and Anthropology | Review | 3/1/13 | 3/1/18 | 7/1/17 | true | |||||
| 53 | China | Beijing Film Academy | Review | 4/8/13 | 4/8/18 | 8/8/17 | true | |||||
| 54 | China | Dalian Maritime University | Review | 6/1/11 | 6/1/16 | 10/2/15 | true | |||||
| 55 | China | Beijing University of Technology | Review | 5/1/13 | 5/1/18 | 8/31/17 | [email protected] | true | ||||
| 56 | China | COMAC Shanghai Aircraft Customer Service Co., Ltd. | Review | 1/16/12 | 1/1/17 | 5/3/16 | Trial | true | ||||
| 57 | China | Harbin Institute | Review | 6/1/11 | 6/1/16 | 10/2/15 | true | |||||
| 58 | China | Hong Kong Baptist University | Automatic | 1/1/11 | 1/1/14 | 5/3/13 | true | |||||
| 59 | China | Hong Kong Polytechnic University | Review | 8/28/12 | 8/28/17 | 12/28/16 | Ms. Cathy Wong | [email protected] | true | |||
| 60 | China | Nanjing Univeristy of Aeronautics and Astronautics | Review | 3/1/12 | 3/1/17 | 7/1/16 | true | |||||
| 61 | China | Northwestern Polytechnical University | Review | 3/10/12 | 3/10/17 | 7/10/16 | true | |||||
| 62 | China | Shanghai Finance University | Review | 6/10/13 | 6/10/18 | 10/10/17 | Ms. Amelia Shen | [email protected] | true | |||
| 63 | China | University of Hong Kong | Review | 6/15/09 | 6/15/14 | 10/15/13 | true | |||||
| 64 | China | Zhengzhou University | Review | 9/6/12 | 9/6/17 | 1/6/17 | true | |||||
| 65 | Colombia | Universidad de Cartagena | Review | 9/28/09 | 9/28/14 | 1/28/14 | true | |||||
| 66 | Colombia | Universidad Nacional de Colombia | Review | 11/20/09 | 11/20/14 | 3/22/14 | true | |||||
| 67 | Croatia | Zagreb School of Economics and Management | Review | 1/1/09 | 1/1/14 | 5/3/13 | Javier Aguayo | [email protected] | true | |||
| 68 | Denmark | Copenhagen Business School | Review | 1/9/11 | 1/9/14 | 5/11/13 | Mette Kloch | [email protected] | true | |||
| 69 | Denmark | Copenhagen School of Design and Technology (KEA) | Review | 7/1/11 | 7/1/16 | 11/1/15 | true | |||||
| 70 | Denmark | Danish School of Journalism, Aarhus | Automatic | 6/1/12 | 6/1/17 | 10/1/16 | Inger Muk | [email protected] | true | |||
| 71 | Denmark | Roskilde University | Automatic | 8/1/09 | 8/1/15 | 12/1/14 | Chanda Hansen | [email protected] | true | |||
| 72 | Denmark | VIA University College | Review | 9/1/17 | 9/1/17 | 1/1/17 | Tina Lisberg Bundgaard | [email protected] | true | |||
| 73 | England | Birmingham City University | Automatic | 8/1/09 | 8/1/15 | 12/1/14 | Sarah Hopkins | [email protected] | true | |||
| 74 | England | Bournemouth University | Automatic | 1/1/11 | 1/1/14 | 5/3/13 | true | |||||
| 75 | England | City University London | Automatic | 8/1/09 | 8/1/14 | 12/1/14 | Ivan Hutchins | [email protected] | true | |||
| 76 | England | Coventry University | Review | 12/1/09 | 12/1/14 | 4/2/14 | Ian Dunn | [email protected] | true | |||
| 77 | England | Manchester Metropolitan University | Automatic | 1/1/11 | 1/1/14 | 5/3/13 | true | |||||
| 78 | England | Nottingham Trent University | Review | 11/18/11 | 7/1/16 | 11/1/15 | true | |||||
| 79 | England | Sheffield Hallam University | Automatic | 8/1/09 | 8/1/15 | 12/1/14 | true | |||||
| 80 | England | University of Portsmouth | Automatic | 6/30/11 | 6/30/16 | 10/31/15 | true | |||||
| 81 | England | University of Surrey | Review | 5/1/11 | 5/1/11 | 5/1/16 | 1-sep-15 | true | ||||
| 82 | England | University of Westminster | Review | 6/8/12 | 8/1/15 | 12/1/14 | true | |||||
| 83 | Finland | AALTO University | Review | 11/1/12 | 11/1/17 | 3/3/17 | true | |||||
| 84 | Finland | HAAGA-HELIA University of Applied Sciences | Review | 1/1/11 | 1/1/16 | 5/3/15 | true | |||||
| 85 | France | AgroSup Dijon | Review | 4/8/11 | 4/8/16 | 8/9/15 | true | |||||
| 86 | France | BBA ESSEC Business Schoo | Review | 1/1/13 | 1/1/18 | 5/3/17 | true | |||||
| 87 | France | ESIDAI | Review | 12/7/09 | 12/7/14 | 4/8/14 | Ecole Supérieure d’Ingénieurs en Développement Agroalimentaire Intégré | true | ||||
| 88 | France | ESTACA École D'Ingénieurs | Automatic | 11/15/10 | 11/15/13 | 3/17/13 | true | |||||
| 89 | France | Group ICAM | Review | 10/5/10 | 10/5/15 | 2/4/15 | true | |||||
| 90 | France | Institut d'Économie Scientifique et de Gestion | Review | 1/1/09 | 1/1/14 | 5/3/13 | true | |||||
| 91 | France | Institut Français de Mecanique Avancee (IFMA) | Review | 1/15/10 | 1/15/15 | 5/17/14 | true | |||||
| 92 | France | SKEMA Business School (previously CERAM) | Automatic | 8/1/12 | 8/1/17 | 12/1/16 | true | |||||
| 93 | France | Telecom INT SudParis | Automatic | 3/10/08 | 3/10/13 | 7/10/12 | true | |||||
| 94 | France | Universite Paris-Dauphine | Automatic | 8/1/10 | 8/1/16 | 12/2/15 | true | |||||
| 95 | Germany | Fachhochschule Frankfurt am Main | Automatic | 1/1/10 | 1/1/16 | 5/3/15 | true | |||||
| 96 | Germany | Filmakademie Baden Württemburg | Automatic | 1/1/11 | 1/1/14 | 5/3/13 | true | |||||
| 97 | Germany | Friedrich-Alexander-Universitaet Erlangen-Nuernberg (FAU) | Review | 7/13/11 | 7/13/16 | 11/13/15 | true | |||||
| 98 | Germany | German Cancer Research Center (DKFZ) | Review | 2/6/09 | 2/6/14 | 6/8/13 | true | |||||
| 99 | Germany | Heidelberg University | Review | 1/1/09 | 1/1/14 | 5/3/13 | Dr. H. Joachim Gerke | [email protected] | true | |||
| 100 | Germany | Hochschule der Medien | Automatic | 1/1/11 | 1/1/14 | 5/3/13 | true | |||||
| 101 | Germany | Karlsruhe University of Applied Sciences | Review | 5/1/10 | 5/1/15 | 8/31/14 | true | |||||
| 102 | Germany | Karlsruhe University of Applied Sciences | Review | 9/1/09 | 9/1/13 | 1/1/13 | true | |||||
| 103 | Germany | Karlsruhe University of Applied Sciences | Automatic | 3/1/11 | 3/1/14 | 7/1/13 | Dr. Joachim Lembach | [email protected] | true | |||
| 104 | Germany | Karlsruhe University of Applied Sciences | Review | 1/1/10 | 1/1/15 | 5/3/14 | true | |||||
| 105 | Germany | University of Applied Sciences Offenburg | Review | 5/1/10 | 5/1/15 | 8/31/14 | true | |||||
| 106 | Germany | University of Augsburg and Technische Universität München | Automatic | 5/18/11 | 5/18/13 | 9/17/12 | true | |||||
| 107 | Germany | University of Münster | Review | 9/1/09 | 9/1/14 | 1/1/14 | Dr. Christoph Brox | true | ||||
| 108 | Germany | University of Television and Film Munich | Review | 9/1/12 | 9/1/17 | 1/1/17 | true | |||||
| 109 | Germany | Aristotle University of Thessaloniki | Review | 2/2/12 | 2/2/17 | 6/4/16 | true | |||||
| 110 | India | Anna University | Review | 6/1/11 | 6/1/16 | 10/2/15 | true | |||||
| 111 | India | Center for Development and Human Rights (CDHR) | Review | 2/1/12 | 2/1/17 | 6/3/16 | true | |||||
| 112 | India | India Institute of Technology Bombay (IIT Bombay) | Review | 10/17/12 | 10/17/17 | 2/16/17 | true | |||||
| 113 | India | Indian Institute of Technology Madras (IIT Madras) | Review | 11/24/09 | 11/24/14 | 3/26/14 | true | |||||
| 114 | India | Indo-Canadian Business Chamber | Review | 2/1/12 | 2/1/15 | 6/3/14 | true | |||||
| 115 | India | Jamia Millia Islamia University | Review | 9/27/12 | 9/27/17 | 1/27/17 | true | |||||
| 116 | India | O.P Jindal Global University | Review | 1/24/12 | 1/24/17 | 5/26/16 | true |
| SwitchboardID | ItemNumber | ItemText | Command | Argument |
|---|---|---|---|---|
| 1 | 0 | Main Switchboard | Default | |
| 1 | 1 | Add new Partnership | 2 | Partnership Form |
| 1 | 2 | View All Partnerships | 4 | rptAllPartnerships |
| 1 | 3 | Edit Partnerships | 3 | EditPartnership Form |
| 1 | 4 | View Renewable Partnerships | 3 | EditPartnership Form |
| 1 | 5 | View Cancelled/Expired Partnerships | 4 | CancelledExpiredContract |
| 1 | 6 | Country Wide Report | 4 | rptCountry |
| 1 | 7 | Search | 3 | EditPartnership Form |
| 1 | 8 | Exit | 6 |
SELECT DISTINCTROW *
FROM Partnership;
SELECT DISTINCTROW *
FROM Partnership;
SELECT Partnership.Country, Partnership.[Partner Institution], AgreementType.AgreementType, PartnershipFaculty.Faculty, Partnership, Partnership.[Expiry_Date:], Partnership.ContactName
FROM PartnershipFaculty INNER JOIN (AgreementType INNER JOIN Partnership ON AgreementType.AgreementTypeID=Partnership.AgreementTypeID) ON PartnershipFaculty.Faculty_ID=Partnership.Faculty_ID
WHERE (((Partnership.Country)=[Enter the Country Name?]));
SELECT *
FROM [Switchboard Items]
WHERE [ItemNumber]>0 And [SwitchboardID]=TempVars!SwitchboardID
ORDER BY [ItemNumber];
SELECT Partnership.Country, Partnership.[Partner Institution], Partnership.Faculty, Partnership.AgreementType, Partnership.[Expiry_Date:], Partnership.PartnershipID, Partnership.PartnershipID, Partnership.Country, Partnership.Faculty, Partnership.AgreementType, Partnership.Terms_Of_Review, Partnership.Status, Partnership.Effective_Date, Partnership.[Expiry_Date:], Partnership.Date_To_Review, Partnership.Date_To_Review, Partnership.ContactName, Partnership.Email, Partnership.Email, Partnership.Comments, Partnership.Status, Partnership.*
FROM Partnership
WHERE (((Partnership.Country)=[Enter the Country Name?]));
SELECT Partnership.PartnershipID, Partnership.Country, Partnership.[Partner Institution], Partnership.Faculty, Partnership.AgreementType, Partnership.Terms_Of_Review, Partnership.Effective_Date, Partnership.[Expiry_Date:], Partnership.Date_To_Review, Partnership.ContactName, Partnership.Email, Partnership.Comments, Partnership.Status
FROM Partnership
WHERE (((Partnership.Country)=[Search the Entire Database]));
UPDATE Partnership
SET Partnership.[Expiry_Date:] = DateAdd('yyyy',1,[Expiry_Date:])
WHERE (((DateDiff("m",Now(),[Expiry_Date:]))<4));
SELECT Partnership.PartnershipID, Partnership.Country, Partnership.[Partner Institution], Partnership.Faculty, Partnership.Faculty.Value, Partnership.AgreementType, Partnership.AgreementType.Value, Partnership.Terms_Of_Review, Partnership.Effective_Date, Partnership.[Expiry_Date:], Partnership.Date_To_Review, Partnership.ContactName, Partnership.Email, Partnership.Comments, Partnership.Status
FROM Partnership
WHERE (((Partnership.[Expiry_Date:])<Date()));
SELECT DISTINCTROW [Partnership].[PartnershipID], [Partnership].[Country], [Partnership].[Partner Institution], [Partnership].[Faculty], [Faculty_D0C57CA7F316446C87D989741DFADC6F].[Value], [Partnership].[AgreementType], [AgreementType_0ABB9AAE9B034EE79A55C23240BD0AE8].[Value], [Partnership].[Terms_Of_Review], [Partnership].[Effective_Date], [Partnership].[Expiry_Date:], [Partnership].[Date_To_Review], [Partnership].[ContactName], [Partnership].[Email], [Partnership].[Comments], [Partnership].[Status], [Faculty_D0C57CA7F316446C87D989741DFADC6F].[_TempField*0], [AgreementType_0ABB9AAE9B034EE79A55C23240BD0AE8].[_TempField*0]
FROM (Partnership LEFT JOIN [f_72D9198A83554980A99939BDD140CEBC_TempField*0] AS Faculty_D0C57CA7F316446C87D989741DFADC6F ON [Partnership].[Faculty]=[Faculty_D0C57CA7F316446C87D989741DFADC6F].[_TempField*0]) LEFT JOIN [f_40FA3815EFB94B97900F6D953FB4A719_TempField*0] AS AgreementType_0ABB9AAE9B034EE79A55C23240BD0AE8 ON [Partnership].[AgreementType]=[AgreementType_0ABB9AAE9B034EE79A55C23240BD0AE8].[_TempField*0]
WHERE ((([Partnership].[Expiry_Date:])<Date()));
SELECT DISTINCTROW *
FROM Partnership;
SELECT Partnership.Country, Partnership.[Partner Institution], Partnership.Faculty, Partnership.AgreementType, Partnership.[Expiry_Date:], Partnership.Terms_Of_Review, Partnership.Effective_Date, Partnership.Date_To_Review, Partnership.Status
FROM Partnership
WHERE (((DateDiff("m",Now(),[Expiry_Date:]))<[Select no of renewal partnership months ?]));