SELECT APPLICATION.PREFIX, APPLICATION.[FILE REFERENCE], APPLICATION.[PROPERTY NUMBER], APPLICATION.[PROPERTY ADDRESS], APPLICATION.TOWN, APPLICATION.[PROPERTY POSTCODE], APPLICATION.POSITION, APPLICATION.DESCRIPTION, ENQUIRY.CONDITION, APPLICATION.TYPE, ENQUIRY.VACANCY, APPLICATION.DIVISION, APPLICATION.[DISTRICT COUNCIL], [DC CODES].DC_CODE, IIf([APPLICATION]![DISTRICT COUNCIL]="Antrim" Or [APPLICATION]![DISTRICT COUNCIL]="Ballymena" Or [APPLICATION]![DISTRICT COUNCIL]="Banbridge" Or [APPLICATION]![DISTRICT COUNCIL]="Ards" Or [APPLICATION]![DISTRICT COUNCIL]="Carrickfergus" Or [APPLICATION]![DISTRICT COUNCIL]="Castlereagh" Or [APPLICATION]![DISTRICT COUNCIL]="North Down",'NO','YES') AS DISADVAREA, IIf([APPLICATION]![TOWN]=[CRISP]![TOWN],'CR',IIf([DISADVAREA]='YES','DI','ND')) AS [CR/DI/ND], IIf(([APPLICATION]![TOWN]=[CRISP]![TOWN]) And ([APPDATES]![APP_DBM_DA]>=[CRISP]![DESIGNATED]) And ([APPDATES]![APP_DBM_DA]<=[CRISP]![END_DESIGN]),'CR',IIf([DISADVAREA]='YES','DI','ND')) AS [CURRENT CRISP STATUS], APPLICANT.APPLICANT_TITLE, APPLICANT.APPLICANT_FORENAME, APPLICANT.APPLICANT_SURNAME, APPLICANT.APPLICANT_COMPANY, APPLICANT.APPLICANT_ADDRESS, APPLICANT.APPLICANT_TOWN, APPLICANT.APPLICANT_COUNTY, APPLICANT.APPLICANT_POSTCODE, APPLICANT.APPLICANT_PHONE_NO, AGENT.AGENT_TITL, AGENT.AGENT_FORE, AGENT.AGENT_SURN, AGENT.AGENT_COMP, AGENT.AGENT_PHON, AGENT.AGENT_FAX, APPDATES.APPLICATI2, NOTES.APPLICATIO, APPDATES.APP_BRANCH, APPDATES.APP_DBM_DA, DECISIONS.APP_DBM_DECISION, APPDATES.FULL_BOARD_DATE, APPDATES.APP_DATE_N, JOBS.FT_JOBS, JOBS.PT_JOBS, JOBS.RECIPIENT_, APPDATES.APP_APPEAL, APPDATES.APP_APPEA3, APPDATES.DECISION, [APPLICATION APPRAISERS].APP_APPRAISER, [APPLICATION APPRAISERS].APP_APPRAISER_DATE_ISSUED, [APPLICATION APPRAISERS].APP_APPRAISER_DATE_DUE, [APPLICATION APPRAISERS].APP_APPRAISER_REMINDER, [APPLICATION APPRAISERS].APP_APPRAISER_DATE_RECEIVED, APPDATES.PROJECT_SS, NOTES.PSSC_BY, APPDATES.ELEVATIONS, NOTES.ESS_BY, APPDATES.REVISED_GR, NOTES.RGCSS_BY, APPDATES.AIP_DATE, APPDATES.AIPA_DATE, APPDATES.DISPENSATI, APPDATES.WORK_START, APPDATES.WORK_COMPL, APPDATES.POST_SCHEM, STATAPPS.TITLE, STATAPPS.INSURANCE_, STATAPPS.BC_APPROVA, STATAPPS.PLANNING_P, STATAPPS.TENDERS, APPDATES.PD_DATE, APPDATES.RJ_DATE, APPDATES.WD_DATE, APPDATES.REVISED_G2, NOTES.RGCSS_FA_B, APPDATES.FA_CHECK_D, APPDATES.FA_DATE, APPDATES.FAA_DATE, IIf((('TOTAL GRANT'-'TOTAL DBM GRANT')/'TOTAL GRANT')*100>=10,'POSSIBLE REFERRAL','N/A') AS [% CHANGE OF FA], STATAPPS.BC_LETTER_, STATAPPS.PC_CERT, STATAPPS.FINAL_CERT, STATAPPS.FINAL_A_C, STATAPPS.FEE_A_C, FINANCE.OTHER_GRAN, GRANTS.GRANT_SOUG, [GRANTS]![APPLICATION]+[GRANTS]![DBM_APPROV] AS [TOTAL DBM GRANT], GRANTS.APPLICATION, GRANTS.DBM_APPROV, GRANTS.PRIVATE_CO, GRANTS.PUBLIC_CON, AMENDMENTS.REASON, AMENDMENTS.AMEND_DATE, AMENDMENTS.NET_GRANT_ADJUSTMENT, AMENDMENTS.FEES_ADJUSTMENT, AMENDMENTS.PRIVATE_CONTRIBUTION_ADJUSTMENT, AMENDMENTS.PUBLIC_CONTRIBUTION_ADJUSTMENT, Sum([AMENDMENTS]![NET_GRANT_ADJUSTMENT]) AS A, Sum([AMENDMENTS]![FEES_ADJUSTMENT]) AS B, Sum([AMENDMENTS]![PRIVATE_CONTRIBUTION_ADJUSTMENT]) AS C, Sum([AMENDMENTS]![PUBLIC_CONTRIBUTION_ADJUSTMENT]) AS D, GRANTS.GECS, IIf([APPLICATION]![POSITION]='WD','0','TOTAL NET GRANT'+'TOTAL FEES') AS [TOTAL GRANT], [GRANTS]![APPLICATION]+'A' AS [TOTAL NET GRANT], [GRANTS]![DBM_APPROV]+'B' AS [TOTAL FEES], IIf([APPLICATION]![POSITION]='WD' Or [APPLICATION]![POSITION]='RJ','0','TOTAL GRANT'-'TOTAL PAYMENTS') AS BALANCE, Sum([PAYMENTS]![PAYMENT_AM]) AS [TOTAL PAYMENTS], Sum([AMENDMENTS]![PUBLIC_CONTRIBUTION_ADJUSTMENT]) AS [TOTAL PUBLIC CONTRIB], Sum([AMENDMENTS]![PRIVATE_CONTRIBUTION_ADJUSTMENT]) AS [TOTAL PRIVATE CONTRIB], 'TOTAL PUBLIC CONTRIB'+'TOTAL PRIVATE CONTRIB'+'TOTAL GRANT' AS [PROJECT COSTS], NOTES.DATE, NOTES.NAME, NOTES.NOTES, PAYMENTS.PAYMENT_NU, PAYMENTS.PAYMENT_AM, BFS.BF_STATUS, BFS.FILE_TO, BFS.ISSUE_DATE, APPLICATION.PROFILE, [qry_Live Prog].[LIVE?], [qry_Live Prog].[PROG STATUS AGENT]
FROM [qry_Live Prog], [DC CODES] INNER JOIN ((((((((((((((APPDATES INNER JOIN APPLICATION ON APPDATES.APPDATES_FILE_ID = APPLICATION.[APPLICATION FILE ID]) INNER JOIN AGENT ON APPLICATION.[APPLICATION FILE ID] = AGENT.AGENT_FILE_ID) INNER JOIN AMENDMENTS ON APPLICATION.[APPLICATION FILE ID] = AMENDMENTS.AMENDMENTS_FILE_ID) INNER JOIN APPLICANT ON APPLICATION.[APPLICATION FILE ID] = APPLICANT.APPLICANT_FILE_ID) INNER JOIN [APPLICATION APPRAISERS] ON APPLICATION.[APPLICATION FILE ID] = [APPLICATION APPRAISERS].APP_APPRAISERS_FILE_ID) INNER JOIN BFS ON APPLICATION.[APPLICATION FILE ID] = BFS.BFS_FILE_ID) INNER JOIN DECISIONS ON APPLICATION.[APPLICATION FILE ID] = DECISIONS.DECISIONS_FILE_ID) INNER JOIN ENQUIRY ON APPLICATION.[APPLICATION FILE ID] = ENQUIRY.ENQUIRY_FILE_ID) INNER JOIN FINANCE ON APPLICATION.[APPLICATION FILE ID] = FINANCE.FINANCE_FILE_ID) INNER JOIN GRANTS ON APPLICATION.[APPLICATION FILE ID] = GRANTS.GRANTS_FILE_ID) INNER JOIN JOBS ON APPLICATION.[APPLICATION FILE ID] = JOBS.JOBS_FILE_ID) INNER JOIN NOTES ON APPLICATION.[APPLICATION FILE ID] = NOTES.NOTES_FILE_ID) INNER JOIN PAYMENTS ON APPLICATION.[APPLICATION FILE ID] = PAYMENTS.PAYMENTS_FILE_ID) INNER JOIN STATAPPS ON APPLICATION.[APPLICATION FILE ID] = STATAPPS.STATAPPS_FILE_ID) ON [DC CODES].DISTRICT_C = APPLICATION.[DISTRICT COUNCIL];