THEO TODMAN’S WEBSITE CODE PAGES



This Page provides a jumping-off point for the VBA Code that generates my Website.

Table of Query Documentation: Query-Type = Select (446 items)

Abstract_FixAbstract_RefsAbstracts_Changed_ListAbstracts_Changed_List_AllNotes
Abstracts_Changed_List_Plus+NotesAbstracts_Changed_List_Plus+TempNotesAbstracts_Changed_List1Abstracts_Changed_List2
Abstracts_Changed_List3Abstracts_ListAbstracts_RecentActive_Notes
Active_Notes_AssociationsActive_Notes_FullAeon_AveragesAeon_Lookup
Aeon_PrioritiseAmbiguous_ObjectsArchived_Notes_FilesAuthor_Citation_Counts
Author_Letters_LatestAuthorNarrs - Search for UpdateAuthors_Cited_By_Authors_ListAuthors_Cited_By_Books_List
Authors_Cited_By_Notes_ListAuthors_Cited_By_Papers_ListAuthors_ListAuthors_List_Authors
Authors_List_ChangedAuthors_List_FixAuthors_List_LetterAuthors_List_Selected_Authors
Authors_List2Authors_SummaryAuthors_Summary (Letters)Average_Plans
Backup_Directory_Structure_ListBackup_Site_Map_ListBackup_Site_Map_SearchBlocked_Spider_Files
Book_Abstract_Quality_ListBook_Abstracts_RecentBook_Author_ListBook_Author_List_Changed
Book_Author_List_Changed1Book_Book_ListBook_Book_List_ChangedBook_Book_List_Changed_New
Book_Book_List_Changed1Book_Book_List_NewBook_Citings_List_New_ListBook_Citings_Page_List
Book_Citings_Page_List (Letters)Book_Location_RefsBook_Note_CountsBook_Note_Link_List
Book_Note_Link_List_NewBook_Note_Link_RefsBook_Paper_FilingBook_Paper_List
Book_Paper_List_ChangedBook_Paper_List_Changed_NewBook_Paper_List_Changed1Book_Paper_List_New
Book_Papers_ChangedBook_Papers_Changed_FullBook_Papers1Book_Papers3
Book_Papers4Book_Papers5Book_Papers6Book_Papers7
Book_Subject_AllBook_Subject_Topic_Subtopic_ListBook_Subject1Book_Subject2
Book_Subject3Book_SubTopic_AllBook_SubTopic1Book_SubTopic2
Book_SubTopic3Book_Summary_Changed_ListBook_Summary_Ranges_LatestBook_Summary_Refs
Book_Topic_AllBook_Topic1Book_Topic2Book_Topic3
Booklist - On OrderBooklist - Spare CopiesBookPaperAbstract_Ranges_LatestBookPaperAbstracts_List_Changed
BookPaperAbstracts_List_QueryBookPaperAbstracts_List_RangeBookPaperAbstracts_List_RegenBookPaperControl_Latest
BookPaperLinks_Ranges_LatestBooks - AllBooks - All - CategorisedBooks - All - Categorised (Titles)
Books - All - Categorised (Titles) - CounterBooks - All - Categorised (Titles) - PrelistBooks - All - Categorised (Titles) - Prelist - TopBooks - All - Categorised (Titles) - Top
Books - All - Categorised (Titles) - Top1Books - All (Letters)Books - Collections of PapersBooks - Move
Books - Papers CataloguedBooks - Papers UncataloguedBooks - ReadBooks - Recent
Books - Recent - CategorisedBooks - Recent - Categorised (Titles)Books - Recent - Categorised (Titles) - PrelistBooks - Recent (Letters)
Books Search - GeneralBooks_By_SubTopic1Books_By_SubTopic2Books_By_SubTopic3
Books_CitedBooks_from_Papers_By_SubtopicBooks_from_Papers_CitedBooks_Locations
Books_Locations (Titles)Books_Locations (Titles) - CounterBooks_Locations (Titles) - PrelistBooks_Locations (Titles) - Prelist - Top
Books_Locations (Titles) - TopBooks_Locations (Titles) - Top1Books_Nearly_ReadBooks_Versus_Papers
Books_Versus_Papers_ListBooks_Versus_Papers_List_RegenBookSummaries_Changed_ListBookSummaryCountCostLocation
Citations_CountCitations_ListCitations_List_ShortCitations_Note_Group
Code_Archive_Table_LatestCoxes_Farm_GardensCoxes_Farm_Photos_BackupCoxes_Farm_Pre_Repairs
Coxes_Farm_RepairsCross_Reference_By_YearCross_Reference_Changes_By_MonthCross_Reference_Changes_By_Year
Cross_Reference_LatestCross_Reference_MaxIDCurrent_Year_Papers_Actuals_CheckDeleted_Queries
Development_Log_CategoriesDevelopment_Log_ListDevelopment_Log_List_Complete_DateDevelopment_Log_List_Complete_Others_Category
Development_Log_List_Complete_Others_Category_RecentDevelopment_Log_List_Complete_Others_Category_Recent_PreviousDevelopment_Log_List_Complete_Own_CategoryDevelopment_Log_List_Complete_Own_Category_Recent
Development_Log_List_Complete_Own_Category_Recent_PreviousDevelopment_Log_List_Outstanding_Others_CategoryDevelopment_Log_List_Outstanding_Others_Category_Pri1Development_Log_List_Outstanding_Others_Priority
Development_Log_List_Outstanding_Own_CategoryDevelopment_Log_List_Outstanding_Own_Category_Pri1Development_Log_List_Outstanding_Own_PriorityDevelopment_Log_Search
Directory_Structure_SuffixedDodgy_PapersDud_Abstracts_BooksDud_Abstracts_Books (Letters)
Dud_Abstracts_Books_UpdateableDud_Abstracts_PapersDud_Abstracts_Papers (Letters)Dud_Abstracts_Papers_Updateable
Dud_Cross_References_This_YearDud_DevLog_DescriptionsDup_PapersDup_Papers1
Electronic ResourcesElectronic Resources (Letters)Full_Link_Same_Directory_UpdtFunctor_Descriptions_List
Home_Page_Static_Page_BackupsIdentity Papers - Abstracts - FullIdentity Papers - Abstracts - Full - SubTopicIdentity Papers - Abstracts - Full - SubTopic (Titles)
Identity Papers - Abstracts - Full (Letters)Identity Papers - Abstracts - ReadIdentity Papers - Abstracts - Read - SubTopicIdentity Papers - Abstracts - Read - SubTopic (Titles)
Identity Papers - Abstracts - Read (Letters)Identity Papers - Abstracts - Read (Updateable)Identity_Papers_SubTopic_AllIdentity_Papers_SubTopic1
Identity_Papers_SubTopic2Identity_Papers_SubTopic3Image_UsageLatest_Archives
Location_Group_IDsLocation_Supergroup_IDsMissing Priority Tasks For TimesheetMissing_Papers_For_Actuals
New_Year_Crosstab_Prime_NewYear_SubListNewSubTopics_GENNext_Qtr_PlansNote_Archive_Regen_Ranges_Latest
Note_Book_Link_Latest_Add2Note_Book_Links_ListNote_Book_Links_List (Letters)Note_Book_Links_Prelim
Note_Lengths_PINote_Links_LatestNote_ListNote_Paper_Link_Latest_Add2
Note_Paper_Links_ListNote_Paper_Links_List (Letters)Note_Paper_Links_PrelimNote_Regen_Ranges_Latest
Note_Usage_Temp_MinLevelNote_Usage_Temp_MinLevel_DupsNotes_AnimadversionsNotes_Archive_Files
Notes_Archive_Files_CheckerNotes_Archive_Files_Checker_1Notes_Archive_Files_Checker_2Notes_Archive_Files_Checker_Saved
Notes_Archive_LatestNotes_Archive_Latest_TimeNotes_Archive_ListNotes_Archive_List_Auto
Notes_Archive_List_CheckerNotes_Archive_List_IDNotes_Archive_List_ID+TimestampNotes_Autobiography
Notes_BibleNotes_BlogNotes_CarthusiansNotes_Cited_By_Authors_List
Notes_Cited_By_Books_ListNotes_Cited_By_Papers_ListNotes_ControlNotes_Essays
Notes_HeythropNotes_JumpNotes_Jump (Titles)Notes_Jump (Titles)_All
Notes_LatestNotes_List_AutoNotes_List_GroupNotes_PID
Notes_ReligionNotes_SearchNotes_StatusNotes_Supervisions
Notes_TempNotes_to_Print_Add1Notes_to_Print_ListNotes_Tractatus
Notes_WebDocsNotes_WriteUpOboe_Practice_Hours_ListPage_Regen_GEN_Test
Paper_Abstract_Ranges_LatestPaper_Author_ListPaper_Author_List_ChangedPaper_Author_List_Changed1
Paper_Book_ListPaper_Book_List_ChangedPaper_Book_List_Changed_NewPaper_Book_List_Changed1
Paper_Book_List_NewPaper_Citings_List_New_ListPaper_Citings_Page_ListPaper_Citings_Page_List (Letters)
Paper_Names_FixPaper_Note_CountsPaper_Note_Link_ListPaper_Note_Link_Refs
Paper_Paper_ListPaper_Paper_List_ChangedPaper_Paper_List_Changed_NewPaper_Paper_List_Changed1
Paper_Paper_List_NewPaper_Subject_AllPaper_Subject_Topic_Subtopic_ListPaper_Subject1
Paper_Subject2Paper_Subject3Paper_SubTopic_AllPaper_SubTopic1
Paper_SubTopic2Paper_SubTopic3Paper_Summary_Changed_ListPaper_Summary_Ranges_Latest
Paper_Summary_RefsPaper_Topic_AllPaper_Topic1Paper_Topic2
Paper_Topic3Papers - Abstracts - Author (Search)Papers - All - Categorised - SubPapers - All - Categorised - Sub (Titles)
Papers - All - Categorised - Sub (Titles) - CounterPapers - All - Categorised - Sub (Titles) - PrelistPapers - All - Categorised - Sub (Titles) - Prelist - TopPapers - All - Categorised - Sub (Titles) - Top
Papers - All - Categorised - Sub (Titles) - Top1Papers - Search for UpdatePapers_By_SubTopic1Papers_By_SubTopic2
Papers_By_SubTopic3Papers_CitedPapers_On_OrderPaperSummaries_Changed_List
PapersWithBookLinksPhilosopher's Index SearchPhilosophers_Index_List_OAPhilosophers_Index_List_OA (Letters)
Philosophy Papers - AllPhilosophy Papers - All - CategorisedPhilosophy Papers - All - Categorised - RecatPhilosophy Papers - All - Categorised (Titles)
Philosophy Papers - All - Categorised (Titles) - CounterPhilosophy Papers - All - Categorised (Titles) - PrelistPhilosophy Papers - All - Categorised (Titles) - Prelist - TopPhilosophy Papers - All - Categorised (Titles) - Solitons
Philosophy Papers - All - Categorised (Titles) - Solitons1Philosophy Papers - All - Categorised (Titles) - TopPhilosophy Papers - All - Categorised (Titles) - Top1Philosophy Papers - All - Categorised (Titles)1
Philosophy Papers - All (Letters)Photo_Type_Goup_CountsPhoto_Type_GoupingsPhotos_Raw_Excluded
Photos_Raw_Excluded_ErrorsPhotos_Raw_MultiType_ListPhotos_Raw_UsedPrecis_Web_Gen
Precis_Web_Gen (Titles)qryActualvsPlanqryAuthorsqryAuthorsBooks
qryAuthorsPapersqryBook_N+TsqryBooksqryLocations
qryNextQtrPlanqryPapersqryPaperTitlesqryPlanRestOfYear1
qryPlanRestOfYear2qrySearch_Webrefs_TableqrySubjectsqryWebRefs_Check_Manual
qryYearPlanAverageqryYearPlanAverage_NextYearqryYearPlanAverage_ThisYearqryYTDActuals
Query_Name_Fragment_ListQuery10Query11Query12
Query13Query14Query16Query17
Query19Query2Query3Query6
Query7Query8Query9Raw_Broken_Links_Counts
Raw_Broken_Links_Counts_DetailRaw_Broken_Links_Detail_ListRaw_Broken_Links_Fixed_CountsRaw_Broken_Links_Old_Counts_Detail
Recent_Notes_Books_LinksRecent_Notes_Papers_LinksReporting_PeriodsReusedQueryNames
Search_Photos_RawSpider_Audit_1Spider_Audit_2Spider_Directory_Structure_List
Spider_Missing_Internal_LinksSpider_Missing_LinksSpider_WebLink_Fix_CheckSpider_WebLink_Fix_Check_Consolidated
Spider_WebLink_Fix_Check_CountsSpider_WebLink_Fix_Check_Counts_PrelistSpider_WebLink_Full_ListSpider_Weblinks
Spider_Weblinks_Leading_SpaceSpider_Webrefs_Add_CheckstrDevelopmentsSub_Notes_Temp
Sub_Topics_ListSubject_Topic_UnclassifiedsSubjectEqualsTopicSubTopic_From_Topic1
SubTopic_From_Topic2SubTopic_From_Topic3Sub-Topics_ID_MaxThesis_Progress_Dashboard_List
This_Qtr_PlansTime_By_Language_Locations_CurrentTime_By_WeekdayTime_This_Month
Time_This_Month_Grand_Tots_NewTime_This_Month_New_FullTime_This_Month_PrelistTime_This_Month_Prelist_New
Time_This_Month_Prelist1Time_This_Month_Prelist1_NewTime_This_Month_TotsTime_This_Month_Tots_New
Timeline_CoxesFarmTimeline_Duplicate_Secondary_IDsTimeline_Second_IDsTopicEqualsSubTopic
Topics_ID_MaxUnused_QueriesUnused_VariablesVariable_Code_Name_Clashes
WebLink_Fix_Check_CountsWebLink_Fix_Check_Counts_PrelistWebLink_Fix_Check_MapWeblink_Full_List_Map
WebRefs_CodedWebRefs_DuplicatesWebRefs_Error_ListWebRefs_Error_Summary
Webrefs_To_Be_Added_By_SpiderWebrefs_To_Be_Added_By_Spider_DetailWebRefs_Translation_CheckWebsite_Regen_Last_Run_Start
Website_Regen_LatestYear_Crosstab_Prime_PeriodsYear_Crosstab_Prime_Task_GroupsYear_Crosstab_Prime_Task_Periods
Year_PlansYTD_Plans..

To access information, click on one of the links in the table above.

Go to top of page

Query_Name: Abstract_Fix
Query_Type: Select
Query_DateCreated: 30/04/2011 11:05:08
Query_DateChanged: 01/05/2011 10:30:43
Query_SQL: SELECT Books.Location, Books.ID1, Books.Author, Books.Title, Books.[Purchased?], Books.Abstract, Len([Abstract]) AS [Abstract?], IIf(InStr([Abstract],"|Colour_")>0,"Yes") AS [Coloured?] FROM Books WHERE (((Books.[Purchased?])<>"Buy?") AND ((Len([Abstract]))>0)) ORDER BY Books.Location, Books.Author;
Link To Column Definitions: Abstract_Fix

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstract_Refs
Query_Type: Select
Query_DateCreated: 23/06/2007 15:23:53
Query_DateChanged: 24/06/2007 10:46:29
Query_SQL: SELECT Papers.ID, IIf([Papers]![Abstract] & ""="" And [Papers]![Comments] & ""="","","<A HREF = ""../../Abstracts/Abstract_" & Mid(Str(100000+[ID]),3,2) & "/Abstract_" & [ID] & ".htm"">Yes</A>") AS Abstract FROM Papers;
Link To Column Definitions: Abstract_Refs

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_Changed_List
Query_Type: Select
Query_DateCreated: 08/07/2009 23:33:30
Query_DateChanged: 26/09/2014 19:58:37
Query_SQL: SELECT Abstracts_Changed_List1.ID, Abstracts_Changed_List1.Author, Abstracts_Changed_List1.Title, Abstracts_Changed_List1.Abstract, Abstracts_Changed_List1.Comments, Abstracts_Changed_List1.Source, Papers.Write_Up_Note_ID AS [Write-Up Note] FROM Abstracts_Changed_List1 INNER JOIN Papers ON Abstracts_Changed_List1.ID = Papers.ID ORDER BY Abstracts_Changed_List1.Author, Abstracts_Changed_List1.Title;
Link To Column Definitions: Abstracts_Changed_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_Changed_List_AllNotes
Query_Type: Select
Query_DateCreated: 01/02/2009 10:16:31
Query_DateChanged: 01/02/2009 10:26:10
Query_SQL: SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Abstract, Papers.Comments FROM Papers WHERE ((([Abstract] & "") Like "*+N*")) OR ((([Comments] & "") Like "*+N*")) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Abstracts_Changed_List_AllNotes

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_Changed_List_Plus+Notes
Query_Type: Select
Query_DateCreated: 11/03/2018 20:45:37
Query_DateChanged: 11/03/2018 20:45:37
Query_SQL: SELECT Abstracts_Changed_List3.ID, Abstracts_Changed_List3.Author, Abstracts_Changed_List3.Title, Abstracts_Changed_List3.Abstract, Abstracts_Changed_List3.Comments, Abstracts_Changed_List3.Source, Papers.Write_Up_Note_ID AS [Write-Up Note] FROM Abstracts_Changed_List3 INNER JOIN Papers ON Abstracts_Changed_List3.ID = Papers.ID ORDER BY Abstracts_Changed_List3.Author, Abstracts_Changed_List3.Title;
Link To Column Definitions: Abstracts_Changed_List_Plus+Notes

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_Changed_List_Plus+TempNotes
Query_Type: Select
Query_DateCreated: 02/11/2016 19:23:41
Query_DateChanged: 02/11/2016 19:25:08
Query_SQL: SELECT Abstracts_Changed_List2.ID, Abstracts_Changed_List2.Author, Abstracts_Changed_List2.Title, Abstracts_Changed_List2.Abstract, Abstracts_Changed_List2.Comments, Abstracts_Changed_List2.Source, Papers.Write_Up_Note_ID AS [Write-Up Note] FROM Abstracts_Changed_List2 INNER JOIN Papers ON Abstracts_Changed_List2.ID = Papers.ID ORDER BY Abstracts_Changed_List2.Author, Abstracts_Changed_List2.Title;
Link To Column Definitions: Abstracts_Changed_List_Plus+TempNotes

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_Changed_List1
Query_Type: Select
Query_DateCreated: 02/06/2007 19:39:00
Query_DateChanged: 02/11/2016 19:22:44
Query_SQL: SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Abstract, Papers.Comments, Papers.Source FROM Abstracts_Archive RIGHT JOIN Papers ON Abstracts_Archive.ID = Papers.ID WHERE ((([Papers]![Comments] & "")<>([Abstracts_Archive]![Comments] & ""))) OR ((([Papers]![Abstract] & "")<>([Abstracts_Archive]![Abstract] & ""))) OR ((([Papers]![Title] & "")<>([Abstracts_Archive]![Title] & ""))) OR ((([Papers]![Author] & "")<>([Abstracts_Archive]![Author] & ""))) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Abstracts_Changed_List1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_Changed_List2
Query_Type: Select
Query_DateCreated: 02/11/2016 19:21:33
Query_DateChanged: 02/11/2016 19:21:33
Query_SQL: SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Abstract, Papers.Comments, Papers.Source FROM (Abstracts_Archive RIGHT JOIN Papers ON Abstracts_Archive.ID = Papers.ID) LEFT JOIN Notes ON Papers.Write_Up_Note_ID = Notes.ID WHERE ((([Papers]![Comments] & "")<>([Abstracts_Archive]![Comments] & ""))) OR ((([Papers]![Abstract] & "")<>([Abstracts_Archive]![Abstract] & ""))) OR ((([Papers]![Title] & "")<>([Abstracts_Archive]![Title] & ""))) OR ((([Papers]![Author] & "")<>([Abstracts_Archive]![Author] & ""))) OR ((([Notes]![Status] & "")="Temp")) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Abstracts_Changed_List2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_Changed_List3
Query_Type: Select
Query_DateCreated: 11/03/2018 20:41:01
Query_DateChanged: 11/03/2018 20:42:38
Query_SQL: SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Abstract, Papers.Comments, Papers.Source FROM (Abstracts_Archive RIGHT JOIN Papers ON Abstracts_Archive.ID = Papers.ID) LEFT JOIN Notes ON Papers.Write_Up_Note_ID = Notes.ID WHERE ((([Papers]![Comments] & "")<>([Abstracts_Archive]![Comments] & ""))) OR ((([Papers]![Abstract] & "")<>([Abstracts_Archive]![Abstract] & ""))) OR ((([Papers]![Title] & "")<>([Abstracts_Archive]![Title] & ""))) OR ((([Papers]![Author] & "")<>([Abstracts_Archive]![Author] & ""))) OR ((([Papers]![Write_Up_Note_ID] & "")<>"")) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Abstracts_Changed_List3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_List
Query_Type: Select
Query_DateCreated: 28/08/2010 09:50:38
Query_DateChanged: 26/09/2014 19:59:25
Query_SQL: SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Abstract, Papers.Comments, Papers.Source, Papers.Write_Up_Note_ID AS [Write-Up Note] FROM Papers ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Abstracts_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Abstracts_Recent
Query_Type: Select
Query_DateCreated: 12/04/2011 15:12:48
Query_DateChanged: 12/04/2011 16:07:28
Query_SQL: SELECT [Papers]![Author] & " - " & [Papers]![Title] AS Paper, Papers.ID, IIf((Now()-[Timestamp])<7,1,IIf((Now()-[Timestamp])<14,2,IIf((Now()-[Timestamp])<28,4,0))) AS Period, Nz(Len([Papers]![Comments]))+Nz(Len([Papers]![Abstract])) AS [Size] FROM Papers INNER JOIN Abstracts_Archive ON Papers.ID = Abstracts_Archive.ID WHERE (((Abstracts_Archive.Timestamp)>Now()-28) AND ((Nz(Len([Papers]![Comments]))+Nz(Len([Papers]![Abstract])))>200)) ORDER BY [Papers]![Author] & " - " & [Papers]![Title];
Link To Column Definitions: Abstracts_Recent

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Active_Notes
Query_Type: Select
Query_DateCreated: 22/02/2009 17:51:01
Query_DateChanged: 12/09/2010 13:06:13
Query_SQL: SELECT Notes_List_Auto.ID FROM Notes_List_Auto LEFT JOIN Notes_Archive_Temp ON Notes_List_Auto.ID = Notes_Archive_Temp.ID WHERE (((Notes_Archive_Temp.ID) Is Not Null)) ORDER BY Notes_List_Auto.ID;
Link To Column Definitions: Active_Notes

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Active_Notes_Associations
Query_Type: Select
Query_DateCreated: 22/02/2009 18:05:22
Query_DateChanged: 22/02/2009 20:13:34
Query_SQL: SELECT Note_Links.Note_2 AS ID FROM Notes_Archive_Temp INNER JOIN Note_Links ON Notes_Archive_Temp.ID = Note_Links.Note_1 GROUP BY Note_Links.Note_2 ORDER BY Note_Links.Note_2;
Link To Column Definitions: Active_Notes_Associations

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Active_Notes_Full
Query_Type: Select
Query_DateCreated: 22/02/2009 20:15:54
Query_DateChanged: 22/02/2009 20:15:54
Query_SQL: SELECT Active_Notes_Union.ID FROM Active_Notes_Union GROUP BY Active_Notes_Union.ID;
Link To Column Definitions: Active_Notes_Full

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Aeon_Averages
Query_Type: Select
Query_DateCreated: 21/08/2017 18:57:49
Query_DateChanged: 21/08/2017 18:57:49
Query_SQL: SELECT Min(Papers.Pages) AS MinOfPages, Max(Papers.Pages) AS MaxOfPages, Avg(Papers.Pages) AS AvgOfPages, Max(Papers.[Actual - Total]) AS [MaxOfActual - Total], Avg(Papers.[Actual - Total]) AS [AvgOfActual - Total] FROM Papers WHERE (((Papers.Source) Like "*Aeon, *"));
Link To Column Definitions: Aeon_Averages

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Aeon_Lookup
Query_Type: Select
Query_DateCreated: 28/11/2019 10:01:39
Query_DateChanged: 28/11/2019 10:01:39
Query_SQL: SELECT Aeon_Files.* FROM Aeon_Files WHERE (((Aeon_Files.WebRef_ID)=[Enter WebRef ID]));
Link To Column Definitions: Aeon_Lookup

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Aeon_Prioritise
Query_Type: Select
Query_DateCreated: 30/11/2019 11:30:26
Query_DateChanged: 25/01/2020 23:01:57
Query_SQL: SELECT Aeon_Files.Priority, Aeon_Files.[Video?], Aeon_Files.WebRef_ID, Aeon_Files.Date_Created, Aeon_Files.Author_Names, Aeon_Files.Aeon_Author_Narrative, Aeon_Files.Aeon_Title, Aeon_Files.Aeon_SubTitle, Aeon_Files.Aeon_Date_Published, Aeon_Files.Aeon_Extract, Aeon_Files.See_Also, Aeon_Files.TT_Notes, Aeon_Files.Aeon_Note_ID, Aeon_Files.Identity_Note_ID, Aeon_Files.Paper_ID, Aeon_Files.[Read?], Aeon_Files.[Exclude?] FROM Aeon_Files WHERE (((Aeon_Files.Aeon_Note_ID)=1292) AND ((Aeon_Files.[Read?])=False) AND ((Aeon_Files.[Exclude?])=False)) ORDER BY Aeon_Files.Priority, Aeon_Files.[Video?], Aeon_Files.Aeon_Date_Published DESC , Aeon_Files.Date_Created DESC;
Link To Column Definitions: Aeon_Prioritise

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Ambiguous_Objects
Query_Type: Select
Query_DateCreated: 25/06/2013 13:36:32
Query_DateChanged: 25/06/2013 13:54:40
Query_SQL: SELECT Code_Table.Procedure_Name, Query_Definitions.Query_Name, Table_Definitions.Table_Name FROM (Query_Definitions RIGHT JOIN Code_Table ON Query_Definitions.Query_Name = Code_Table.Procedure_Name) LEFT JOIN Table_Definitions ON Code_Table.Procedure_Name = Table_Definitions.Table_Name WHERE (((Query_Definitions.Query_Name) Is Not Null)) OR (((Table_Definitions.Table_Name) Is Not Null)) ORDER BY Code_Table.Procedure_Name;
Link To Column Definitions: Ambiguous_Objects

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Archived_Notes_Files
Query_Type: Select
Query_DateCreated: 28/06/2014 00:46:09
Query_DateChanged: 28/06/2014 09:27:49
Query_SQL: SELECT Notes_Archive.ID, Notes_Archive.Item_Title, Notes_Archive.Item_Text, Notes_Archive.[Jump_Table?], Notes_Archive.Note_Group, Notes_Archive.Master_Note, Notes_Archive.Last_Changed, Notes_Archive.[Private?], Notes_Archive.Status, Notes_Archive.[Title?], Notes_Archive.[Respondent?], Notes_Archive.Timestamp, Notes_Archive.Frozen_Timestamp, "Notes_" & [ID] & "_" & [Timestamp] & ".htm" AS Archived_File FROM Notes_Archive;
Link To Column Definitions: Archived_Notes_Files

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Author_Citation_Counts
Query_Type: Select
Query_DateCreated: 12/12/2019 00:58:09
Query_DateChanged: 12/12/2019 11:02:54
Query_SQL: SELECT Authors.Author_Name AS Author, Count(Authors_Cited_By_All_List.Title) AS Citations FROM Authors_Cited_By_All_List INNER JOIN Authors ON Authors_Cited_By_All_List.Author_ID = Authors.Author_ID GROUP BY Authors.Author_Name ORDER BY Authors.Author_Name, Count(Authors_Cited_By_All_List.Title);
Link To Column Definitions: Author_Citation_Counts

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Author_Letters_Latest
Query_Type: Select
Query_DateCreated: 19/05/2018 21:49:05
Query_DateChanged: 19/05/2018 23:07:26
Query_SQL: SELECT "Author_Letters" AS Title, Min(Author_Letters.Latest_Author_Letter_Update) AS MinOfLatest_Author_Letter_Update FROM Author_Letters GROUP BY "Author_Letters";
Link To Column Definitions: Author_Letters_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: AuthorNarrs - Search for Update
Query_Type: Select
Query_DateCreated: 21/05/2014 22:43:17
Query_DateChanged: 06/01/2020 00:02:48
Query_SQL: SELECT Authors.Author_Name, Authors.Author_Narrative, Authors.Author_Name_Display, Authors.Author_ID FROM Authors WHERE (((Authors.Author_Name) Like "*" & [Enter String] & "*")) ORDER BY Authors.Author_Name;
Link To Column Definitions: AuthorNarrs - Search for Update

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_Cited_By_Authors_List
Query_Type: Select
Query_DateCreated: 09/09/2015 00:13:43
Query_DateChanged: 09/09/2015 00:14:28
Query_SQL: SELECT Authors.Author_Name AS Author, " N/A" AS Title, "Author" AS Medium, "" AS Display_Text, "" AS Icon, "N/A" AS [Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Author_ID FROM Authors INNER JOIN Cross_Reference ON Authors.Author_ID = Cross_Reference.Calling_ID WHERE (((Cross_Reference.Called_Type)="A") AND ((Cross_Reference.Called_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="A")) ORDER BY Authors.Author_Name, "N/A", Cross_Reference.Calling_NameRef;
Link To Column Definitions: Authors_Cited_By_Authors_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_Cited_By_Books_List
Query_Type: Select
Query_DateCreated: 09/09/2015 00:12:35
Query_DateChanged: 10/04/2020 23:59:08
Query_SQL: SELECT Books.Author, Books.Title, "Book" AS Medium, Quality_Markers.Display_Text, Quality_Markers.Icon, Books.[Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Author_ID FROM (Cross_Reference INNER JOIN Books ON Cross_Reference.Calling_ID = Books.ID1) INNER JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality WHERE (((Cross_Reference.Called_Type)="A") AND ((Cross_Reference.Called_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="B")) ORDER BY Books.Author, Books.Title, Cross_Reference.Calling_NameRef;
Link To Column Definitions: Authors_Cited_By_Books_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_Cited_By_Notes_List
Query_Type: Select
Query_DateCreated: 09/09/2015 00:15:11
Query_DateChanged: 09/09/2015 00:20:20
Query_SQL: SELECT "Todman (Theo)" AS Author, Notes.Item_Title AS Title, "Note" AS Medium, Notes.Note_Group AS Display_Text, "" AS Icon, "N/A" AS [Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Author_ID FROM Notes INNER JOIN Cross_Reference ON Notes.ID = Cross_Reference.Calling_ID WHERE (((Cross_Reference.Called_Type)="A") AND ((Cross_Reference.Calling_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="N")) ORDER BY "Todman (Theo)", "N/A", Cross_Reference.Calling_NameRef;
Link To Column Definitions: Authors_Cited_By_Notes_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_Cited_By_Papers_List
Query_Type: Select
Query_DateCreated: 09/09/2015 00:09:46
Query_DateChanged: 10/04/2020 23:59:00
Query_SQL: SELECT Papers.Author, Papers.Title, "Paper" AS Medium, Quality_Markers.Display_Text, Quality_Markers.Icon, Papers.[Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Author_ID FROM (Papers INNER JOIN Cross_Reference ON Papers.ID = Cross_Reference.Calling_ID) INNER JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality WHERE (((Cross_Reference.Called_Type)="A") AND ((Cross_Reference.Calling_Type)="P")) ORDER BY Papers.Author, Papers.Title, Cross_Reference.Calling_NameRef;
Link To Column Definitions: Authors_Cited_By_Papers_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_List
Query_Type: Select
Query_DateCreated: 02/07/2011 13:58:27
Query_DateChanged: 06/07/2011 19:19:11
Query_SQL: SELECT Authors_List1.Author_Name, Authors_List1.Author, Authors_List1.Title, Authors_List1.Pages, Authors_List1.[Read?], Authors_List1.[Further Information], Authors_List1.Book_ID, Authors_List1.Medium FROM Authors_List1 GROUP BY Authors_List1.Author_Name, Authors_List1.Author, Authors_List1.Title, Authors_List1.Pages, Authors_List1.[Read?], Authors_List1.[Further Information], Authors_List1.Book_ID, Authors_List1.Medium ORDER BY Authors_List1.Author_Name, Authors_List1.Title, Authors_List1.Pages, Authors_List1.Medium;
Link To Column Definitions: Authors_List

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_List_Authors
Query_Type: Select
Query_DateCreated: 29/05/2012 17:22:05
Query_DateChanged: 13/05/2014 22:47:04
Query_SQL: SELECT Authors_List_Authors_Table.Author_Name FROM Authors_List_Authors_Table ORDER BY Authors_List_Authors_Table.Author_Name;
Link To Column Definitions: Authors_List_Authors

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_List_Changed
Query_Type: Select
Query_DateCreated: 02/07/2011 13:56:54
Query_DateChanged: 14/01/2015 15:50:18
Query_SQL: SELECT Authors_List_Changed1.Author_Name, Authors_List_Changed1.Author, Authors_List_Changed1.Title, Authors_List_Changed1.Pages, Authors_List_Changed1.[Read?], Authors_List_Changed1.[Further Information], Authors_List_Changed1.Book_ID, Authors_List_Changed1.Medium FROM Authors_List_Changed1 GROUP BY Authors_List_Changed1.Author_Name, Authors_List_Changed1.Author, Authors_List_Changed1.Title, Authors_List_Changed1.Pages, Authors_List_Changed1.[Read?], Authors_List_Changed1.[Further Information], Authors_List_Changed1.Book_ID, Authors_List_Changed1.Author_Name, Authors_List_Changed1.Medium, Authors_List_Changed1.Title ORDER BY Authors_List_Changed1.Author_Name, Authors_List_Changed1.Medium, Authors_List_Changed1.Title;
Link To Column Definitions: Authors_List_Changed

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_List_Fix
Query_Type: Select
Query_DateCreated: 23/07/2013 08:26:57
Query_DateChanged: 11/12/2014 17:13:31
Query_SQL: SELECT Papers.Location, Books.[Author & Title], Authors_List1.Author_Name, Authors_List1.Title, Authors_List1.Book_ID FROM (Authors_List1 LEFT JOIN Papers ON Authors_List1.Book_ID = Papers.ID) LEFT JOIN Books ON Papers.Book_ID = Books.ID1 WHERE (((Authors_List1.Medium)="Paper") AND ((InStr([Author_Name],"("))=0)) GROUP BY Papers.Location, Books.[Author & Title], Authors_List1.Author_Name, Authors_List1.Title, Authors_List1.Book_ID HAVING (((Papers.Location)>"Library (Right) - 4,7")) ORDER BY Papers.Location, Books.[Author & Title], Authors_List1.Author_Name, Authors_List1.Title;
Link To Column Definitions: Authors_List_Fix

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_List_Letter
Query_Type: Select
Query_DateCreated: 04/09/2012 10:30:13
Query_DateChanged: 14/01/2015 15:47:35
Query_SQL: SELECT Authors_List_Letter_Table.Author_Name, Authors_List_Letter_Table.Author, Authors_List_Letter_Table.Title, Authors_List_Letter_Table.Pages, Authors_List_Letter_Table.[Read?], Authors_List_Letter_Table.[Further Information], Authors_List_Letter_Table.Book_ID, Authors_List_Letter_Table.Medium FROM Authors_List_Letter_Table GROUP BY Authors_List_Letter_Table.Author_Name, Authors_List_Letter_Table.Author, Authors_List_Letter_Table.Title, Authors_List_Letter_Table.Pages, Authors_List_Letter_Table.[Read?], Authors_List_Letter_Table.[Further Information], Authors_List_Letter_Table.Book_ID, Authors_List_Letter_Table.Author_Name, Authors_List_Letter_Table.Medium, Authors_List_Letter_Table.Title ORDER BY Authors_List_Letter_Table.Author_Name, Authors_List_Letter_Table.Medium, Authors_List_Letter_Table.Title;
Link To Column Definitions: Authors_List_Letter

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_List_Selected_Authors
Query_Type: Select
Query_DateCreated: 12/10/2013 19:21:54
Query_DateChanged: 11/01/2020 13:16:11
Query_SQL: SELECT Author_Parameter.Author_Parameter AS Author_Name, Authors_List1.Author, Authors_List1.Title, Authors_List1.Pages, Authors_List1.[Read?], Authors_List1.[Further Information], Authors_List1.Book_ID, Authors_List1.Medium FROM Author_Parameter LEFT JOIN Authors_List1 ON Author_Parameter.Author_Parameter = Authors_List1.Author_Name GROUP BY Author_Parameter.Author_Parameter, Authors_List1.Author, Authors_List1.Title, Authors_List1.Pages, Authors_List1.[Read?], Authors_List1.[Further Information], Authors_List1.Book_ID, Authors_List1.Medium, Authors_List1.Author_Name, Authors_List1.Title ORDER BY Author_Parameter.Author_Parameter, Authors_List1.Medium, Authors_List1.Author_Name, Authors_List1.Title;
Link To Column Definitions: Authors_List_Selected_Authors

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_List2
Query_Type: Select
Query_DateCreated: 25/09/2013 15:48:46
Query_DateChanged: 25/09/2013 15:50:12
Query_SQL: SELECT Authors_List1.Author_Name, Authors_List1.Author, Authors_List1.Title, Authors_List1.Pages, Authors_List1.[Read?], Authors_List1.[Further Information], Authors_List1.Book_ID, Authors_List1.Medium, UCase(Left([Author_Name],1)) AS Authors_List_Initial FROM Authors_List1;
Link To Column Definitions: Authors_List2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_Summary
Query_Type: Select
Query_DateCreated: 30/12/2014 18:58:07
Query_DateChanged: 10/04/2020 00:29:22
Query_SQL: SELECT Authors.Author_Name AS Author, IIf([Authors]![Author_Narrative] & ""="","&nbsp;","Yes") AS [Author's Abstract?], IIf([Author_Book_Count]=0,"&nbsp",[Author_Book_Count]) AS [Book Count], IIf([Author_Paper_Count]=0,"&nbsp",[Author_Paper_Count]) AS [Paper Count], IIf([Author_Citation_Count]=0,"&nbsp",[Author_Citation_Count]) AS [Citation Count] FROM Authors ORDER BY Authors.Author_Name;
Link To Column Definitions: Authors_Summary

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Authors_Summary (Letters)
Query_Type: Select
Query_DateCreated: 30/12/2014 19:19:39
Query_DateChanged: 30/12/2014 19:19:39
Query_SQL: SELECT Author_Letters.Author_Letter FROM Author_Letters;
Link To Column Definitions: Authors_Summary (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Average_Plans
Query_Type: Select
Query_DateCreated: 09/04/2013 18:07:56
Query_DateChanged: 13/06/2020 00:37:32
Query_SQL: SELECT Next_Qtr_Plans.Project, This_Qtr_Plans.[Average This Qtr Plan], Next_Qtr_Plans.[Average Next Qtr Plan], YTD_Plans.[Average YTD Plan], Year_Plans.[Average Year Plan], Reporting_Periods.* FROM Reporting_Periods, ((Next_Qtr_Plans INNER JOIN This_Qtr_Plans ON Next_Qtr_Plans.Project = This_Qtr_Plans.Project) INNER JOIN Year_Plans ON This_Qtr_Plans.Project = Year_Plans.Project) INNER JOIN YTD_Plans ON Year_Plans.Project = YTD_Plans.Project ORDER BY Next_Qtr_Plans.Project;
Link To Column Definitions: Average_Plans

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Backup_Directory_Structure_List
Query_Type: Select
Query_DateCreated: 17/05/2014 22:28:43
Query_DateChanged: 07/06/2014 10:17:28
Query_SQL: SELECT Backup_Directory_Structure.Directory, Backup_Control.Input_Root FROM Backup_Directory_Structure, Backup_Control ORDER BY Backup_Directory_Structure.Directory;
Link To Column Definitions: Backup_Directory_Structure_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Backup_Site_Map_List
Query_Type: Select
Query_DateCreated: 06/06/2014 22:35:52
Query_DateChanged: 06/06/2014 22:36:30
Query_SQL: SELECT [Directory] & [FIle_Name] AS Backup_Site_Map_Object, Backup_Site_Map.File_Timestamp FROM Backup_Site_Map;
Link To Column Definitions: Backup_Site_Map_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Backup_Site_Map_Search
Query_Type: Select
Query_DateCreated: 25/10/2018 09:48:33
Query_DateChanged: 25/10/2018 09:48:33
Query_SQL: SELECT Backup_Site_Map.*, Backup_Site_Map.FIle_Name FROM Backup_Site_Map WHERE (((Backup_Site_Map.FIle_Name) Like "*" & [Enter String] & "*"));
Link To Column Definitions: Backup_Site_Map_Search

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Blocked_Spider_Files
Query_Type: Select
Query_DateCreated: 27/06/2013 15:48:04
Query_DateChanged: 14/04/2014 17:52:57
Query_SQL: SELECT Site_Map.Directory, Site_Map.FIle_Name, Site_Map.Timestamp_Logged, Site_Map.Size, Site_Map.Block_Update, Site_Map.Time_To_Update, Site_Map.Full_File_Name, Site_Map.File_Timestamp FROM Site_Map WHERE (((Site_Map.Block_Update)="Yes")) ORDER BY Site_Map.Directory, Site_Map.FIle_Name;
Link To Column Definitions: Blocked_Spider_Files

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Abstract_Quality_List
Query_Type: Select
Query_DateCreated: 10/04/2009 20:12:45
Query_DateChanged: 10/04/2009 22:14:07
Query_SQL: SELECT Books.ID1, "<img src=""" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">" AS [Image] FROM Books INNER JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality;
Link To Column Definitions: Book_Abstract_Quality_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Abstracts_Recent
Query_Type: Select
Query_DateCreated: 12/04/2011 17:09:32
Query_DateChanged: 23/05/2014 15:02:25
Query_SQL: SELECT [Author] & " - " & [Title] AS Book, Book_Abstracts_Archive.ID1, IIf((Now()-[Timestamp])<7,1,IIf((Now()-[Timestamp])<14,2,IIf((Now()-[Timestamp])<28,4,0))) AS Period, Nz(Len([Comments]))+Nz(Len([Abstract])) AS [Size] FROM Book_Abstracts_Archive WHERE (((Nz(Len([Comments]))+Nz(Len([Abstract])))>250) AND ((Book_Abstracts_Archive.Timestamp)>Now()-28)) ORDER BY [Author] & " - " & [Title];
Link To Column Definitions: Book_Abstracts_Recent

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Author_List
Query_Type: Select
Query_DateCreated: 25/06/2011 21:00:22
Query_DateChanged: 10/04/2020 23:57:20
Query_SQL: SELECT Author_Book_Links.Author AS Author_Name, Author_Book_Links.Book_Author AS Author, Books.Title, Books.Pages, IIf([Books]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Books.ID1 AS Book_ID, "Book" AS Medium FROM (Author_Book_Links INNER JOIN Books ON Author_Book_Links.Book_ID1 = Books.ID1) LEFT JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality GROUP BY Author_Book_Links.Author, Author_Book_Links.Book_Author, Books.Title, Books.Pages, IIf([Books]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Books.ID1, "Book" ORDER BY Author_Book_Links.Author, Books.Title;
Link To Column Definitions: Book_Author_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Author_List_Changed
Query_Type: Select
Query_DateCreated: 26/06/2011 18:18:22
Query_DateChanged: 28/06/2011 10:34:42
Query_SQL: SELECT Book_Author_List.Author_Name, Book_Author_List.Author, Book_Author_List.Title, Book_Author_List.Pages, Book_Author_List.[Read?], Book_Author_List.[Further Information], Book_Author_List.Book_ID, Book_Author_List.Medium FROM Authors_Changed INNER JOIN Book_Author_List ON Authors_Changed.Author_Name = Book_Author_List.Author_Name;
Link To Column Definitions: Book_Author_List_Changed

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Author_List_Changed1
Query_Type: Select
Query_DateCreated: 28/06/2011 10:16:03
Query_DateChanged: 29/07/2013 11:08:31
Query_SQL: SELECT Author_Book_Links.Author AS Author_Name FROM Author_Book_Links, System_Parameters WHERE (((Author_Book_Links.Timestamp)>Now()-[Author_Change_Days])) GROUP BY Author_Book_Links.Author;
Link To Column Definitions: Book_Author_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Book_List
Query_Type: Select
Query_DateCreated: 26/06/2011 22:34:56
Query_DateChanged: 26/06/2011 23:01:56
Query_SQL: SELECT Book_Book_Links.Book_ID, Books.Author, Books.Title, Books.Pages, IIf([Books]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Book_Book_Links.Book_ID1 AS Object_ID, "Book" AS Medium FROM Book_Book_Links INNER JOIN (Books LEFT JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality) ON Book_Book_Links.Book_ID1 = Books.ID1 GROUP BY Book_Book_Links.Book_ID, Books.Author, Books.Title, Books.Pages, IIf([Books]![Read?]=True,"Yes","No"), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Book_Book_Links.Book_ID1, "Book" ORDER BY Book_Book_Links.Book_ID;
Link To Column Definitions: Book_Book_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Book_List_Changed
Query_Type: Select
Query_DateCreated: 27/06/2011 11:55:23
Query_DateChanged: 28/06/2011 12:01:11
Query_SQL: SELECT Book_Book_List.Book_ID, Book_Book_List.Author, Book_Book_List.Title, Book_Book_List.Pages, Book_Book_List.[Read?], Book_Book_List.[Further Information], Book_Book_List.Object_ID, Book_Book_List.Medium FROM Book_Citings_List_Changed1 INNER JOIN Book_Book_List ON Book_Citings_List_Changed1.Book_ID = Book_Book_List.Book_ID ORDER BY Book_Book_List.Book_ID, Book_Book_List.Author, Book_Book_List.Title;
Link To Column Definitions: Book_Book_List_Changed

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Book_List_Changed_New
Query_Type: Select
Query_DateCreated: 28/08/2015 19:01:16
Query_DateChanged: 28/08/2015 19:02:16
Query_SQL: SELECT Book_Book_List_New.Book_ID, Book_Book_List_New.Author, Book_Book_List_New.Title, Book_Book_List_New.Pages, Book_Book_List_New.[Read?], Book_Book_List_New.[Further Information], Book_Book_List_New.Object_ID, Book_Book_List_New.Medium, Book_Book_List_New.Calling_NameRef FROM Book_Citings_List_Changed1 INNER JOIN Book_Book_List_New ON Book_Citings_List_Changed1.Book_ID = Book_Book_List_New.Book_ID ORDER BY Book_Book_List_New.Book_ID, Book_Book_List_New.Author, Book_Book_List_New.Title;
Link To Column Definitions: Book_Book_List_Changed_New

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Book_List_Changed1
Query_Type: Select
Query_DateCreated: 28/06/2011 11:52:58
Query_DateChanged: 28/06/2011 11:54:20
Query_SQL: SELECT Book_Book_List.Book_ID FROM Book_Summary_Changed_List INNER JOIN Book_Book_List ON Book_Summary_Changed_List.ID1 = Book_Book_List.Object_ID GROUP BY Book_Book_List.Book_ID ORDER BY Book_Book_List.Book_ID;
Link To Column Definitions: Book_Book_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Book_List_New
Query_Type: Select
Query_DateCreated: 28/08/2015 15:27:17
Query_DateChanged: 28/08/2018 16:46:05
Query_SQL: SELECT Cross_Reference.Called_ID AS Book_ID, Books.Author, Books.Title, Books.Pages, IIf([Books]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Cross_Reference.Calling_ID AS Object_ID, "Book" AS Medium, Cross_Reference.Calling_NameRef FROM Cross_Reference INNER JOIN (Books LEFT JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality) ON Cross_Reference.Calling_ID = Books.ID1 WHERE (((Cross_Reference.Called_Type)="B") AND ((Cross_Reference.Calling_Type)="B")) GROUP BY Cross_Reference.Called_ID, Books.Author, Books.Title, Books.Pages, IIf([Books]![Read?]=True,"Yes","No"), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Cross_Reference.Calling_ID, "Book", Cross_Reference.Calling_NameRef ORDER BY Cross_Reference.Called_ID;
Link To Column Definitions: Book_Book_List_New

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Citings_List_New_List
Query_Type: Select
Query_DateCreated: 11/07/2020 23:35:33
Query_DateChanged: 11/07/2020 23:35:33
Query_SQL: SELECT Book_Citings_List_New.Book_ID, Book_Citings_List_New.Author, Book_Citings_List_New.Title, Book_Citings_List_New.Pages, Book_Citings_List_New.[Read?], Book_Citings_List_New.[Further Information], Book_Citings_List_New.Object_ID, Book_Citings_List_New.Medium, Book_Citings_List_New.Calling_NameRef FROM Book_Citings_List_New ORDER BY Book_Citings_List_New.Book_ID, Book_Citings_List_New.Author, Book_Citings_List_New.Title, Book_Citings_List_New.Calling_NameRef;
Link To Column Definitions: Book_Citings_List_New_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Citings_Page_List
Query_Type: Select
Query_DateCreated: 15/06/2014 15:59:18
Query_DateChanged: 28/08/2015 18:31:39
Query_SQL: SELECT Books.Author, Books.Title, "<a href= ""BookSummaries/BookSummary_" & Mid([ID1]+100000,2,2) & "/BookCitings_" & [ID1] & ".htm"">" & "Link</a>" AS [Citings Link] FROM Book_Citings_List_New INNER JOIN Books ON Book_Citings_List_New.Book_ID = Books.ID1 GROUP BY Books.Author, Books.Title, "<a href= ""BookSummaries/BookSummary_" & Mid([ID1]+100000,2,2) & "/BookCitings_" & [ID1] & ".htm"">" & "Link</a>" ORDER BY Books.Author, Books.Title;
Link To Column Definitions: Book_Citings_Page_List

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Citings_Page_List (Letters)
Query_Type: Select
Query_DateCreated: 15/06/2014 15:59:37
Query_DateChanged: 15/06/2014 16:00:46
Query_SQL: SELECT Left([Author],1) AS Letter FROM Book_Citings_Page_List GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Book_Citings_Page_List (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Location_Refs
Query_Type: Select
Query_DateCreated: 13/09/2013 13:03:39
Query_DateChanged: 13/09/2013 13:43:05
Query_SQL: SELECT Books.ID1, "<A HREF = ""BookSummaries/BookSummary_" & Mid(Str(100000+[Books]![ID1]),3,2) & "/BooksToPapers_" & [Books]![ID1] & ".htm"">Papers</A>" & IIf([Book_Abstract_Quality_List]![ID1] & ""<>"","<br><A HREF = ""BookSummaries/BookSummary_" & Mid(Str(100000+[Books]![ID1]),3,2) & "/BookPaperAbstracts/BookPaperAbstracts_" & [Books]![ID1] & ".htm"">Summary</A>" & [Image],"") AS Book_Summary FROM Books LEFT JOIN Book_Abstract_Quality_List ON Books.ID1 = Book_Abstract_Quality_List.ID1;
Link To Column Definitions: Book_Location_Refs

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Note_Counts
Query_Type: Select
Query_DateCreated: 28/01/2009 09:14:45
Query_DateChanged: 25/07/2010 19:49:02
Query_SQL: SELECT Note_Book_Links.Book, Count(Note_Book_Links.Note) AS CountOfNote FROM Note_Book_Links WHERE (((Note_Book_Links.Origin)="Note")) GROUP BY Note_Book_Links.Book ORDER BY Note_Book_Links.Book;
Link To Column Definitions: Book_Note_Counts

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Note_Link_List
Query_Type: Select
Query_DateCreated: 23/07/2020 19:19:48
Query_DateChanged: 23/07/2020 19:22:08
Query_SQL: SELECT Books.ID1 AS Book_ID, Notes.ID AS [Note ID], Books.Author AS [Book Author], Books.Title AS [Book Title], IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]) AS [Note], Note_Groups.Note_Group AS [Note Group], IIf([Live_Note?]=0,Year(Int([Notes]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes]![Last_Changed]/1000))+100,2),Year(Int([Notes_Archive]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes_Archive]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes_Archive]![Last_Changed]/1000))+100,2)) AS [Date Last Changed], Cross_Reference.Calling_Timestamp, Cross_Reference.Calling_NameRef FROM (((Cross_Reference INNER JOIN (Notes INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID) ON Cross_Reference.Calling_ID = Notes.ID) INNER JOIN Cross_Reference_Prelims ON (Cross_Reference.Called_ID = Cross_Reference_Prelims.Called_ID) AND (Cross_Reference.Called_Type = Cross_Reference_Prelims.Called_Type) AND (Cross_Reference.Calling_Type = Cross_Reference_Prelims.Calling_Type) AND (Cross_Reference.Calling_ID = Cross_Reference_Prelims.Calling_ID)) INNER JOIN Notes_Archive ON (Cross_Reference_Prelims.Latest_Archive_Note = Notes_Archive.Timestamp) AND (Cross_Reference_Prelims.Calling_ID = Notes_Archive.ID)) INNER JOIN Books ON Cross_Reference.Called_ID = Books.ID1 WHERE (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B") AND ((Cross_Reference_Prelims.[Live_Note?])=0) AND ((Cross_Reference.Calling_Timestamp)=0)) OR (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B") AND ((Cross_Reference_Prelims.[Live_Note?])=1) AND ((Cross_Reference.Calling_Timestamp)=[Latest_Archive_Note])) GROUP BY Books.ID1, Notes.ID, Books.Author, Books.Title, IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]), Note_Groups.Note_Group, IIf([Live_Note?]=0,Year(Int([Notes]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes]![Last_Changed]/1000))+100,2),Year(Int([Notes_Archive]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes_Archive]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes_Archive]![Last_Changed]/1000))+100,2)), Cross_Reference.Calling_Timestamp, Cross_Reference.Calling_NameRef ORDER BY Books.ID1, Books.Author, Books.Title, IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]);
Link To Column Definitions: Book_Note_Link_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Note_Link_List_New
Query_Type: Select
Query_DateCreated: 31/08/2015 23:20:13
Query_DateChanged: 31/08/2015 23:32:02
Query_SQL: SELECT Books.ID1 AS Book_ID, Notes.ID AS [Note ID], Books.Author AS [Book Author], Books.Title AS [Book Title], IIf([Notes_Archive]![Item_Title] & ""="",[Notes]![Item_Title],[Notes_Archive]![Item_Title]) AS [Note], Note_Groups.Note_Group AS [Note Group], IIf([Notes_Archive]![Last_Changed] & ""="",Year(Int([Notes]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes]![Last_Changed]/1000))+100,2),Year(Int([Notes_Archive]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes_Archive]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes_Archive]![Last_Changed]/1000))+100,2)) AS [Date Last Changed], Cross_Reference.Calling_Timestamp, Cross_Reference.Calling_NameRef FROM (((Cross_Reference LEFT JOIN Notes_Archive_Latest_Time ON (Cross_Reference.Calling_Timestamp = Notes_Archive_Latest_Time.MaxOfTimestamp) AND (Cross_Reference.Calling_ID = Notes_Archive_Latest_Time.ID)) INNER JOIN (Notes INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID) ON Cross_Reference.Calling_ID = Notes.ID) LEFT JOIN Notes_Archive ON (Cross_Reference.Calling_Timestamp = Notes_Archive.Timestamp) AND (Cross_Reference.Calling_ID = Notes_Archive.ID)) INNER JOIN Books ON Cross_Reference.Called_ID = Books.ID1 WHERE (((Notes_Archive_Latest_Time.MaxOfTimestamp) Is Null Or (Notes_Archive_Latest_Time.MaxOfTimestamp)=[Cross_Reference]![Calling_Timestamp]) AND ((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B")) GROUP BY Books.ID1, Notes.ID, Books.Author, Books.Title, IIf([Notes_Archive]![Item_Title] & ""="",[Notes]![Item_Title],[Notes_Archive]![Item_Title]), Note_Groups.Note_Group, IIf([Notes_Archive]![Last_Changed] & ""="",Year(Int([Notes]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes]![Last_Changed]/1000))+100,2),Year(Int([Notes_Archive]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes_Archive]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes_Archive]![Last_Changed]/1000))+100,2)), Cross_Reference.Calling_Timestamp, Cross_Reference.Calling_NameRef, IIf([Cross_Reference]![Calling_Timestamp]=0,[Notes]![Last_Changed]+1,[Cross_Reference]![Calling_Timestamp]), Cross_Reference.Calling_Timestamp ORDER BY Books.ID1, Books.Author, Books.Title, IIf([Notes_Archive]![Item_Title] & ""="",[Notes]![Item_Title],[Notes_Archive]![Item_Title]), IIf([Cross_Reference]![Calling_Timestamp]=0,[Notes]![Last_Changed]+1,[Cross_Reference]![Calling_Timestamp]) DESC;
Link To Column Definitions: Book_Note_Link_List_New

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Note_Link_Refs
Query_Type: Select
Query_DateCreated: 29/03/2014 17:50:15
Query_DateChanged: 30/03/2014 19:12:31
Query_SQL: SELECT Books.ID1, "<A HREF = ""BookSummaries/BookSummary_" & Mid(Str(100000+[Books]![ID1]),3,2) & "/BooksToNotes_" & [Books]![ID1] & ".htm"">Link</A>" AS BooksToNoteLink FROM Books;
Link To Column Definitions: Book_Note_Link_Refs

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Paper_Filing
Query_Type: Select
Query_DateCreated: 14/05/2013 15:21:54
Query_DateChanged: 10/12/2013 11:42:32
Query_SQL: SELECT Papers.Book_ID, Papers.Author, Papers.Title, Papers.Comments, Papers.Source, Papers.ID FROM (Papers INNER JOIN Books ON Papers.Book_ID = Books.ID1) INNER JOIN Locations ON Books.Location = Locations.Location WHERE (((Locations.[Moving?])=Yes)) ORDER BY Books.[Author & Title], Papers.Author, Papers.Title;
Link To Column Definitions: Book_Paper_Filing

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Paper_List
Query_Type: Select
Query_DateCreated: 26/06/2011 22:49:09
Query_DateChanged: 26/06/2011 22:59:41
Query_SQL: SELECT Paper_Book_Links.Book_ID, Papers.Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Paper_Book_Links.Paper_ID AS Object_ID, "Paper" AS Medium FROM (Paper_Book_Links INNER JOIN Papers ON Paper_Book_Links.Paper_ID = Papers.ID) LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality GROUP BY Paper_Book_Links.Book_ID, Papers.Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=True,"Yes","No"), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Paper_Book_Links.Paper_ID, "Paper" ORDER BY Paper_Book_Links.Book_ID;
Link To Column Definitions: Book_Paper_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Paper_List_Changed
Query_Type: Select
Query_DateCreated: 27/06/2011 11:57:31
Query_DateChanged: 28/06/2011 11:59:36
Query_SQL: SELECT Book_Paper_List.Book_ID, Book_Paper_List.Author, Book_Paper_List.Title, Book_Paper_List.Pages, Book_Paper_List.[Read?], Book_Paper_List.[Further Information], Book_Paper_List.Object_ID, Book_Paper_List.Medium FROM Book_Citings_List_Changed1 INNER JOIN Book_Paper_List ON Book_Citings_List_Changed1.Book_ID = Book_Paper_List.Book_ID ORDER BY Book_Paper_List.Book_ID, Book_Paper_List.Author, Book_Paper_List.Title;
Link To Column Definitions: Book_Paper_List_Changed

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Paper_List_Changed_New
Query_Type: Select
Query_DateCreated: 28/08/2015 18:59:30
Query_DateChanged: 28/08/2015 18:59:43
Query_SQL: SELECT Book_Paper_List_New.Book_ID, Book_Paper_List_New.Author, Book_Paper_List_New.Title, Book_Paper_List_New.Pages, Book_Paper_List_New.[Read?], Book_Paper_List_New.[Further Information], Book_Paper_List_New.Object_ID, Book_Paper_List_New.Medium, Book_Paper_List_New.Calling_NameRef FROM Book_Citings_List_Changed1 INNER JOIN Book_Paper_List_New ON Book_Citings_List_Changed1.Book_ID = Book_Paper_List_New.Book_ID ORDER BY Book_Paper_List_New.Book_ID, Book_Paper_List_New.Author, Book_Paper_List_New.Title;
Link To Column Definitions: Book_Paper_List_Changed_New

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Paper_List_Changed1
Query_Type: Select
Query_DateCreated: 28/06/2011 11:55:08
Query_DateChanged: 28/06/2011 11:55:32
Query_SQL: SELECT Book_Paper_List.Book_ID FROM Paper_Summary_Changed_List INNER JOIN Book_Paper_List ON Paper_Summary_Changed_List.ID = Book_Paper_List.Object_ID GROUP BY Book_Paper_List.Book_ID ORDER BY Book_Paper_List.Book_ID;
Link To Column Definitions: Book_Paper_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Paper_List_New
Query_Type: Select
Query_DateCreated: 28/08/2015 16:11:38
Query_DateChanged: 28/08/2015 16:17:49
Query_SQL: SELECT Cross_Reference.[Called_ID] AS Book_ID, Papers.Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Cross_Reference.Calling_ID AS Object_ID, "Paper" AS Medium, Cross_Reference.Calling_NameRef FROM Cross_Reference INNER JOIN (Papers LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality) ON Cross_Reference.Calling_ID = Papers.ID WHERE (((Cross_Reference.Calling_Type)="P") AND ((Cross_Reference.Called_Type)="B")) GROUP BY Cross_Reference.[Called_ID], Papers.Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=True,"Yes","No"), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Cross_Reference.Calling_ID, "Paper", Cross_Reference.Calling_NameRef ORDER BY Cross_Reference.[Called_ID];
Link To Column Definitions: Book_Paper_List_New

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Papers_Changed
Query_Type: Select
Query_DateCreated: 22/02/2009 16:05:38
Query_DateChanged: 20/06/2012 12:29:29
Query_SQL: SELECT Book_Papers3.Book_ID FROM Papers INNER JOIN (Books INNER JOIN (Book_Papers3 LEFT JOIN Book_Papers_Full ON (Book_Papers3.Paper_ID = Book_Papers_Full.Paper_ID) AND (Book_Papers3.Book_ID = Book_Papers_Full.Book_ID)) ON Books.ID1 = Book_Papers3.Book_ID) ON Papers.ID = Book_Papers3.Paper_ID WHERE (((Book_Papers_Full.Paper_ID) Is Null)) OR (((Book_Papers_Full.Sequence)<>[Papers]![Sequence])) OR (((Book_Papers_Full.Book_Author_Title)<>[Author & Title])) OR (((Book_Papers_Full.Paper_Author_Title)<>([Papers]![Author] & " - " & [Papers]![Title]))) OR (((Book_Papers_Full.Paper_Abstract_Quality)<>[Papers]![Abstract_Quality])) OR (((Book_Papers_Full.Paper_Pages)<>[Papers]![Pages])) OR (((Book_Papers_Full.Hours_Left)<>[Papers]![Hours Left])) OR (((Book_Papers_Full.Paper_Abstract_Length)<>Len([Papers]![Abstract] & "")+Len([Papers]![Comments] & "")+0)) GROUP BY Book_Papers3.Book_ID;
Link To Column Definitions: Book_Papers_Changed

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Papers_Changed_Full
Query_Type: Select
Query_DateCreated: 11/04/2009 09:16:06
Query_DateChanged: 11/04/2009 09:44:30
Query_SQL: SELECT Books.ID1 AS Book_ID FROM Books;
Link To Column Definitions: Book_Papers_Changed_Full

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Papers1
Query_Type: Select
Query_DateCreated: 26/01/2009 19:53:22
Query_DateChanged: 28/06/2011 18:00:13
Query_SQL: SELECT Paper_Books.Book_ID, Paper_Books.ID AS Paper_ID, Paper_Books.Timestamp FROM Paper_Books;
Link To Column Definitions: Book_Papers1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Papers3
Query_Type: Select
Query_DateCreated: 26/01/2009 19:56:05
Query_DateChanged: 10/02/2009 20:03:13
Query_SQL: SELECT Book_Papers2.Book_ID, Book_Papers2.Paper_ID FROM Book_Papers2 GROUP BY Book_Papers2.Book_ID, Book_Papers2.Paper_ID;
Link To Column Definitions: Book_Papers3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Papers4
Query_Type: Select
Query_DateCreated: 10/02/2009 19:53:54
Query_DateChanged: 10/02/2009 19:53:54
Query_SQL: SELECT Book_Papers3.Book_ID, Papers.Author FROM Book_Papers3 INNER JOIN Papers ON Book_Papers3.Paper_ID = Papers.ID GROUP BY Book_Papers3.Book_ID, Papers.Author ORDER BY Book_Papers3.Book_ID;
Link To Column Definitions: Book_Papers4

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Papers5
Query_Type: Select
Query_DateCreated: 10/02/2009 19:55:35
Query_DateChanged: 10/02/2009 19:55:35
Query_SQL: SELECT Book_Papers4.Book_ID, Count(Book_Papers4.Author) AS CountAuthors FROM Book_Papers4 GROUP BY Book_Papers4.Book_ID;
Link To Column Definitions: Book_Papers5

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Papers6
Query_Type: Select
Query_DateCreated: 28/02/2009 16:44:02
Query_DateChanged: 28/02/2009 16:46:18
Query_SQL: SELECT Book_Papers3.Book_ID, Papers.Sequence FROM Book_Papers3 INNER JOIN Papers ON Book_Papers3.Paper_ID = Papers.ID GROUP BY Book_Papers3.Book_ID, Papers.Sequence ORDER BY Book_Papers3.Book_ID;
Link To Column Definitions: Book_Papers6

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Papers7
Query_Type: Select
Query_DateCreated: 28/02/2009 16:47:42
Query_DateChanged: 28/02/2009 16:47:50
Query_SQL: SELECT Book_Papers6.Book_ID, Count(Book_Papers6.Sequence) AS CountSequences FROM Book_Papers6 GROUP BY Book_Papers6.Book_ID;
Link To Column Definitions: Book_Papers7

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Subject_All
Query_Type: Select
Query_DateCreated: 12/04/2009 14:49:17
Query_DateChanged: 12/04/2009 14:49:53
Query_SQL: SELECT Book_Subject_Union.ID1, Book_Subject_Union.Subject FROM Book_Subject_Union GROUP BY Book_Subject_Union.ID1, Book_Subject_Union.Subject;
Link To Column Definitions: Book_Subject_All

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Subject_Topic_Subtopic_List
Query_Type: Select
Query_DateCreated: 12/04/2009 16:39:50
Query_DateChanged: 24/09/2013 19:16:33
Query_SQL: SELECT Book_Subject_All.ID1, Book_Subject_All.Subject, Book_Topic_All.Topic, IIf([Topic_ID] Is Null,[Book_SubTopic_All]![Sub-Topic],IIf([Book_SubTopic_All]![Sub-Topic]=[Sub-Topic_ID],498,[Book_SubTopic_All]![Sub-Topic])) AS [Sub-Topic] FROM ((Book_Subject_All INNER JOIN Book_SubTopic_All ON Book_Subject_All.ID1 = Book_SubTopic_All.ID1) INNER JOIN Book_Topic_All ON Book_SubTopic_All.ID1 = Book_Topic_All.ID1) LEFT JOIN TopicEqualsSubTopic ON Book_SubTopic_All.[Sub-Topic] = TopicEqualsSubTopic.[Sub-Topic_ID];
Link To Column Definitions: Book_Subject_Topic_Subtopic_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Subject1
Query_Type: Select
Query_DateCreated: 12/04/2009 14:42:33
Query_DateChanged: 12/04/2009 14:43:44
Query_SQL: SELECT Books.ID1, Books.Subject FROM Books WHERE (((Books.Subject) Is Not Null));
Link To Column Definitions: Book_Subject1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Subject2
Query_Type: Select
Query_DateCreated: 12/04/2009 14:43:53
Query_DateChanged: 12/04/2009 14:44:13
Query_SQL: SELECT Books.ID1, Books.Subject2 AS Subject FROM Books WHERE (((Books.Subject2) Is Not Null));
Link To Column Definitions: Book_Subject2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Subject3
Query_Type: Select
Query_DateCreated: 12/04/2009 14:44:25
Query_DateChanged: 12/04/2009 14:44:38
Query_SQL: SELECT Books.ID1, Books.Subject3 AS Subject FROM Books WHERE (((Books.Subject3) Is Not Null));
Link To Column Definitions: Book_Subject3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_SubTopic_All
Query_Type: Select
Query_DateCreated: 12/04/2009 16:29:26
Query_DateChanged: 12/04/2009 16:36:27
Query_SQL: SELECT Book_SubTopic_Union.ID1, Book_SubTopic_Union.[Sub-Topic] FROM Book_SubTopic_Union GROUP BY Book_SubTopic_Union.ID1, Book_SubTopic_Union.[Sub-Topic];
Link To Column Definitions: Book_SubTopic_All

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_SubTopic1
Query_Type: Select
Query_DateCreated: 12/04/2009 16:26:06
Query_DateChanged: 12/04/2009 16:27:15
Query_SQL: SELECT Books.ID1, Books.[Sub-Topic] FROM Books WHERE (((Books.[Sub-Topic]) Is Not Null));
Link To Column Definitions: Book_SubTopic1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_SubTopic2
Query_Type: Select
Query_DateCreated: 12/04/2009 16:26:33
Query_DateChanged: 12/04/2009 16:29:03
Query_SQL: SELECT Books.ID1, Books.[Sub-Topic2] AS [Sub-Topic] FROM Books WHERE (((Books.[Sub-Topic2]) Is Not Null));
Link To Column Definitions: Book_SubTopic2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_SubTopic3
Query_Type: Select
Query_DateCreated: 12/04/2009 16:28:42
Query_DateChanged: 12/04/2009 16:28:49
Query_SQL: SELECT Books.ID1, Books.[Sub-Topic3] AS [Sub-Topic] FROM Books WHERE (((Books.[Sub-Topic3]) Is Not Null));
Link To Column Definitions: Book_SubTopic3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Summary_Changed_List
Query_Type: Select
Query_DateCreated: 25/06/2007 15:13:28
Query_DateChanged: 03/09/2015 18:46:11
Query_SQL: SELECT Books.ID1, Books.Author, Books.Title, Books.ID1 AS Book, Book_Summary.TimeStamp, [Author] & [Title] & [Subject] & [Subject2] & [Subject3] & [Location] & [Topic] & [Topic2] & [Topic3] & [Sub-Topic] & [Sub-Topic2] & [Sub-Topic3] & [Pages] & [Priority] & [Difficulty] & [Estimate] & Nz([Actual - Total]) & [Read?] & [Abstract_Quality] & IIf(Len([Comments])<250,[Comments],"") AS x, Book_Summary.Key FROM Books LEFT JOIN Book_Summary ON Books.ID1 = Book_Summary.ID WHERE ((([Author] & [Title] & [Subject] & [Subject2] & [Subject3] & [Location] & [Topic] & [Topic2] & [Topic3] & [Sub-Topic] & [Sub-Topic2] & [Sub-Topic3] & [Pages] & [Priority] & [Difficulty] & [Estimate] & Nz([Actual - Total]) & [Read?] & [Abstract_Quality] & IIf(Len([Comments])<250,[Comments],""))<>[Book_Summary]![Key])) OR (((Book_Summary.ID) Is Null)) ORDER BY Books.Author, Books.Title;
Link To Column Definitions: Book_Summary_Changed_List

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Summary_Ranges_Latest
Query_Type: Select
Query_DateCreated: 19/05/2018 23:09:29
Query_DateChanged: 19/05/2018 23:09:29
Query_SQL: SELECT "Book_Summary_Ranges" AS Title, Min(Book_Summary_Ranges.Latest_Book_Range_Update) AS MinOfLatest_Book_Range_Update FROM Book_Summary_Ranges GROUP BY "Book_Summary_Ranges";
Link To Column Definitions: Book_Summary_Ranges_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Summary_Refs
Query_Type: Select
Query_DateCreated: 27/06/2007 08:43:51
Query_DateChanged: 18/09/2013 13:33:46
Query_SQL: SELECT Books.ID1, "<A HREF = ""BookSummaries/BookSummary_" & Mid(Str(100000+[Books]![ID1]),3,2) & "/BookSummary_" & [Books]![ID1] & ".htm"">More</A><br>" & IIf([Book_Abstract_Quality_List]![ID1] & ""<>"","<A HREF = ""BookSummaries/BookSummary_" & Mid(Str(100000+[Books]![ID1]),3,2) & "/BookPaperAbstracts/BookPaperAbstracts_" & [Books]![ID1] & ".htm"">Abstract</A> " & [Image],"") AS Book_Summary FROM Books LEFT JOIN Book_Abstract_Quality_List ON Books.ID1 = Book_Abstract_Quality_List.ID1;
Link To Column Definitions: Book_Summary_Refs

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Topic_All
Query_Type: Select
Query_DateCreated: 12/04/2009 16:25:07
Query_DateChanged: 12/04/2009 16:25:45
Query_SQL: SELECT Book_Topic_Union.ID1, Book_Topic_Union.Topic FROM Book_Topic_Union GROUP BY Book_Topic_Union.ID1, Book_Topic_Union.Topic;
Link To Column Definitions: Book_Topic_All

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Topic1
Query_Type: Select
Query_DateCreated: 12/04/2009 14:50:32
Query_DateChanged: 12/04/2009 14:50:44
Query_SQL: SELECT Books.ID1, Books.Topic FROM Books WHERE (((Books.Topic) Is Not Null));
Link To Column Definitions: Book_Topic1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Topic2
Query_Type: Select
Query_DateCreated: 12/04/2009 14:51:00
Query_DateChanged: 12/04/2009 14:51:27
Query_SQL: SELECT Books.ID1, Books.Topic2 AS Topic FROM Books WHERE (((Books.Topic2) Is Not Null));
Link To Column Definitions: Book_Topic2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Book_Topic3
Query_Type: Select
Query_DateCreated: 12/04/2009 14:51:38
Query_DateChanged: 12/04/2009 14:51:44
Query_SQL: SELECT Books.ID1, Books.Topic3 AS Topic FROM Books WHERE (((Books.Topic3) Is Not Null));
Link To Column Definitions: Book_Topic3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Booklist - On Order
Query_Type: Select
Query_DateCreated: 29/04/2005 18:06:40
Query_DateChanged: 27/07/2013 11:02:32
Query_SQL: SELECT Books.[Purchased?], Books.[Purchase Date], Books.Author, Books.Title, Books.ID1, Books.Subject, Books.[Plan ID], Books.Pages, Books.Priority, Books.Status, Books.Cost, Books.[Checked?], Books.Location, Books.Comments, Books.Abstract FROM Books WHERE (((Books.[Purchased?])="ordered" Or (Books.[Purchased?])="in transit")) ORDER BY Books.[Purchased?], Books.Author, Books.Title, Books.Subject;
Link To Column Definitions: Booklist - On Order

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Booklist - Spare Copies
Query_Type: Select
Query_DateCreated: 29/04/2005 18:06:40
Query_DateChanged: 27/04/2013 11:48:37
Query_SQL: SELECT Books.Author, Books.Title, Books.[Plan ID], Books.[Philosophy Book?], Books.Subject, Books.Category, Books.Pages, Books.Priority, Books.Status, Books.[Purchased?], Books.Cost, Books.[Checked?], Books.Location, Books.Comments FROM Books WHERE (((Books.Comments) Like "*Extra Copy*" Or (Books.Comments) Like "*Duplicate Copy*" Or (Books.Comments) Like "*Spare Copy*")) ORDER BY Books.Author, Books.Title, Books.Subject, Books.Category;
Link To Column Definitions: Booklist - Spare Copies

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookPaperAbstract_Ranges_Latest
Query_Type: Select
Query_DateCreated: 20/05/2018 00:02:59
Query_DateChanged: 20/05/2018 00:02:59
Query_SQL: SELECT "BookPaperAbstract_Ranges" AS Title, Min(BookPaperAbstract_Ranges.Latest_Book_Range_Update) AS MinOfLatest_Book_Range_Update FROM BookPaperAbstract_Ranges GROUP BY "BookPaperAbstract_Ranges";
Link To Column Definitions: BookPaperAbstract_Ranges_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookPaperAbstracts_List_Changed
Query_Type: Select
Query_DateCreated: 28/07/2009 10:04:53
Query_DateChanged: 24/05/2015 14:42:33
Query_SQL: SELECT BookPaperAbstracts_List.* FROM BookPaperAbstracts_List INNER JOIN Book_Papers_Changed ON BookPaperAbstracts_List.[Book ID] = Book_Papers_Changed.Book_ID ORDER BY BookPaperAbstracts_List.[Book Author], BookPaperAbstracts_List.[Book Title], BookPaperAbstracts_List.Seq, BookPaperAbstracts_List.[Paper Author], BookPaperAbstracts_List.[Paper Title];
Link To Column Definitions: BookPaperAbstracts_List_Changed

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookPaperAbstracts_List_Query
Query_Type: Select
Query_DateCreated: 23/06/2009 10:41:01
Query_DateChanged: 13/04/2020 23:49:08
Query_SQL: SELECT Books.ID1 AS [Book ID], Papers.ID AS [Paper ID], Books.Author AS [Book Author], Books.Title AS [Book Title], Papers.Author AS [Paper Author], Papers.Title AS [Paper Title], Papers.Source, IIf([Papers]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Books.Abstract AS [Book Abstract], Books.Comments AS [Book Comments], Papers.Abstract AS [Paper Abstracts], Papers.Comments AS [Paper Comments], IIf([Sequence]<0,[Sequence],IIf([CountAuthors]>10,IIf([CountSequences]/[CountAuthors]<0.5,0,[Sequence]),IIf([CountSequences]<4,0,[Sequence]))) AS Seq, Nz(Len([Books]![Comments]))+Nz(Len([Books]![Abstract])) AS Book_BlurbLen, Nz(Len([Papers]![Comments]))+Nz(Len([Papers]![Abstract])) AS Paper_BlurbLen, Papers.Write_Up_Note_ID, IIf([Pseudo_Books]![Book_ID] & ""="","No","Yes") AS PseudoBook FROM (((((Book_Papers3 INNER JOIN Books ON Book_Papers3.Book_ID = Books.ID1) INNER JOIN Papers ON Book_Papers3.Paper_ID = Papers.ID) INNER JOIN Book_Papers5 ON Books.ID1 = Book_Papers5.Book_ID) INNER JOIN Book_Papers7 ON Book_Papers5.Book_ID = Book_Papers7.Book_ID) LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality) LEFT JOIN Pseudo_Books ON Books.ID1 = Pseudo_Books.Book_ID ORDER BY Books.ID1, IIf([Sequence]<0,[Sequence],IIf([CountAuthors]>10,IIf([CountSequences]/[CountAuthors]<0.5,0,[Sequence]),IIf([CountSequences]<4,0,[Sequence]))), Books.Author, Books.Title, Papers.Author, Papers.Title, Books.Location;
Link To Column Definitions: BookPaperAbstracts_List_Query

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookPaperAbstracts_List_Range
Query_Type: Select
Query_DateCreated: 17/03/2014 17:59:44
Query_DateChanged: 24/05/2015 14:43:16
Query_SQL: SELECT BookPaperAbstracts_List.[Book ID], BookPaperAbstracts_List.[Paper ID], BookPaperAbstracts_List.[Book Author], BookPaperAbstracts_List.[Book Title], BookPaperAbstracts_List.[Paper Author], BookPaperAbstracts_List.[Paper Title], BookPaperAbstracts_List.Source, BookPaperAbstracts_List.[Read?], BookPaperAbstracts_List.[Further Information], BookPaperAbstracts_List.[Book Abstract], BookPaperAbstracts_List.[Book Comments], BookPaperAbstracts_List.[Paper Abstracts], BookPaperAbstracts_List.[Paper Comments], BookPaperAbstracts_List.Seq, BookPaperAbstracts_List.Book_BlurbLen, BookPaperAbstracts_List.Paper_BlurbLen, BookPaperAbstracts_List.Write_Up_Note_ID, BookPaperAbstracts_List.PseudoBook FROM BookPaperAbstracts_List, BookPaperAbstract_Ranges INNER JOIN Current_ID ON BookPaperAbstract_Ranges.Range_ID = Current_ID.Range_ID WHERE (((BookPaperAbstracts_List.[Book ID])>=[BookPaperAbstract_Ranges]![ID_Start] And (BookPaperAbstracts_List.[Book ID])<=[BookPaperAbstract_Ranges]![ID_End]) AND ((BookPaperAbstract_Ranges.[Select?])=True)) ORDER BY BookPaperAbstracts_List.[Book ID], BookPaperAbstracts_List.Seq, BookPaperAbstracts_List.[Book Author], BookPaperAbstracts_List.[Book Title], BookPaperAbstracts_List.[Paper Author], BookPaperAbstracts_List.[Paper Title];
Link To Column Definitions: BookPaperAbstracts_List_Range

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookPaperAbstracts_List_Regen
Query_Type: Select
Query_DateCreated: 28/07/2009 09:57:13
Query_DateChanged: 07/09/2014 10:04:18
Query_SQL: SELECT BookPaperAbstracts_List.* FROM BookPaperAbstracts_List INNER JOIN Books_To_Regen ON BookPaperAbstracts_List.[Book ID] = Books_To_Regen.Book_ID ORDER BY BookPaperAbstracts_List.[Book Author], BookPaperAbstracts_List.[Book Title], BookPaperAbstracts_List.Seq, BookPaperAbstracts_List.[Paper Author], BookPaperAbstracts_List.[Paper Title];
Link To Column Definitions: BookPaperAbstracts_List_Regen

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookPaperControl_Latest
Query_Type: Select
Query_DateCreated: 19/05/2018 21:42:45
Query_DateChanged: 19/05/2018 21:46:41
Query_SQL: SELECT "BookPaperControl" AS Title, Min(BookPaperControl.Latest_Update) AS MinOfLatest_Update FROM BookPaperControl WHERE (((BookPaperControl.ID)<>"Documentation_Generator_Bridge")) GROUP BY "BookPaperControl";
Link To Column Definitions: BookPaperControl_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookPaperLinks_Ranges_Latest
Query_Type: Select
Query_DateCreated: 19/05/2018 23:56:16
Query_DateChanged: 19/05/2018 23:56:16
Query_SQL: SELECT "BookPaperLinks_Ranges" AS Title, Min(BookPaperLinks_Ranges.Latest_Book_Range_Update) AS MinOfLatest_Book_Range_Update FROM BookPaperLinks_Ranges GROUP BY "BookPaperLinks_Ranges";
Link To Column Definitions: BookPaperLinks_Ranges_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All
Query_Type: Select
Query_DateCreated: 12/05/2007 08:46:55
Query_DateChanged: 25/09/2013 19:02:21
Query_SQL: SELECT Books.Author, Books.Title, [Subjects]![Subject] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject]," - " & [Topics]![Topic]) & IIf([Sub-Topics]![ID]<>498," - " & [Sub-Topics]![Sub-Topic])) AS Category, Books.Location, Books.Pages, Books.Priority, IIf([Books]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], IIf([Book_Summary_Refs]![ID1] Is Not Null,[Book_Summary],0) AS More FROM (((Books INNER JOIN Topics ON Books.Topic = Topics.ID) INNER JOIN [Sub-Topics] ON Books.[Sub-Topic] = [Sub-Topics].ID) INNER JOIN Subjects ON Books.Subject = Subjects.ID) LEFT JOIN Book_Summary_Refs ON Books.ID1 = Book_Summary_Refs.ID1 WHERE (((Books.Author)<>"zzzz") AND ((Books.Location)<>"Senate House Library")) ORDER BY Books.Author, Books.Title, [Subjects]![Subject] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject]," - " & [Topics]![Topic]) & IIf([Sub-Topics]![ID]<>498," - " & [Sub-Topics]![Sub-Topic]));
Link To Column Definitions: Books - All

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All - Categorised
Query_Type: Select
Query_DateCreated: 12/04/2009 16:41:33
Query_DateChanged: 02/10/2009 11:12:32
Query_SQL: SELECT [Books - All - Categorised_Table].Category, [Books - All - Categorised_Table].Author, [Books - All - Categorised_Table].Title, [Books - All - Categorised_Table].Location, [Books - All - Categorised_Table].Pages, [Books - All - Categorised_Table].Priority, [Books - All - Categorised_Table].[Read?], [Books - All - Categorised_Table].More, [Books - All - Categorised_Table].Topic, [Books - All - Categorised_Table].ID, [Books - All - Categorised_Table].ID1 FROM [Books - All - Categorised_Table] ORDER BY [Books - All - Categorised_Table].Category, [Books - All - Categorised_Table].Author, [Books - All - Categorised_Table].Title;
Link To Column Definitions: Books - All - Categorised

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All - Categorised (Titles)
Query_Type: Select
Query_DateCreated: 12/04/2009 14:18:27
Query_DateChanged: 14/09/2013 20:22:59
Query_SQL: SELECT [Books - All - Categorised (Titles) - Prelist]![Category] & " <BR>(" & [Count] & IIf([Count]>1," items"," item") & ")" AS Category, [Books - All - Categorised (Titles) - Prelist].ID, IIf(InStr([ID],"_")>0,Left([ID],InStr([ID],"_")-1),[ID]*1) AS Top_ID FROM [Books - All - Categorised (Titles) - Prelist] ORDER BY [Books - All - Categorised (Titles) - Prelist].Category;
Link To Column Definitions: Books - All - Categorised (Titles)

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All - Categorised (Titles) - Counter
Query_Type: Select
Query_DateCreated: 02/10/2009 10:35:49
Query_DateChanged: 02/10/2009 10:36:40
Query_SQL: SELECT Val([Top_ID]) AS [Top ID], Count([Books - All - Categorised (Titles)].ID) AS CountOfID FROM [Books - All - Categorised (Titles)] GROUP BY Val([Top_ID]);
Link To Column Definitions: Books - All - Categorised (Titles) - Counter

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All - Categorised (Titles) - Prelist
Query_Type: Select
Query_DateCreated: 12/04/2009 14:16:20
Query_DateChanged: 12/04/2009 14:17:53
Query_SQL: SELECT [Books - All - Categorised].Category, [Books - All - Categorised].ID, Count([Books - All - Categorised].ID1) AS [Count] FROM [Books - All - Categorised] GROUP BY [Books - All - Categorised].Category, [Books - All - Categorised].ID;
Link To Column Definitions: Books - All - Categorised (Titles) - Prelist

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All - Categorised (Titles) - Prelist - Top
Query_Type: Select
Query_DateCreated: 02/10/2009 10:43:31
Query_DateChanged: 02/10/2009 21:26:26
Query_SQL: SELECT IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)) AS X, IIf(InStr([ID],"_")=0,[ID]*1,Left([ID],InStr([ID],"_")-1)) AS Y, Count([Books - All - Categorised].ID1) AS [Count] FROM [Books - All - Categorised] GROUP BY IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)), IIf(InStr([ID],"_")=0,[ID]*1,Left([ID],InStr([ID],"_")-1));
Link To Column Definitions: Books - All - Categorised (Titles) - Prelist - Top

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All - Categorised (Titles) - Top
Query_Type: Select
Query_DateCreated: 02/10/2009 10:47:36
Query_DateChanged: 09/09/2013 12:46:38
Query_SQL: SELECT [Books - All - Categorised (Titles) - Top1].Category, [Books - All - Categorised (Titles) - Top1].ID, [Books - All - Categorised (Titles) - Counter].CountOfID FROM [Books - All - Categorised (Titles) - Top1] INNER JOIN [Books - All - Categorised (Titles) - Counter] ON [Books - All - Categorised (Titles) - Top1].ID = [Books - All - Categorised (Titles) - Counter].[Top ID] GROUP BY [Books - All - Categorised (Titles) - Top1].Category, [Books - All - Categorised (Titles) - Top1].ID, [Books - All - Categorised (Titles) - Counter].CountOfID ORDER BY [Books - All - Categorised (Titles) - Top1].Category;
Link To Column Definitions: Books - All - Categorised (Titles) - Top

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All - Categorised (Titles) - Top1
Query_Type: Select
Query_DateCreated: 02/10/2009 10:46:19
Query_DateChanged: 02/10/2009 21:08:47
Query_SQL: SELECT [X] & "<BR>(" & [Count] & IIf([Count]>1," items"," item") & ")" AS Category, Val([Y]) AS ID FROM [Books - All - Categorised (Titles) - Prelist - Top] ORDER BY [Books - All - Categorised (Titles) - Prelist - Top].X;
Link To Column Definitions: Books - All - Categorised (Titles) - Top1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - All (Letters)
Query_Type: Select
Query_DateCreated: 12/05/2007 10:49:35
Query_DateChanged: 12/05/2007 10:51:23
Query_SQL: SELECT Left([Author],1) AS Letter FROM Books WHERE (((Books.Author)<>"zzzz" And (Books.Author)<>"Various") AND ((Books.Location)<>"Senate House Library")) GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Books - All (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Collections of Papers
Query_Type: Select
Query_DateCreated: 06/08/2005 10:19:48
Query_DateChanged: 08/08/2005 16:22:38
Query_SQL: SELECT Books.Subject, [Author] & " - " & [Title] AS [Author/Title], Books.Location, Books.Comments, Books.[Purchased?] FROM Books WHERE (((Books.Comments) Like "*edited*") AND ((Books.[Purchased?])<>"Buy?")) OR (((Books.Title) Like "*paper*") AND ((Books.[Purchased?])<>"Buy?")) ORDER BY Books.Subject, [Author] & " - " & [Title];
Link To Column Definitions: Books - Collections of Papers

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Move
Query_Type: Select
Query_DateCreated: 26/10/2007 12:12:09
Query_DateChanged: 23/09/2013 15:39:23
Query_SQL: SELECT Books.Location, Books.Author, Books.Title, Books.Pages FROM Books INNER JOIN Locations ON Books.Location = Locations.Location WHERE (((Locations.[Moving?])=Yes)) ORDER BY Books.Location, Books.Author, Books.Title;
Link To Column Definitions: Books - Move

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Papers Catalogued
Query_Type: Select
Query_DateCreated: 06/08/2005 10:05:47
Query_DateChanged: 12/03/2006 09:07:06
Query_SQL: SELECT qryBooks.[A+T], qryBooks.IDs, Count(Papers.ID) AS [Count] FROM Papers INNER JOIN qryBooks ON Papers.Book = qryBooks.IDs GROUP BY qryBooks.[A+T], qryBooks.IDs ORDER BY qryBooks.[A+T];
Link To Column Definitions: Books - Papers Catalogued

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Papers Uncatalogued
Query_Type: Select
Query_DateCreated: 06/08/2005 10:20:56
Query_DateChanged: 08/08/2005 16:20:12
Query_SQL: SELECT [Books - Collections of Papers].Subject, [Books - Collections of Papers].[Author/Title], [Books - Collections of Papers].Location, [Books - Collections of Papers].Comments FROM [Books - Collections of Papers] LEFT JOIN [Books - Papers Catalogued] ON [Books - Collections of Papers].[Author/Title] = [Books - Papers Catalogued].[A+T] WHERE ((([Books - Papers Catalogued].[A+T]) Is Null)) ORDER BY [Books - Collections of Papers].Subject, [Books - Collections of Papers].[Author/Title];
Link To Column Definitions: Books - Papers Uncatalogued

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Read
Query_Type: Select
Query_DateCreated: 08/10/2005 20:40:30
Query_DateChanged: 08/10/2005 20:53:24
Query_SQL: SELECT Books.* FROM Books WHERE (((Books.[Read?])=Yes)) ORDER BY Books.Author, Books.Title;
Link To Column Definitions: Books - Read

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Recent
Query_Type: Select
Query_DateCreated: 05/12/2017 23:20:13
Query_DateChanged: 09/02/2020 17:19:00
Query_SQL: SELECT Books.Author, Books.Title, [Subjects]![Subject] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject]," - " & [Topics]![Topic]) & IIf([Sub-Topics]![ID]<>498," - " & [Sub-Topics]![Sub-Topic])) AS Category, Books.[Purchase Date] AS [Purchase Date], Books.Pages, Books.Priority, IIf([Books]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], IIf([Book_Summary_Refs]![ID1] Is Not Null,[Book_Summary],0) AS More FROM (((Books INNER JOIN Topics ON Books.Topic = Topics.ID) INNER JOIN [Sub-Topics] ON Books.[Sub-Topic] = [Sub-Topics].ID) INNER JOIN Subjects ON Books.Subject = Subjects.ID) LEFT JOIN Book_Summary_Refs ON Books.ID1 = Book_Summary_Refs.ID1 WHERE (((Books.Author)<>"Various") AND ((Books.[Purchase Date]) Is Not Null And (Books.[Purchase Date])>(Now()-180))) ORDER BY Books.Author, Books.Title, [Subjects]![Subject] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject]," - " & [Topics]![Topic]) & IIf([Sub-Topics]![ID]<>498," - " & [Sub-Topics]![Sub-Topic]));
Link To Column Definitions: Books - Recent

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Recent - Categorised
Query_Type: Select
Query_DateCreated: 28/06/2009 20:14:41
Query_DateChanged: 20/01/2015 15:48:30
Query_SQL: SELECT [Subjects]![Subject] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject]," - " & [Topics]![Topic]) & IIf([Sub-Topics]![ID]<>498," - " & [Sub-Topics]![Sub-Topic])) AS Category, Books.Author, Books.Title, Books.Location, Books.Pages, Books.Priority, Books.[Purchase Date] AS [Purchase Date], IIf([Book_Summary_Refs]![ID1] Is Not Null,[Book_Summary],".") AS More, [Subjects]![ID] & IIf([Topics]![ID]<>94,IIf([Topics]![Topic]<>[Subjects]![Subject],"_" & [Topics]![ID]) & IIf([Sub-Topics]![ID]<>98,"_" & [Sub-Topics]![ID])) AS ID, Books.ID1 FROM ((((Books LEFT JOIN Book_Summary_Refs ON Books.ID1 = Book_Summary_Refs.ID1) INNER JOIN Book_Subject_Topic_Subtopic_List ON Books.ID1 = Book_Subject_Topic_Subtopic_List.ID1) INNER JOIN Subjects ON Book_Subject_Topic_Subtopic_List.Subject = Subjects.ID) INNER JOIN Topics ON Book_Subject_Topic_Subtopic_List.Topic = Topics.ID) INNER JOIN [Sub-Topics] ON Book_Subject_Topic_Subtopic_List.[Sub-Topic] = [Sub-Topics].ID WHERE ((([Location] & "")<>"" And ([Location] & "")<>"Senate House Library") AND ((Topics.Topic)<>"Admin")) GROUP BY [Subjects]![Subject] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject]," - " & [Topics]![Topic]) & IIf([Sub-Topics]![ID]<>498," - " & [Sub-Topics]![Sub-Topic])), Books.Author, Books.Title, Books.Location, Books.Pages, Books.Priority, Books.[Purchase Date], IIf([Book_Summary_Refs]![ID1] Is Not Null,[Book_Summary],"."), [Subjects]![ID] & IIf([Topics]![ID]<>94,IIf([Topics]![Topic]<>[Subjects]![Subject],"_" & [Topics]![ID]) & IIf([Sub-Topics]![ID]<>98,"_" & [Sub-Topics]![ID])), Books.ID1 HAVING (((Books.Author)<>"zzzz" And (Books.Author)<>"Various") AND ((Books.[Purchase Date]) Is Not Null And (Books.[Purchase Date])>(Now()-180))) ORDER BY [Subjects]![Subject] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject]," - " & [Topics]![Topic]) & IIf([Sub-Topics]![ID]<>498," - " & [Sub-Topics]![Sub-Topic])), Books.Author, Books.Title;
Link To Column Definitions: Books - Recent - Categorised

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Recent - Categorised (Titles)
Query_Type: Select
Query_DateCreated: 28/06/2009 20:15:39
Query_DateChanged: 28/06/2009 20:33:09
Query_SQL: SELECT [Books - Recent - Categorised (Titles) - Prelist]![Category] & "<BR>(" & [Count] & IIf([Count]>1," items"," item") & ")" AS Category, [Books - Recent - Categorised (Titles) - Prelist].ID FROM [Books - Recent - Categorised (Titles) - Prelist] ORDER BY [Books - Recent - Categorised (Titles) - Prelist].Category;
Link To Column Definitions: Books - Recent - Categorised (Titles)

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Recent - Categorised (Titles) - Prelist
Query_Type: Select
Query_DateCreated: 28/06/2009 20:28:24
Query_DateChanged: 12/02/2010 19:18:53
Query_SQL: SELECT [Books - Recent - Categorised].Category, [Books - Recent - Categorised].ID, Count([Books - Recent - Categorised].ID1) AS [Count] FROM [Books - Recent - Categorised] GROUP BY [Books - Recent - Categorised].Category, [Books - Recent - Categorised].ID;
Link To Column Definitions: Books - Recent - Categorised (Titles) - Prelist

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books - Recent (Letters)
Query_Type: Select
Query_DateCreated: 05/12/2017 23:26:44
Query_DateChanged: 05/12/2017 23:42:10
Query_SQL: SELECT Left([Author],1) AS Letter FROM [Books - Recent] WHERE ((([Books - Recent].Author)<>"zzzz" And ([Books - Recent].Author)<>"Various")) GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Books - Recent (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books Search - General
Query_Type: Select
Query_DateCreated: 29/04/2005 18:06:40
Query_DateChanged: 30/08/2018 21:21:30
Query_SQL: SELECT Books.Author, Books.Title, Books.ID1, Books.[Purchased?], Books.[Purchase Date], Books.[Read?], Books.Priority, Books.Difficulty, Books.Location, Books.Subject, Books.Subject2, Books.Subject3, Books.Topic, Books.Topic2, Books.Topic3, Books.[Sub-Topic], Books.[Sub-Topic2], Books.[Sub-Topic3], Books.Comments, Books.Abstract, Books.Abstract_Quality, Books.Pages, Books.Cost, Books.[Actual - Total], Books.[Philosophy Book?], Books.[Abstract_Fixed?] FROM Books WHERE (((Books.Author) Like "*" & [Enter String] & "*")) OR (((Books.Title) Like "*" & [Enter String] & "*")) OR (((Books.Subject) Like "*" & [Enter String] & "*")) OR (((Books.Comments) Like "*" & [Enter String] & "*")) OR (((Books.Abstract) Like "*" & [Enter String] & "*")) ORDER BY Books.Author, Books.Title;
Link To Column Definitions: Books Search - General

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_By_SubTopic1
Query_Type: Select
Query_DateCreated: 27/07/2009 11:27:39
Query_DateChanged: 17/06/2013 22:54:02
Query_SQL: SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Book - By Subtopic" AS Medium, Books.ID1 AS [Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?] FROM ((((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Books ON [Sub-Topics].ID = Books.[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) LEFT JOIN Books_Cited ON Books.ID1 = Books_Cited.[Book ID] WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null));
Link To Column Definitions: Books_By_SubTopic1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_By_SubTopic2
Query_Type: Select
Query_DateCreated: 27/07/2009 11:27:51
Query_DateChanged: 17/06/2013 22:55:07
Query_SQL: SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Book - By Subtopic" AS Medium, Books.ID1 AS [Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic2], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?] FROM (((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) INNER JOIN (Books LEFT JOIN Books_Cited ON Books.ID1 = Books_Cited.[Book ID]) ON [Sub-Topics].ID = Books.[Sub-Topic2] WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null));
Link To Column Definitions: Books_By_SubTopic2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_By_SubTopic3
Query_Type: Select
Query_DateCreated: 27/07/2009 11:28:29
Query_DateChanged: 17/06/2013 22:57:41
Query_SQL: SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Book - Referenced" AS Medium, Books.ID1 AS [Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic3], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?] FROM (((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) INNER JOIN (Books LEFT JOIN Books_Cited ON Books.ID1 = Books_Cited.[Book ID]) ON [Sub-Topics].ID = Books.[Sub-Topic3] WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null));
Link To Column Definitions: Books_By_SubTopic3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Cited
Query_Type: Select
Query_DateCreated: 31/10/2007 21:43:36
Query_DateChanged: 02/08/2013 22:20:24
Query_SQL: SELECT Note_Book_Links.Note AS [Note ID], IIf([Origin]="Note","Book - Cited","Book - Referencing") AS Medium, Books.ID1 AS [Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?] FROM Citations_Note_Group RIGHT JOIN (((Note_Book_Links INNER JOIN Note_Usage_Temp ON Note_Book_Links.Note = Note_Usage_Temp.Note_ID) INNER JOIN Books ON Note_Book_Links.Book = Books.ID1) INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) ON Citations_Note_Group.Note_Group = Notes.Note_Group WHERE (((Note_Book_Links.Timestamp)=0));
Link To Column Definitions: Books_Cited

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_from_Papers_By_Subtopic
Query_Type: Select
Query_DateCreated: 12/11/2007 16:59:01
Query_DateChanged: 30/07/2009 17:50:44
Query_SQL: SELECT Papers_By_SubTopic.[Note ID], "Book - By Subtopic (via Paper By Subtopic)" AS Medium, Papers_By_SubTopic.[Book ID], 0 AS [Paper ID], Books.Author, Books.Title, Books.[Author & Title] AS Source, Books.[Sub-Topic], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?] FROM ((Papers_By_SubTopic INNER JOIN Books ON Papers_By_SubTopic.[Book ID] = Books.ID1) LEFT JOIN Books_By_SubTopic ON Papers_By_SubTopic.[Book ID] = Books_By_SubTopic.[Book ID]) LEFT JOIN Books_Cited ON Papers_By_SubTopic.[Book ID] = Books_Cited.[Book ID] WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null) AND ((Books_By_SubTopic.[Book ID]) Is Null));
Link To Column Definitions: Books_from_Papers_By_Subtopic

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_from_Papers_Cited
Query_Type: Select
Query_DateCreated: 12/11/2007 13:46:54
Query_DateChanged: 23/07/2010 09:40:16
Query_SQL: SELECT Papers_Cited.[Note ID], IIf([Papers_Cited]![Medium] Like "*Cited*","Book - Cited (via Paper Cited)","Book - Referencing (via Paper Referencing)") AS Medium, Papers_Cited.[Book ID], 0 AS [Paper ID], Books.Author, Books.Title, "Bibliographical details to be supplied" AS Source, Books.[Sub-Topic], Books.Priority, IIf([Books]![Read?]=Yes,"Yes") AS [Read?] FROM ((Papers_Cited INNER JOIN Books ON Papers_Cited.[Book ID] = Books.ID1) LEFT JOIN Books_Cited ON Papers_Cited.[Book ID] = Books_Cited.[Book ID]) LEFT JOIN Books_By_SubTopic ON Papers_Cited.[Book ID] = Books_By_SubTopic.[Book ID] WHERE (((Books.Author) Not Like "Various*" And (Books.Author) Not Like "zzz*" And (Books.Author) Not Like "Electronic*") AND ((Books_Cited.[Book ID]) Is Null) AND ((Books_By_SubTopic.[Book ID]) Is Null));
Link To Column Definitions: Books_from_Papers_Cited

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Locations
Query_Type: Select
Query_DateCreated: 12/05/2013 18:05:11
Query_DateChanged: 12/05/2013 18:05:12
Query_SQL: SELECT Books_Locations_Table.Location, Books_Locations_Table.Author, Books_Locations_Table.Title, Books_Locations_Table.Category, Books_Locations_Table.Pages, Books_Locations_Table.Priority, Books_Locations_Table.[Read?], Books_Locations_Table.More, Books_Locations_Table.Topic, Books_Locations_Table.ID, Books_Locations_Table.ID1 FROM Books_Locations_Table ORDER BY Books_Locations_Table.Location, Books_Locations_Table.Author, Books_Locations_Table.Title;
Link To Column Definitions: Books_Locations

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Locations (Titles)
Query_Type: Select
Query_DateCreated: 12/05/2013 18:27:36
Query_DateChanged: 17/09/2013 14:16:32
Query_SQL: SELECT [Books_Locations (Titles) - Prelist]![Location] & " <BR>(" & [Count] & IIf([Count]>1," items"," item") & ")" AS Category, [Books_Locations (Titles) - Prelist].ID, Left([MinOfID],100) AS Top_ID FROM ([Books_Locations (Titles) - Prelist] INNER JOIN Locations ON [Books_Locations (Titles) - Prelist].Location = Locations.Location) INNER JOIN Location_Group_IDs ON Locations.Location_Group = Location_Group_IDs.Location_Group WHERE (((Location_Group_IDs.Location_Group)<>"Ignore")) ORDER BY [Books_Locations (Titles) - Prelist].Location;
Link To Column Definitions: Books_Locations (Titles)

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Locations (Titles) - Counter
Query_Type: Select
Query_DateCreated: 09/09/2013 12:21:41
Query_DateChanged: 09/09/2013 12:21:41
Query_SQL: SELECT [Books_Locations (Titles)].Top_ID AS Top_ID, Count([Books_Locations (Titles)].ID) AS CountOfID FROM [Books_Locations (Titles)] GROUP BY [Books_Locations (Titles)].Top_ID;
Link To Column Definitions: Books_Locations (Titles) - Counter

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Locations (Titles) - Prelist
Query_Type: Select
Query_DateCreated: 12/05/2013 18:20:13
Query_DateChanged: 12/05/2013 18:22:07
Query_SQL: SELECT Books_Locations.Location, Books_Locations.ID, Count(Books_Locations.ID1) AS [Count] FROM Books_Locations GROUP BY Books_Locations.Location, Books_Locations.ID;
Link To Column Definitions: Books_Locations (Titles) - Prelist

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Locations (Titles) - Prelist - Top
Query_Type: Select
Query_DateCreated: 09/09/2013 12:25:45
Query_DateChanged: 09/09/2013 13:24:19
Query_SQL: SELECT Location_Group_IDs.Location_Group AS X, Location_Group_IDs.MinOfID AS Y, Count(Books_Locations_Table.ID1) AS [Count] FROM (Books_Locations_Table INNER JOIN Locations ON Books_Locations_Table.Location = Locations.Location) INNER JOIN Location_Group_IDs ON Locations.Location_Group = Location_Group_IDs.Location_Group GROUP BY Location_Group_IDs.Location_Group, Location_Group_IDs.MinOfID;
Link To Column Definitions: Books_Locations (Titles) - Prelist - Top

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Locations (Titles) - Top
Query_Type: Select
Query_DateCreated: 09/09/2013 12:44:10
Query_DateChanged: 09/09/2013 12:52:22
Query_SQL: SELECT [Books_Locations (Titles) - Top1].Category, [Books_Locations (Titles) - Top1].ID, [Books_Locations (Titles) - Counter].CountOfID FROM [Books_Locations (Titles) - Top1] INNER JOIN [Books_Locations (Titles) - Counter] ON [Books_Locations (Titles) - Top1].ID = [Books_Locations (Titles) - Counter].Top_ID GROUP BY [Books_Locations (Titles) - Top1].Category, [Books_Locations (Titles) - Top1].ID, [Books_Locations (Titles) - Counter].CountOfID ORDER BY [Books_Locations (Titles) - Top1].Category;
Link To Column Definitions: Books_Locations (Titles) - Top

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Locations (Titles) - Top1
Query_Type: Select
Query_DateCreated: 09/09/2013 12:38:36
Query_DateChanged: 17/09/2013 14:19:31
Query_SQL: SELECT [X] & " <BR>(" & [Count] & IIf([Count]>1," items"," item") & ")" AS Category, Left([Y],100) AS ID FROM [Books_Locations (Titles) - Prelist - Top] ORDER BY [Books_Locations (Titles) - Prelist - Top].X;
Link To Column Definitions: Books_Locations (Titles) - Top1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Nearly_Read
Query_Type: Select
Query_DateCreated: 22/12/2010 11:00:37
Query_DateChanged: 22/12/2010 11:44:53
Query_SQL: SELECT Books.Subject, Books.[Sub-Topic], Books.Author, Books.Title, Books.[Read?], Books.Location, (Nz([Actual (BA Year 3-4)])+Nz([Actual (Year 0)])+Nz([Actual (Year 1)])+Nz([Actual (Year 2)])+Nz([Actual - MPhil Year 1])+Nz([Actual - Intermission Year 1])+Nz([Actual - Intermission Year 2])+Nz([Actual - Heythrop Year 1])+Nz([Actual - Heythrop Year 2])) AS [Total Actual Hours] FROM (Books INNER JOIN Subjects ON Books.Subject = Subjects.ID) INNER JOIN [Sub-Topics] ON Books.[Sub-Topic] = [Sub-Topics].ID WHERE (((Subjects.Subject)<>"All") AND ((Books.Author)<>"Various") AND ((Books.[Read?])=No) AND (((Nz([Actual (BA Year 3-4)])+Nz([Actual (Year 0)])+Nz([Actual (Year 1)])+Nz([Actual (Year 2)])+Nz([Actual - MPhil Year 1])+Nz([Actual - Intermission Year 1])+Nz([Actual - Intermission Year 2])+Nz([Actual - Heythrop Year 1])+Nz([Actual - Heythrop Year 2])))>4)) ORDER BY Subjects.Subject, [Sub-Topics].[Sub-Topic], Books.Author, Books.Title, (Nz([Actual (BA Year 3-4)])+Nz([Actual (Year 0)])+Nz([Actual (Year 1)])+Nz([Actual (Year 2)])+Nz([Actual - MPhil Year 1])+Nz([Actual - Intermission Year 1])+Nz([Actual - Intermission Year 2])+Nz([Actual - Heythrop Year 1])+Nz([Actual - Heythrop Year 2])) DESC;
Link To Column Definitions: Books_Nearly_Read

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Versus_Papers
Query_Type: Select
Query_DateCreated: 24/12/2006 11:11:54
Query_DateChanged: 17/09/2014 18:23:01
Query_SQL: SELECT qryBooks.Location, qryBooks.Author, qryBooks.Title AS Book, qryBooks.Pages, Sum([Papers]![Pages]) AS Paper_Total, Count(Papers.ID) AS CountOfID, Sum([Papers]![Pages])-[qryBooks]![Pages] AS Difference, Books.[Papers_Logged?] FROM (Papers RIGHT JOIN qryBooks ON Papers.Book = qryBooks.IDs) INNER JOIN Books ON qryBooks.ID1 = Books.ID1 GROUP BY qryBooks.Location, qryBooks.Author, qryBooks.Title, qryBooks.Pages, Books.[Papers_Logged?], qryBooks.Author, qryBooks.[Philosophy Book?] HAVING (((qryBooks.Location)<>"") AND ((Count(Papers.ID))<3) AND ((qryBooks.[Philosophy Book?])=Yes) AND ((qryBooks.Author)<>"Admin")) ORDER BY qryBooks.Location, qryBooks.Author, qryBooks.Title, qryBooks.Author;
Link To Column Definitions: Books_Versus_Papers

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Versus_Papers_List
Query_Type: Select
Query_DateCreated: 23/01/2009 10:57:14
Query_DateChanged: 17/09/2014 18:22:20
Query_SQL: SELECT Books.ID1 AS [Book ID], Papers.ID AS [Paper ID], Books.Author AS [Book Author], Books.Title AS [Book Title], Papers.Author AS [Paper Author], Papers.Title AS [Paper Title], Papers.Pages, IIf(([Papers]![Read?]=Yes) Or ([Papers]![Status]="Complete"),"Yes",IIf([Papers]![Hours Left]>=[Papers]![Estimate],"No",Str(Round((([Papers]![Estimate]-[Papers]![Hours Left])/[Papers]![Estimate])*100)) & "%")) AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",IIf([Papers]![Comments] & ""<>"","Comment",".")) AS [Further Information] FROM (((((Book_Papers3 INNER JOIN Books ON Book_Papers3.Book_ID = Books.ID1) INNER JOIN Papers ON Book_Papers3.Paper_ID = Papers.ID) INNER JOIN Book_Papers5 ON Books.ID1 = Book_Papers5.Book_ID) INNER JOIN Book_Papers_Changed ON Book_Papers5.Book_ID = Book_Papers_Changed.Book_ID) INNER JOIN Book_Papers7 ON Book_Papers5.Book_ID = Book_Papers7.Book_ID) LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality ORDER BY Books.ID1, IIf([CountAuthors]>10,IIf([CountSequences]/[CountAuthors]<0.5,0,[Sequence]),IIf([CountSequences]<4,0,[Sequence])), Books.Author, Books.Title, Papers.Author, Papers.Title, Books.Location;
Link To Column Definitions: Books_Versus_Papers_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Books_Versus_Papers_List_Regen
Query_Type: Select
Query_DateCreated: 14/06/2009 20:34:35
Query_DateChanged: 30/08/2017 10:17:10
Query_SQL: SELECT Books.ID1 AS [Book ID], Papers.ID AS [Paper ID], Books.Author AS [Book Author], Books.Title AS [Book Title], Papers.Author AS [Paper Author], Papers.Title AS [Paper Title], Papers.Pages, IIf(([Papers]![Read?]=Yes) Or ([Papers]![Status]="Complete"),"Yes",IIf([Papers]![Hours Left]>=[Papers]![Estimate],"No",Str(Round((([Papers]![Estimate]-[Papers]![Hours Left])/[Papers]![Estimate])*100)) & "%")) AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",IIf([Papers]![Comments] & ""<>"","Comment",".")) AS [Further Information] FROM (((((Book_Papers3 INNER JOIN Books ON Book_Papers3.Book_ID = Books.ID1) INNER JOIN Papers ON Book_Papers3.Paper_ID = Papers.ID) INNER JOIN Book_Papers5 ON Books.ID1 = Book_Papers5.Book_ID) INNER JOIN Book_Papers7 ON Book_Papers5.Book_ID = Book_Papers7.Book_ID) LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality) INNER JOIN Books_To_Regen ON Book_Papers5.Book_ID = Books_To_Regen.Book_ID ORDER BY Books.ID1, IIf([Books]![Author]="Various",0,IIf([CountAuthors]>10,IIf([CountSequences]/[CountAuthors]<0.5,0,[Sequence]),IIf([CountSequences]<4,0,[Sequence]))), Books.Author, Books.Title, Papers.Author, Papers.Title, Books.Location;
Link To Column Definitions: Books_Versus_Papers_List_Regen

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookSummaries_Changed_List
Query_Type: Select
Query_DateCreated: 25/06/2007 10:15:14
Query_DateChanged: 21/09/2013 14:05:23
Query_SQL: SELECT Books.ID1, Books.Author, Books.Title, Subjects.Subject AS Subject, Subjects_1.Subject AS [Subject 2], Subjects_2.Subject AS [Subject 3], Topics.Topic, Topics_1.Topic AS [Topic 2], Topics_2.Topic AS [Topic 3], [Sub-Topics].[Sub-Topic] AS [Sub-Topic], [Sub-Topics_1].[Sub-Topic] AS [Sub-Topic 2], [Sub-Topics_2].[Sub-Topic] AS [Sub-Topic 3], Books.Location, Books.Pages, Books.Priority, Books.Difficulty, Books.Estimate AS [Estimated Hours], Nz([Actual - Total]) AS [Total Actual Hours], Books.Status, IIf([Read?]=True,"Yes","") AS [Read], "<A HREF = ""BooksToPapers_" & [ID1] & ".htm"">Papers</A>" AS [Papers in this Book], "<A HREF = ""BookPaperAbstracts/BookPaperAbstracts_" & [ID1] & ".htm"">Link</A>" AS [Book / Papers Abstracts Summary], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","") AS [Abstract Quality], IIf([CountOfNote] & ""="","","<A HREF = ""BooksToNotes_" & [Books]![ID1] & ".htm"">Notes</A>") AS [Notes Referencing this Book], IIf(Len([Books]![Comments])<250,[Books]![Comments],"") AS Comments FROM ((((((((Book_Summary_Temp INNER JOIN (((Books LEFT JOIN Subjects ON Books.Subject = Subjects.ID) LEFT JOIN Subjects AS Subjects_1 ON Books.Subject2 = Subjects_1.ID) LEFT JOIN Subjects AS Subjects_2 ON Books.Subject3 = Subjects_2.ID) ON Book_Summary_Temp.ID = Books.ID1) LEFT JOIN Topics ON Books.Topic = Topics.ID) LEFT JOIN Topics AS Topics_1 ON Books.Topic2 = Topics_1.ID) LEFT JOIN Topics AS Topics_2 ON Books.Topic3 = Topics_2.ID) LEFT JOIN [Sub-Topics] ON Books.[Sub-Topic] = [Sub-Topics].ID) LEFT JOIN [Sub-Topics] AS [Sub-Topics_1] ON Books.[Sub-Topic2] = [Sub-Topics_1].ID) LEFT JOIN [Sub-Topics] AS [Sub-Topics_2] ON Books.[Sub-Topic3] = [Sub-Topics_2].ID) LEFT JOIN Book_Note_Counts ON Books.ID1 = Book_Note_Counts.Book) LEFT JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality ORDER BY Books.ID1;
Link To Column Definitions: BookSummaries_Changed_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: BookSummaryCountCostLocation
Query_Type: Select
Query_DateCreated: 27/08/2013 20:26:35
Query_DateChanged: 27/08/2013 22:16:35
Query_SQL: SELECT IIf(InStr([Location],"-")>0,Left([Location],InStr([Location],"-")-1),[Location]) AS [Major Location], Sum(Locations.Book_Count) AS [Count], Sum(Locations.Book_Value) AS Cost FROM Locations GROUP BY IIf(InStr([Location],"-")>0,Left([Location],InStr([Location],"-")-1),[Location]) ORDER BY IIf(InStr([Location],"-")>0,Left([Location],InStr([Location],"-")-1),[Location]);
Link To Column Definitions: BookSummaryCountCostLocation

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Citations_Count
Query_Type: Select
Query_DateCreated: 18/08/2010 00:12:21
Query_DateChanged: 18/08/2010 00:12:21
Query_SQL: SELECT Citations_List.Medium, Count(Citations_List.[Book ID]) AS [CountOfBook ID] FROM Citations_List GROUP BY Citations_List.Medium ORDER BY Citations_List.Medium;
Link To Column Definitions: Citations_Count

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Citations_List
Query_Type: Select
Query_DateCreated: 01/11/2007 10:43:58
Query_DateChanged: 18/12/2017 21:45:33
Query_SQL: SELECT Citations_Union1.Author, Citations_Union1.Title, Citations_Union1.Medium, Citations_Union1.Source, [Sub-Topics].[Sub-Topic], Citations_Union1.Priority, IIf(Left([Citations_Union1]![Medium],4)="Book",IIf([Books]![Read?]=Yes,"Yes",IIf([Books]![Hours Left]>=[Books]![Estimate],"No",Str(Round((([Books]![Estimate]-[Books]![Hours Left])/[Books]![Estimate])*100)) & "%")),IIf([Papers]![Read?]=Yes,"Yes",IIf([Papers]![Hours Left]>=[Papers]![Estimate],"No",Str(Round((([Papers]![Estimate]-[Papers]![Hours Left])/[Papers]![Estimate])*100)) & "%"))) AS [Read?], Citations_Union1.[Book ID], Citations_Union1.[Paper ID], IIf(Len([Books]![Abstract] & "")>0,"Yes","No") AS [BookAbstract?], IIf(Len([Papers]![Abstract] & "")>0,"Yes","No") AS [PaperAbstract?] FROM ((Citations_Union1 INNER JOIN Books ON Citations_Union1.[Book ID] = Books.ID1) INNER JOIN [Sub-Topics] ON Citations_Union1.[Sub-Topic] = [Sub-Topics].ID) LEFT JOIN Papers ON Citations_Union1.[Paper ID] = Papers.ID GROUP BY Citations_Union1.Author, Citations_Union1.Title, Citations_Union1.Medium, Citations_Union1.Source, [Sub-Topics].[Sub-Topic], Citations_Union1.Priority, IIf(Left([Citations_Union1]![Medium],4)="Book",IIf([Books]![Read?]=Yes,"Yes",IIf([Books]![Hours Left]>=[Books]![Estimate],"No",Str(Round((([Books]![Estimate]-[Books]![Hours Left])/[Books]![Estimate])*100)) & "%")),IIf([Papers]![Read?]=Yes,"Yes",IIf([Papers]![Hours Left]>=[Papers]![Estimate],"No",Str(Round((([Papers]![Estimate]-[Papers]![Hours Left])/[Papers]![Estimate])*100)) & "%"))), Citations_Union1.[Book ID], Citations_Union1.[Paper ID], IIf(Len([Books]![Abstract] & "")>0,"Yes","No"), IIf(Len([Papers]![Abstract] & "")>0,"Yes","No"), Citations_Union1.Author, Citations_Union1.Title, Citations_Union1.Medium ORDER BY Citations_Union1.Author, Citations_Union1.Title, Citations_Union1.Medium;
Link To Column Definitions: Citations_List

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Citations_List_Short
Query_Type: Select
Query_DateCreated: 10/09/2009 22:53:59
Query_DateChanged: 18/12/2017 21:48:07
Query_SQL: SELECT Citations_Union2.Author, Citations_Union2.Title, Citations_Union2.Medium, Citations_Union2.Source, [Sub-Topics].[Sub-Topic], Citations_Union2.Priority, IIf(Left([Citations_Union2]![Medium],4)="Book",IIf([Books]![Read?]=Yes,"Yes",IIf([Books]![Hours Left]>=[Books]![Estimate],"No",Str(Round((([Books]![Estimate]-[Books]![Hours Left])/[Books]![Estimate])*100)) & "%")),IIf([Papers]![Read?]=Yes,"Yes",IIf([Papers]![Hours Left]>=[Papers]![Estimate],"No",Str(Round((([Papers]![Estimate]-[Papers]![Hours Left])/[Papers]![Estimate])*100)) & "%"))) AS [Read?], Citations_Union2.[Book ID], Citations_Union2.[Paper ID], IIf(Len([Books]![Abstract] & "")>0,"Yes","No") AS [BookAbstract?], IIf(Len([Papers]![Abstract] & "")>0,"Yes","No") AS [PaperAbstract?] FROM ((Citations_Union2 INNER JOIN Books ON Citations_Union2.[Book ID] = Books.ID1) INNER JOIN [Sub-Topics] ON Citations_Union2.[Sub-Topic] = [Sub-Topics].ID) LEFT JOIN Papers ON Citations_Union2.[Paper ID] = Papers.ID GROUP BY Citations_Union2.Author, Citations_Union2.Title, Citations_Union2.Medium, Citations_Union2.Source, [Sub-Topics].[Sub-Topic], Citations_Union2.Priority, IIf(Left([Citations_Union2]![Medium],4)="Book",IIf([Books]![Read?]=Yes,"Yes",IIf([Books]![Hours Left]>=[Books]![Estimate],"No",Str(Round((([Books]![Estimate]-[Books]![Hours Left])/[Books]![Estimate])*100)) & "%")),IIf([Papers]![Read?]=Yes,"Yes",IIf([Papers]![Hours Left]>=[Papers]![Estimate],"No",Str(Round((([Papers]![Estimate]-[Papers]![Hours Left])/[Papers]![Estimate])*100)) & "%"))), Citations_Union2.[Book ID], Citations_Union2.[Paper ID], IIf(Len([Books]![Abstract] & "")>0,"Yes","No"), IIf(Len([Papers]![Abstract] & "")>0,"Yes","No"), Citations_Union2.Author, Citations_Union2.Title, Citations_Union2.Medium ORDER BY Citations_Union2.Author, Citations_Union2.Title, Citations_Union2.Medium;
Link To Column Definitions: Citations_List_Short

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Citations_Note_Group
Query_Type: Select
Query_DateCreated: 04/11/2007 18:31:21
Query_DateChanged: 04/11/2007 18:31:50
Query_SQL: SELECT Notes.Note_Group FROM (Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID WHERE (((Note_Usage_Temp.Note_Usage)="Main Text"));
Link To Column Definitions: Citations_Note_Group

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Code_Archive_Table_Latest
Query_Type: Select
Query_DateCreated: 23/06/2013 19:16:07
Query_DateChanged: 23/06/2013 19:16:08
Query_SQL: SELECT Code_Archive_Table.Procedure_Name, Max(Code_Archive_Table.Archive_Date) AS MaxOfArchive_Date FROM Code_Archive_Table GROUP BY Code_Archive_Table.Procedure_Name ORDER BY Code_Archive_Table.Procedure_Name;
Link To Column Definitions: Code_Archive_Table_Latest

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Coxes_Farm_Gardens
Query_Type: Select
Query_DateCreated: 08/02/2019 10:14:43
Query_DateChanged: 23/02/2019 12:52:24
Query_SQL: SELECT Photos_Raw.* FROM Photos_Raw WHERE (((Photos_Raw.Photo_Type)="CoxesFarmGardens") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Full") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmGardens") AND (([Matching_Photo_FileName] & "")="") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmGardens") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Medium - Larger") AND ((Photos_Raw.[Exclude?])=False)) ORDER BY Year(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual])) & Right(Month(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]))+100,2) DESC , Photos_Raw.Photo_Subgroup, IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]) DESC , Photos_Raw.Photo_Timestamp DESC , Photos_Raw.Photo_ID DESC;
Link To Column Definitions: Coxes_Farm_Gardens

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Coxes_Farm_Photos_Backup
Query_Type: Select
Query_DateCreated: 04/02/2019 18:37:02
Query_DateChanged: 06/02/2019 16:28:28
Query_SQL: SELECT Backup_Site_Map.Directory, Backup_Site_Map.FIle_Name, Backup_Site_Map.Size, Backup_Site_Map.File_Timestamp, Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\","") AS Expr1 FROM Backup_Site_Map WHERE (((Backup_Site_Map.Directory) Like "*C:\Theo's Files\Photos\Coxes Farm\*") AND ((Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Coxes Farm_201307\" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Lych_Gate\" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Survey\" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Sylvia\" And (Replace([Directory],"C:\Theo's Files\Photos\Coxes Farm\",""))<>"Coxes Farm Selective Delapidations\")) ORDER BY Backup_Site_Map.Directory, Backup_Site_Map.FIle_Name;
Link To Column Definitions: Coxes_Farm_Photos_Backup

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Coxes_Farm_Pre_Repairs
Query_Type: Select
Query_DateCreated: 03/02/2019 12:40:34
Query_DateChanged: 23/02/2019 12:52:04
Query_SQL: SELECT Photos_Raw.* FROM Photos_Raw WHERE (((Photos_Raw.Photo_Type)="CoxesFarmPreRepairs") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Full") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmPreRepairs") AND (([Matching_Photo_FileName] & "")="") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmPreRepairs") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Medium - Larger") AND ((Photos_Raw.[Exclude?])=False)) ORDER BY Year(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual])) & Right(Month(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]))+100,2) DESC , Photos_Raw.Photo_Subgroup, IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]) DESC , Photos_Raw.Photo_Timestamp DESC , Photos_Raw.Photo_ID DESC;
Link To Column Definitions: Coxes_Farm_Pre_Repairs

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Coxes_Farm_Repairs
Query_Type: Select
Query_DateCreated: 12/01/2019 21:42:21
Query_DateChanged: 23/02/2019 12:37:49
Query_SQL: SELECT Photos_Raw.* FROM Photos_Raw WHERE (((Photos_Raw.Photo_Type)="CoxesFarmRepairs") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Full") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmRepairs") AND (([Matching_Photo_FileName] & "")="") AND ((Photos_Raw.[Exclude?])=False)) OR (((Photos_Raw.Photo_Type)="CoxesFarmRepairs") AND (([Matching_Photo_FileName] & "")<>"") AND ((Photos_Raw.Photo_Detail)="Medium - Larger") AND ((Photos_Raw.[Exclude?])=False)) ORDER BY Year(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual])) & Right(Month(IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]))+100,2) DESC , Photos_Raw.Photo_Subgroup, IIf([Photo_Timestamp_Manual]=0,[Photo_Timestamp],[Photo_Timestamp_Manual]) DESC , Photos_Raw.Photo_Timestamp DESC , Photos_Raw.Photo_ID DESC;
Link To Column Definitions: Coxes_Farm_Repairs

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Cross_Reference_By_Year
Query_Type: Select
Query_DateCreated: 14/05/2020 14:17:08
Query_DateChanged: 23/05/2020 11:58:13
Query_SQL: SELECT Year([Timestamp]) AS Expr1, Count(Cross_Reference.ID) AS CountOfID FROM Cross_Reference GROUP BY Year([Timestamp]);
Link To Column Definitions: Cross_Reference_By_Year

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Cross_Reference_Changes_By_Month
Query_Type: Select
Query_DateCreated: 27/06/2020 00:46:23
Query_DateChanged: 27/06/2020 00:47:53
Query_SQL: SELECT Year([Timestamp]) & "_" & Right(100+Month([Timestamp]),2) AS Expr1, Count(Cross_Reference_Changes.ID) AS CountOfID FROM Cross_Reference_Changes GROUP BY Year([Timestamp]) & "_" & Right(100+Month([Timestamp]),2) ORDER BY Year([Timestamp]) & "_" & Right(100+Month([Timestamp]),2);
Link To Column Definitions: Cross_Reference_Changes_By_Month

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Cross_Reference_Changes_By_Year
Query_Type: Select
Query_DateCreated: 24/05/2020 23:27:18
Query_DateChanged: 24/05/2020 23:28:15
Query_SQL: SELECT Year([Timestamp]) AS Expr1, Count(Cross_Reference_Changes.ID) AS CountOfID FROM Cross_Reference_Changes GROUP BY Year([Timestamp]);
Link To Column Definitions: Cross_Reference_Changes_By_Year

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Cross_Reference_Latest
Query_Type: Select
Query_DateCreated: 06/09/2015 23:45:01
Query_DateChanged: 06/09/2015 23:45:01
Query_SQL: SELECT Cross_Reference_Zapper.Calling_Type, Cross_Reference_Zapper.Calling_ID, Cross_Reference_Zapper.Calling_Timestamp FROM Cross_Reference_Zapper GROUP BY Cross_Reference_Zapper.Calling_Type, Cross_Reference_Zapper.Calling_ID, Cross_Reference_Zapper.Calling_Timestamp;
Link To Column Definitions: Cross_Reference_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Cross_Reference_MaxID
Query_Type: Select
Query_DateCreated: 24/05/2020 13:59:28
Query_DateChanged: 24/05/2020 13:59:28
Query_SQL: SELECT Max(Cross_Reference.ID) AS MaxOfID FROM Cross_Reference;
Link To Column Definitions: Cross_Reference_MaxID

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Current_Year_Papers_Actuals_Check
Query_Type: Select
Query_DateCreated: 17/06/2015 09:28:08
Query_DateChanged: 17/06/2015 09:30:17
Query_SQL: SELECT qryPapers.ID, Actual_Hours_Temp.[Actual Hours] FROM qryPapers RIGHT JOIN Actual_Hours_Temp ON qryPapers.IDs = Actual_Hours_Temp.ID WHERE (((Actual_Hours_Temp.[Actual Hours])>0) AND ((qryPapers.IDs) Is Null));
Link To Column Definitions: Current_Year_Papers_Actuals_Check

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Deleted_Queries
Query_Type: Select
Query_DateCreated: 23/06/2013 22:43:42
Query_DateChanged: 18/10/2015 17:04:11
Query_SQL: SELECT Query_Definitions_Historic.* FROM Query_Definitions_Historic LEFT JOIN Query_Definitions ON Query_Definitions_Historic.Query_Name = Query_Definitions.Query_Name WHERE (((Query_Definitions.Query_Name) Is Null)) ORDER BY Query_Definitions_Historic.Query_Name;
Link To Column Definitions: Deleted_Queries

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_Categories
Query_Type: Select
Query_DateCreated: 19/03/2018 20:34:55
Query_DateChanged: 04/04/2018 21:10:39
Query_SQL: SELECT Development_Log.Category FROM Development_Log GROUP BY Development_Log.Category;
Link To Column Definitions: Development_Log_Categories

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List
Query_Type: Select
Query_DateCreated: 18/05/2007 12:32:03
Query_DateChanged: 10/10/2019 10:44:16
Query_SQL: SELECT Development_Log.ID, Development_Log.Category, Development_Log.Priority, Development_Log.Development, Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period, Development_Log.Status FROM Development_Log ORDER BY Development_Log.Category, Development_Log.ID;
Link To Column Definitions: Development_Log_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Complete_Date
Query_Type: Select
Query_DateCreated: 28/03/2018 20:55:08
Query_DateChanged: 14/04/2020 12:41:00
Query_SQL: SELECT Development_Log.Implementation_Period, Development_Log.[Own_Website?], Development_Log.Category, Development_Log.Development, Development_Log.Status, Development_Log.Raised, Development_Log.Implemented, Development_Log.ID FROM Development_Log WHERE (((Development_Log.Status)="Complete")) ORDER BY Development_Log.Implementation_Period DESC , Development_Log.[Own_Website?], Development_Log.Category;
Link To Column Definitions: Development_Log_List_Complete_Date

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Complete_Others_Category
Query_Type: Select
Query_DateCreated: 28/03/2018 21:07:56
Query_DateChanged: 28/03/2018 21:14:46
Query_SQL: SELECT Development_Log.Category, Development_Log.Implementation_Period, Development_Log.Development, Development_Log.Status, Development_Log.Priority, Development_Log.Raised, Development_Log.Implemented, Development_Log.ID, Development_Log.[Own_Website?] FROM Development_Log WHERE (((Development_Log.Status)="Complete") AND ((Development_Log.[Own_Website?])=False)) ORDER BY Development_Log.Category, Development_Log.Implementation_Period DESC , Development_Log.Development;
Link To Column Definitions: Development_Log_List_Complete_Others_Category

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Complete_Others_Category_Recent
Query_Type: Select
Query_DateCreated: 16/06/2018 18:14:35
Query_DateChanged: 16/06/2018 18:15:42
Query_SQL: SELECT Development_Log.Category, Development_Log.Implementation_Period, Development_Log.Development, Development_Log.Status, Development_Log.Priority, Development_Log.Raised, Development_Log.Implemented, Development_Log.ID, Development_Log.[Own_Website?] FROM Development_Log INNER JOIN Next_Reporting_Month ON Development_Log.Implementation_Period = Next_Reporting_Month.File_Suffix WHERE (((Development_Log.Status)="Complete") AND ((Development_Log.[Own_Website?])=False)) ORDER BY Development_Log.Category, Development_Log.Implementation_Period DESC , Development_Log.Development;
Link To Column Definitions: Development_Log_List_Complete_Others_Category_Recent

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Complete_Others_Category_Recent_Previous
Query_Type: Select
Query_DateCreated: 09/10/2019 23:48:37
Query_DateChanged: 18/01/2020 23:21:13
Query_SQL: SELECT Development_Log.Category, Development_Log.Implementation_Period, Development_Log.Development, Development_Log.Status, Development_Log.Priority, Development_Log.Raised, Development_Log.Implemented, Development_Log.ID, Development_Log.[Own_Website?] FROM Development_Log INNER JOIN Next_Reporting_Month ON Development_Log.Implementation_Period = Next_Reporting_Month.File_Suffix_Previous WHERE (((Development_Log.Status)="Complete") AND ((Development_Log.[Own_Website?])=False)) ORDER BY Development_Log.Category, Development_Log.Implementation_Period DESC , Development_Log.Development;
Link To Column Definitions: Development_Log_List_Complete_Others_Category_Recent_Previous

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Complete_Own_Category
Query_Type: Select
Query_DateCreated: 19/03/2018 21:28:55
Query_DateChanged: 24/05/2018 00:41:51
Query_SQL: SELECT Development_Log.Category, Development_Log.Implementation_Period, Development_Log.Development, Development_Log.Status, Development_Log.Priority, Development_Log.Raised, Development_Log.Implemented, Development_Log.ID, Development_Log.[Own_Website?] FROM Development_Log WHERE (((Development_Log.Status)="Complete") AND ((Development_Log.[Own_Website?])=True)) ORDER BY Development_Log.Category, Development_Log.Implementation_Period DESC , Development_Log.Development;
Link To Column Definitions: Development_Log_List_Complete_Own_Category

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Complete_Own_Category_Recent
Query_Type: Select
Query_DateCreated: 16/06/2018 18:08:35
Query_DateChanged: 16/06/2018 18:10:19
Query_SQL: SELECT Development_Log.Category, Development_Log.Implementation_Period, Development_Log.Development, Development_Log.Status, Development_Log.Priority, Development_Log.Raised, Development_Log.Implemented, Development_Log.ID, Development_Log.[Own_Website?] FROM Development_Log INNER JOIN Next_Reporting_Month ON Development_Log.Implementation_Period = Next_Reporting_Month.File_Suffix WHERE (((Development_Log.Status)="Complete") AND ((Development_Log.[Own_Website?])=True)) ORDER BY Development_Log.Category, Development_Log.Implementation_Period DESC , Development_Log.Development;
Link To Column Definitions: Development_Log_List_Complete_Own_Category_Recent

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Complete_Own_Category_Recent_Previous
Query_Type: Select
Query_DateCreated: 09/10/2019 23:46:22
Query_DateChanged: 18/01/2020 23:20:49
Query_SQL: SELECT Development_Log.Category, Development_Log.Implementation_Period, Development_Log.Development, Development_Log.Status, Development_Log.Priority, Development_Log.Raised, Development_Log.Implemented, Development_Log.ID, Development_Log.[Own_Website?] FROM Development_Log INNER JOIN Next_Reporting_Month ON Development_Log.Implementation_Period = Next_Reporting_Month.File_Suffix_Previous WHERE (((Development_Log.Status)="Complete") AND ((Development_Log.[Own_Website?])=True)) ORDER BY Development_Log.Category, Development_Log.Implementation_Period DESC , Development_Log.Development;
Link To Column Definitions: Development_Log_List_Complete_Own_Category_Recent_Previous

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Outstanding_Others_Category
Query_Type: Select
Query_DateCreated: 21/03/2018 13:05:17
Query_DateChanged: 21/03/2018 13:12:13
Query_SQL: SELECT Development_Log.Category, Development_Log.Priority, Development_Log.Status, Development_Log.Development, Development_Log.[Own_Website?], Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period FROM Development_Log WHERE (((Development_Log.[Own_Website?])=No) AND (([Status] & "")<>"Complete")) ORDER BY Development_Log.Category, Development_Log.Development;
Link To Column Definitions: Development_Log_List_Outstanding_Others_Category

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Outstanding_Others_Category_Pri1
Query_Type: Select
Query_DateCreated: 29/03/2018 23:58:57
Query_DateChanged: 30/03/2018 00:00:11
Query_SQL: SELECT Development_Log.Category, Development_Log.Priority, Development_Log.Status, Development_Log.Development, Development_Log.[Own_Website?], Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period FROM Development_Log WHERE (((Development_Log.Priority)=1) AND ((Development_Log.[Own_Website?])=No) AND (([Status] & "")<>"Complete")) ORDER BY Development_Log.Category, Development_Log.Development;
Link To Column Definitions: Development_Log_List_Outstanding_Others_Category_Pri1

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Outstanding_Others_Priority
Query_Type: Select
Query_DateCreated: 20/03/2018 12:41:40
Query_DateChanged: 21/03/2018 13:11:38
Query_SQL: SELECT Development_Log.Priority, Development_Log.Category, Development_Log.Status, Development_Log.Development, Development_Log.[Own_Website?], Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period FROM Development_Log WHERE (((Development_Log.[Own_Website?])=No) AND (([Status] & "")<>"Complete")) ORDER BY Development_Log.Priority, Development_Log.Category, Development_Log.Development;
Link To Column Definitions: Development_Log_List_Outstanding_Others_Priority

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Outstanding_Own_Category
Query_Type: Select
Query_DateCreated: 21/03/2018 13:06:00
Query_DateChanged: 24/05/2018 00:47:18
Query_SQL: SELECT Development_Log.Category, Development_Log.Priority, Development_Log.Status, Development_Log.Development, Development_Log.[Own_Website?], Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period, Development_Log.ID FROM Development_Log WHERE (((Development_Log.[Own_Website?])=Yes) AND (([Status] & "")<>"Complete")) ORDER BY Development_Log.Category, Development_Log.Priority, Development_Log.Development;
Link To Column Definitions: Development_Log_List_Outstanding_Own_Category

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Outstanding_Own_Category_Pri1
Query_Type: Select
Query_DateCreated: 29/03/2018 23:58:03
Query_DateChanged: 24/05/2018 00:48:02
Query_SQL: SELECT Development_Log.Category, Development_Log.Priority, Development_Log.Status, Development_Log.Development, Development_Log.[Own_Website?], Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period, Development_Log.ID FROM Development_Log WHERE (((Development_Log.Priority)=1) AND ((Development_Log.[Own_Website?])=Yes) AND (([Status] & "")<>"Complete")) ORDER BY Development_Log.Category, Development_Log.Priority, Development_Log.Development;
Link To Column Definitions: Development_Log_List_Outstanding_Own_Category_Pri1

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_List_Outstanding_Own_Priority
Query_Type: Select
Query_DateCreated: 20/03/2018 12:30:02
Query_DateChanged: 24/05/2018 00:49:37
Query_SQL: SELECT Development_Log.Priority, Development_Log.Category, Development_Log.Status, Development_Log.Development, Development_Log.[Own_Website?], Development_Log.Raised, Development_Log.Implemented, Development_Log.Implementation_Period, Development_Log.ID FROM Development_Log WHERE (((Development_Log.[Own_Website?])=Yes) AND (([Status] & "")<>"Complete")) ORDER BY Development_Log.Priority, Development_Log.Category, Development_Log.Development;
Link To Column Definitions: Development_Log_List_Outstanding_Own_Priority

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Development_Log_Search
Query_Type: Select
Query_DateCreated: 27/03/2018 23:23:30
Query_DateChanged: 10/08/2018 22:15:29
Query_SQL: SELECT Development_Log.* FROM Development_Log WHERE (((Development_Log.Category) Like "*" & [Enter String] & "*")) OR (((Development_Log.Development) Like "*" & [Enter String] & "*")) ORDER BY Development_Log.Category, Development_Log.Development;
Link To Column Definitions: Development_Log_Search

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Directory_Structure_Suffixed
Query_Type: Select
Query_DateCreated: 26/06/2013 11:04:22
Query_DateChanged: 26/06/2013 11:04:22
Query_SQL: SELECT [Directory_Structure]![Directory] & "\" AS Directory, Directory_Structure.Directory_Short, Directory_Structure.Directory_Level, Directory_Structure.Timestamp_Logged, Directory_Structure.Do_Not_Parse, Directory_Structure.Updates_Only FROM Directory_Structure ORDER BY [Directory_Structure]![Directory] & "\";
Link To Column Definitions: Directory_Structure_Suffixed

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dodgy_Papers
Query_Type: Select
Query_DateCreated: 05/06/2015 15:06:30
Query_DateChanged: 06/06/2015 11:40:26
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.Abstract_Quality, Papers.Comments, Papers.Abstract, Papers.Write_Up_Note_ID FROM Paper_IDs INNER JOIN Papers ON Paper_IDs.Paper_ID = Papers.ID ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Dodgy_Papers

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dud_Abstracts_Books
Query_Type: Select
Query_DateCreated: 24/11/2013 18:39:33
Query_DateChanged: 24/11/2013 19:19:05
Query_SQL: SELECT Books.Author, Books.Title, Books.Priority, Books.Status, IIf([Book_Summary_Refs]![ID1] Is Not Null,[Book_Summary],0) AS More, Left([Comments],200) AS Source, Books.Pages, Books.ID1 FROM Books LEFT JOIN Book_Summary_Refs ON Books.ID1 = Book_Summary_Refs.ID1 WHERE (((Books.Abstract) Not Like "*|Colour_*") AND ((Books.[Abstract_Fixed?])=No) AND (([Abstract] & "")<>"")) ORDER BY Books.Author, Books.Title, Books.Priority;
Link To Column Definitions: Dud_Abstracts_Books

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dud_Abstracts_Books (Letters)
Query_Type: Select
Query_DateCreated: 24/11/2013 18:46:41
Query_DateChanged: 24/11/2013 18:47:16
Query_SQL: SELECT Left([Author],1) AS Letter FROM Dud_Abstracts_Books GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Dud_Abstracts_Books (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dud_Abstracts_Books_Updateable
Query_Type: Select
Query_DateCreated: 24/11/2013 18:48:21
Query_DateChanged: 27/11/2014 18:43:33
Query_SQL: SELECT Books.Author, Books.Title, Len([Abstract]) AS Length, Books.Priority, Books.ID1, Books.Status, Books.Comments, Books.Abstract, Books.Abstract_Quality, Books.Location, Books.Pages, Books.[Abstract_Fixed?] FROM Books WHERE (((Books.Abstract) Not Like "*|Colour_*") AND ((Books.[Abstract_Fixed?])=No) AND (([Abstract] & "")<>"")) ORDER BY Books.Author, Books.Title, Len([Abstract]), Books.Priority;
Link To Column Definitions: Dud_Abstracts_Books_Updateable

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dud_Abstracts_Papers
Query_Type: Select
Query_DateCreated: 24/11/2013 10:56:14
Query_DateChanged: 13/11/2016 11:44:43
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.Priority, Papers.Status, IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, Papers.ID, Papers.[Abstract_Fixed?] FROM Papers WHERE (((Papers.Abstract) Not Like "*|Colour_*") AND ((Papers.[Abstract_Fixed?])=No) AND (([Abstract] & "")<>"")) ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Dud_Abstracts_Papers

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dud_Abstracts_Papers (Letters)
Query_Type: Select
Query_DateCreated: 24/11/2013 12:11:57
Query_DateChanged: 24/11/2013 18:08:55
Query_SQL: SELECT Left([Author],1) AS Letter FROM Dud_Abstracts_Papers GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Dud_Abstracts_Papers (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dud_Abstracts_Papers_Updateable
Query_Type: Select
Query_DateCreated: 24/11/2013 12:16:03
Query_DateChanged: 12/05/2015 10:16:00
Query_SQL: SELECT Papers.Author, Papers.Title, Len([Abstract]) AS Length, Papers.Priority, Papers.Status, Papers.Comments, Papers.Abstract, Papers.Abstract_Quality, Papers.Source, Papers.Pages, Papers.ID, Papers.[Abstract_Fixed?], Papers.Write_Up_Note_ID FROM Papers WHERE (((Papers.Abstract) Not Like "*|Colour_*") AND ((Papers.[Abstract_Fixed?])=No) AND (([Abstract] & "")<>"")) ORDER BY Papers.Author, Papers.Title, Len([Abstract]), Papers.Priority;
Link To Column Definitions: Dud_Abstracts_Papers_Updateable

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dud_Cross_References_This_Year
Query_Type: Select
Query_DateCreated: 23/05/2020 12:31:30
Query_DateChanged: 23/05/2020 13:06:11
Query_SQL: SELECT Year([Timestamp]) AS Timestamp_Year, Count(Cross_Reference.Timestamp) AS CountOfTimestamp, Year([Last_Run_Start]) AS Year_Last_Regen, MonthName(Month([Last_Run_Start])) AS Month_Last_Regen FROM Cross_Reference, Website_Regen_Last_Run_Start WHERE (((Cross_Reference.Timestamp)<[Last_Run_Start]-1)) GROUP BY Year([Timestamp]), Year([Last_Run_Start]), MonthName(Month([Last_Run_Start]));
Link To Column Definitions: Dud_Cross_References_This_Year

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dud_DevLog_Descriptions
Query_Type: Select
Query_DateCreated: 28/07/2018 21:07:27
Query_DateChanged: 28/07/2018 21:07:27
Query_SQL: SELECT * FROM Development_Log WHERE (((Development_Log.Development) Like "*|99|*")) OR (((Development_Log.Development) Like "*|##|*"));
Link To Column Definitions: Dud_DevLog_Descriptions

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dup_Papers
Query_Type: Select
Query_DateCreated: 26/11/2005 10:22:02
Query_DateChanged: 26/11/2005 10:39:24
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.ID AS ID, Papers.Pages AS Pages, Papers.Book AS Book, Papers.Comments AS Comments FROM (Dup_Papers1 INNER JOIN Papers ON (Dup_Papers1.Title = Papers.Title) AND (Dup_Papers1.Author = Papers.Author)) INNER JOIN Papers AS Papers_1 ON (Dup_Papers1.Title = Papers_1.Title) AND (Dup_Papers1.Author = Papers_1.Author) WHERE (((Papers.ID)<>[Papers_1]![ID])) ORDER BY Papers.Author, Papers.Title, Papers.Book;
Link To Column Definitions: Dup_Papers

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Dup_Papers1
Query_Type: Select
Query_DateCreated: 26/11/2005 10:19:12
Query_DateChanged: 26/11/2005 10:19:16
Query_SQL: SELECT Papers.Author, Papers.Title, Count(Papers.ID) AS CountOfID FROM Papers INNER JOIN Papers AS Papers_1 ON (Papers.Title = Papers_1.Title) AND (Papers.Author = Papers_1.Author) GROUP BY Papers.Author, Papers.Title HAVING (((Count(Papers.ID))>1)) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Dup_Papers1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Electronic Resources
Query_Type: Select
Query_DateCreated: 07/05/2007 10:45:58
Query_DateChanged: 07/05/2007 11:11:36
Query_SQL: SELECT ElectronicPapers.* FROM ElectronicPapers ORDER BY ElectronicPapers.Publication;
Link To Column Definitions: Electronic Resources

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Electronic Resources (Letters)
Query_Type: Select
Query_DateCreated: 07/05/2007 10:46:10
Query_DateChanged: 07/05/2007 11:11:31
Query_SQL: SELECT Left([Publication],1) AS Letter FROM ElectronicPapers GROUP BY Left([Publication],1) ORDER BY Left([Publication],1);
Link To Column Definitions: Electronic Resources (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Full_Link_Same_Directory_Updt
Query_Type: Select
Query_DateCreated: 04/08/2018 12:26:47
Query_DateChanged: 04/08/2018 12:26:47
Query_SQL: SELECT Raw_Links.* FROM Raw_Links WHERE (((Raw_Links.Link_Type)="Same Directory") AND ((Raw_Links.Full_Link) Is Null));
Link To Column Definitions: Full_Link_Same_Directory_Updt

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Functor_Descriptions_List
Query_Type: Select
Query_DateCreated: 25/05/2020 12:54:53
Query_DateChanged: 25/05/2020 12:54:53
Query_SQL: SELECT "+C" & [Procedure_Name] & "C+" AS [Procedure Name], Functor_Descriptions.Functor_Description FROM Functor_Descriptions ORDER BY "+C" & [Procedure_Name] & "C+";
Link To Column Definitions: Functor_Descriptions_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Home_Page_Static_Page_Backups
Query_Type: Select
Query_DateCreated: 07/01/2016 09:48:12
Query_DateChanged: 07/01/2016 10:09:06
Query_SQL: SELECT Full_Backup_Site_Map_Temp.* FROM Full_Backup_Site_Map_Temp WHERE (((Full_Backup_Site_Map_Temp.File_Name) Like "*phil0*") AND ((Full_Backup_Site_Map_Temp.[Delete?])=False) AND ((Right([File_Name],4))=".htm")) ORDER BY Full_Backup_Site_Map_Temp.File_Name, Full_Backup_Site_Map_Temp.File_Timestamp DESC;
Link To Column Definitions: Home_Page_Static_Page_Backups

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Full
Query_Type: Select
Query_DateCreated: 29/04/2007 11:03:07
Query_DateChanged: 18/09/2013 18:26:19
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.Priority, [Sub-Topics].[Sub-Topic], IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, IIf([Papers]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], Papers.ID FROM Papers INNER JOIN [Sub-Topics] ON Papers.[Sub-Topic] = [Sub-Topics].ID WHERE (((Papers.Author)<>"Admin") AND ((Papers.Topic)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.Topic2)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.Topic3)=104)) ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Identity Papers - Abstracts - Full

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Full - SubTopic
Query_Type: Select
Query_DateCreated: 20/05/2007 12:50:17
Query_DateChanged: 03/12/2011 13:11:43
Query_SQL: SELECT [Sub-Topics].[Sub-Topic], Papers.Author, Papers.Title, Papers.Priority, IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, IIf([Papers]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], [Sub-Topics].ID AS [ID (Sub-Topics)], Papers.ID AS [ID (Papers)] FROM (Papers INNER JOIN Identity_Papers_SubTopic_All ON Papers.ID = Identity_Papers_SubTopic_All.ID) INNER JOIN [Sub-Topics] ON Identity_Papers_SubTopic_All.[Sub-Topic] = [Sub-Topics].ID WHERE (((Papers.Author)<>"Admin")) ORDER BY [Sub-Topics].[Sub-Topic], Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Identity Papers - Abstracts - Full - SubTopic

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Full - SubTopic (Titles)
Query_Type: Select
Query_DateCreated: 20/05/2007 13:19:33
Query_DateChanged: 12/04/2009 19:27:51
Query_SQL: SELECT [Sub-Topics].[Sub-Topic], [Sub-Topics].ID FROM (Papers INNER JOIN Identity_Papers_SubTopic_All ON Papers.ID = Identity_Papers_SubTopic_All.ID) INNER JOIN [Sub-Topics] ON Identity_Papers_SubTopic_All.[Sub-Topic] = [Sub-Topics].ID GROUP BY [Sub-Topics].[Sub-Topic], [Sub-Topics].ID ORDER BY [Sub-Topics].[Sub-Topic];
Link To Column Definitions: Identity Papers - Abstracts - Full - SubTopic (Titles)

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Full (Letters)
Query_Type: Select
Query_DateCreated: 05/05/2007 12:23:46
Query_DateChanged: 18/09/2013 18:27:05
Query_SQL: SELECT Left([Author],1) AS Letter FROM Papers WHERE (((Papers.Topic)=104)) OR (((Papers.Topic2)=104)) OR (((Papers.Topic3)=104)) GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Identity Papers - Abstracts - Full (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Read
Query_Type: Select
Query_DateCreated: 27/11/2005 11:36:21
Query_DateChanged: 18/09/2013 18:27:34
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.Priority, [Sub-Topics].[Sub-Topic], IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, Papers.ID FROM Papers INNER JOIN [Sub-Topics] ON Papers.[Sub-Topic] = [Sub-Topics].ID WHERE (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic2)=104)) OR (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes) AND ((Papers.Topic3)=104)) ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Identity Papers - Abstracts - Read

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Read - SubTopic
Query_Type: Select
Query_DateCreated: 19/05/2007 09:57:16
Query_DateChanged: 05/08/2017 22:17:14
Query_SQL: SELECT [Sub-Topics].[Sub-Topic], Papers.Author, Papers.Title, Papers.Priority, IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, [Sub-Topics].ID AS [ID (Sub-Topics)], Papers.ID AS [ID (Papers)] FROM (Papers INNER JOIN Identity_Papers_SubTopic_All ON Papers.ID = Identity_Papers_SubTopic_All.ID) INNER JOIN [Sub-Topics] ON Identity_Papers_SubTopic_All.[Sub-Topic] = [Sub-Topics].ID WHERE (((Papers.Author)<>"Admin") AND ((Papers.[Read?])=Yes)) ORDER BY [Sub-Topics].[Sub-Topic], Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Identity Papers - Abstracts - Read - SubTopic

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Read - SubTopic (Titles)
Query_Type: Select
Query_DateCreated: 20/05/2007 10:35:44
Query_DateChanged: 12/04/2009 19:16:02
Query_SQL: SELECT [Sub-Topics].[Sub-Topic], [Sub-Topics].ID FROM (Papers INNER JOIN Identity_Papers_SubTopic_All ON Papers.ID = Identity_Papers_SubTopic_All.ID) INNER JOIN [Sub-Topics] ON Identity_Papers_SubTopic_All.[Sub-Topic] = [Sub-Topics].ID WHERE (((Papers.[Read?])=Yes)) GROUP BY [Sub-Topics].[Sub-Topic], [Sub-Topics].ID ORDER BY [Sub-Topics].[Sub-Topic];
Link To Column Definitions: Identity Papers - Abstracts - Read - SubTopic (Titles)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Read (Letters)
Query_Type: Select
Query_DateCreated: 05/05/2007 16:43:05
Query_DateChanged: 18/09/2013 18:38:09
Query_SQL: SELECT Left([Author],1) AS Letter FROM Papers WHERE (((Papers.[Read?])=Yes) AND ((Papers.Topic)=104)) GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Identity Papers - Abstracts - Read (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity Papers - Abstracts - Read (Updateable)
Query_Type: Select
Query_DateCreated: 27/04/2007 19:38:48
Query_DateChanged: 18/09/2013 18:38:27
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.Priority, Papers.[Sub-Topic], Papers.Abstract, Papers.Source, Papers.Pages, Papers.Location FROM Papers WHERE (((Papers.Topic)=104) AND ((Papers.[Read?])=Yes)) ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Identity Papers - Abstracts - Read (Updateable)

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity_Papers_SubTopic_All
Query_Type: Select
Query_DateCreated: 12/04/2009 18:42:00
Query_DateChanged: 12/04/2009 18:42:00
Query_SQL: SELECT Identity_Papers_SubTopic_Union.ID, Identity_Papers_SubTopic_Union.[Sub-Topic] FROM Identity_Papers_SubTopic_Union GROUP BY Identity_Papers_SubTopic_Union.ID, Identity_Papers_SubTopic_Union.[Sub-Topic];
Link To Column Definitions: Identity_Papers_SubTopic_All

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity_Papers_SubTopic1
Query_Type: Select
Query_DateCreated: 12/04/2009 18:37:42
Query_DateChanged: 18/09/2013 18:38:56
Query_SQL: SELECT Papers.ID, Papers.[Sub-Topic] FROM Papers INNER JOIN Paper_Topic_All ON Papers.ID = Paper_Topic_All.ID WHERE (((Paper_Topic_All.Topic)=104));
Link To Column Definitions: Identity_Papers_SubTopic1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity_Papers_SubTopic2
Query_Type: Select
Query_DateCreated: 12/04/2009 18:38:31
Query_DateChanged: 18/09/2013 18:39:19
Query_SQL: SELECT Papers.ID, Papers.[Sub-Topic2] AS [Sub-Topic] FROM Papers INNER JOIN Paper_Topic_All ON Papers.ID = Paper_Topic_All.ID WHERE (((Papers.[Sub-Topic2]) Is Not Null) AND ((Paper_Topic_All.Topic)=104));
Link To Column Definitions: Identity_Papers_SubTopic2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Identity_Papers_SubTopic3
Query_Type: Select
Query_DateCreated: 12/04/2009 18:39:11
Query_DateChanged: 18/09/2013 18:39:40
Query_SQL: SELECT Papers.ID, Papers.[Sub-Topic3] AS [Sub-Topic] FROM Papers INNER JOIN Paper_Topic_All ON Papers.ID = Paper_Topic_All.ID WHERE (((Papers.[Sub-Topic3]) Is Not Null) AND ((Paper_Topic_All.Topic)=104));
Link To Column Definitions: Identity_Papers_SubTopic3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Image_Usage
Query_Type: Select
Query_DateCreated: 22/06/2013 10:57:36
Query_DateChanged: 25/06/2013 00:10:05
Query_SQL: SELECT Site_Map.* FROM Site_Map WHERE (((Site_Map.FIle_Name) Like "*.jpg*" Or (Site_Map.FIle_Name) Like "*.gif*")) ORDER BY Site_Map.Directory, Site_Map.FIle_Name;
Link To Column Definitions: Image_Usage

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Latest_Archives
Query_Type: Select
Query_DateCreated: 06/12/2009 10:37:01
Query_DateChanged: 31/07/2013 11:02:37
Query_SQL: SELECT Notes_Archive.ID, Notes_Archive.Item_Title, Notes_Archive.Item_Text, Notes_Archive.Note_Group, Notes_Archive.Last_Changed, Notes_Archive.Timestamp, Now()*1-[Timestamp]/1000 AS Age, System_Parameters.Notes_Archive_Days FROM Notes_Archive, System_Parameters WHERE (((Now()*1-[Timestamp]/1000)<[Notes_Archive_Days])) ORDER BY Now()*1-[Timestamp]/1000;
Link To Column Definitions: Latest_Archives

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Location_Group_IDs
Query_Type: Select
Query_DateCreated: 09/09/2013 11:49:43
Query_DateChanged: 09/09/2013 11:49:43
Query_SQL: SELECT Locations.Location_Group, Min(Locations.ID) AS MinOfID FROM Locations GROUP BY Locations.Location_Group ORDER BY Locations.Location_Group;
Link To Column Definitions: Location_Group_IDs

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Location_Supergroup_IDs
Query_Type: Select
Query_DateCreated: 09/09/2013 11:49:01
Query_DateChanged: 09/09/2013 11:49:02
Query_SQL: SELECT Locations.Location_SuperGroup, Min(Locations.ID) AS MinOfID FROM Locations GROUP BY Locations.Location_SuperGroup ORDER BY Locations.Location_SuperGroup;
Link To Column Definitions: Location_Supergroup_IDs

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Missing Priority Tasks For Timesheet
Query_Type: Select
Query_DateCreated: 23/10/2009 11:39:41
Query_DateChanged: 14/04/2014 08:56:06
Query_SQL: SELECT qrySources.IDs, qrySources.[A+T] AS Paper, GetTopic([Papers]![Topic],[Papers]![Topic2],[Papers]![Topic3]) AS Subject, qrySources.[Sub-Topic], Nz([qrySources]![Hours Left]) AS Estimate FROM (Papers INNER JOIN qrySources ON Papers.ID = qrySources.ID1) LEFT JOIN Subject_Plan ON qrySources.IDs = Subject_Plan.ID WHERE (((qrySources.IDs) Like "T*") AND ((Subject_Plan.ID) Is Null) AND ((qrySources.Priority)=0)) ORDER BY GetTopic([Papers]![Topic],[Papers]![Topic2],[Papers]![Topic3]), qrySources.[Sub-Topic], qrySources.[A+T];
Link To Column Definitions: Missing Priority Tasks For Timesheet

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Missing_Papers_For_Actuals
Query_Type: Select
Query_DateCreated: 17/06/2015 09:12:22
Query_DateChanged: 17/06/2015 09:12:22
Query_SQL: SELECT Paper_Actuals.* FROM Paper_Actuals LEFT JOIN Papers ON Paper_Actuals.ID = Papers.ID WHERE (((Papers.ID) Is Null));
Link To Column Definitions: Missing_Papers_For_Actuals

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: New_Year_Crosstab_Prime_NewYear_SubList
Query_Type: Select
Query_DateCreated: 03/10/2010 18:53:55
Query_DateChanged: 03/10/2010 18:54:57
Query_SQL: SELECT Year_Crosstab_Prime.Task_Group, Year_Crosstab_Prime.Group, Year_Crosstab_Prime.Subgroup FROM Year_Crosstab_Prime GROUP BY Year_Crosstab_Prime.Task_Group, Year_Crosstab_Prime.Group, Year_Crosstab_Prime.Subgroup ORDER BY Year_Crosstab_Prime.Task_Group, Year_Crosstab_Prime.Group, Year_Crosstab_Prime.Subgroup;
Link To Column Definitions: New_Year_Crosstab_Prime_NewYear_SubList

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: NewSubTopics_GEN
Query_Type: Select
Query_DateCreated: 04/12/2011 18:05:05
Query_DateChanged: 21/01/2016 09:48:28
Query_SQL: SELECT Topics.ID, Topics.Topic, Topics.Rationale, Topics.File_Type FROM Topics LEFT JOIN [Sub-Topics] ON Topics.Topic = [Sub-Topics].[Sub-Topic] WHERE ((([Sub-Topics].ID) Is Null));
Link To Column Definitions: NewSubTopics_GEN

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Next_Qtr_Plans
Query_Type: Select
Query_DateCreated: 09/04/2013 17:55:19
Query_DateChanged: 09/04/2013 18:01:52
Query_SQL: SELECT Project_Plans.Project, Avg(Project_Plans.Weekly_Hours) AS [Average Next Qtr Plan] FROM Reporting_Periods, Project_Plans WHERE (((Project_Plans.Period)>=[Start_Next_Quarter] And (Project_Plans.Period)<=[End_Next_Quarter])) GROUP BY Project_Plans.Project;
Link To Column Definitions: Next_Qtr_Plans

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Archive_Regen_Ranges_Latest
Query_Type: Select
Query_DateCreated: 20/05/2018 00:13:12
Query_DateChanged: 20/05/2018 00:13:12
Query_SQL: SELECT "Note_Archive_Regen_Ranges" AS Title, Min(Note_Archive_Regen_Ranges.Latest_Note_Range_Update) AS MinOfLatest_Note_Range_Update FROM Note_Archive_Regen_Ranges GROUP BY "Note_Archive_Regen_Ranges";
Link To Column Definitions: Note_Archive_Regen_Ranges_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Book_Link_Latest_Add2
Query_Type: Select
Query_DateCreated: 24/07/2010 08:43:22
Query_DateChanged: 24/07/2010 08:44:12
Query_SQL: SELECT Note_Book_Links.Note, Note_Book_Links.Note_Ref, Note_Book_Links.Book, Note_Book_Links.Timestamp, Note_Book_Links.Origin FROM Note_Book_Links WHERE (((Note_Book_Links.Timestamp)<>1));
Link To Column Definitions: Note_Book_Link_Latest_Add2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Book_Links_List
Query_Type: Select
Query_DateCreated: 29/03/2014 17:42:21
Query_DateChanged: 29/03/2014 18:00:11
Query_SQL: SELECT Note_Book_Links_Prelim.Author, Note_Book_Links_Prelim.Title, IIf([MinOfTimestamp]=0,[BooksToNoteLink],".") AS [Current Note], IIf([MinOfTimestamp]<>0,[BooksToNoteLink],".") AS [Archive Note Only] FROM Note_Book_Links_Prelim INNER JOIN Book_Note_Link_Refs ON Note_Book_Links_Prelim.ID1 = Book_Note_Link_Refs.ID1 ORDER BY Note_Book_Links_Prelim.Author, Note_Book_Links_Prelim.Title;
Link To Column Definitions: Note_Book_Links_List

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Book_Links_List (Letters)
Query_Type: Select
Query_DateCreated: 29/03/2014 18:10:23
Query_DateChanged: 29/03/2014 18:10:23
Query_SQL: SELECT Left([Author],1) AS Letter FROM Note_Book_Links_List GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Note_Book_Links_List (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Book_Links_Prelim
Query_Type: Select
Query_DateCreated: 29/03/2014 17:36:17
Query_DateChanged: 29/03/2014 17:43:43
Query_SQL: SELECT Books.Author, Books.Title, Books.ID1, Min(Note_Book_Links.Timestamp) AS MinOfTimestamp, Max(Note_Book_Links.Timestamp) AS MaxOfTimestamp FROM Note_Book_Links INNER JOIN Books ON Note_Book_Links.Book = Books.ID1 GROUP BY Books.Author, Books.Title, Books.ID1 ORDER BY Books.Author, Books.Title;
Link To Column Definitions: Note_Book_Links_Prelim

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Lengths_PI
Query_Type: Select
Query_DateCreated: 26/05/2010 14:45:47
Query_DateChanged: 03/07/2015 18:20:05
Query_SQL: SELECT Len([Item_Text]) AS Length, Notes.* FROM Notes WHERE (((Notes.Note_Group)=1)) ORDER BY Len([Item_Text]), Notes.Item_Title;
Link To Column Definitions: Note_Lengths_PI

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Links_Latest
Query_Type: Select
Query_DateCreated: 06/08/2007 17:40:10
Query_DateChanged: 06/08/2007 17:40:28
Query_SQL: SELECT Note_Links.Note_1, Note_Links.Note_1_Ref, Note_Links.Note_2, Note_Links.Note_2_Ref, Note_Links.Note_1_FN_ID, Max(Note_Links.Timestamp) AS MaxOfTimestamp FROM Note_Links GROUP BY Note_Links.Note_1, Note_Links.Note_1_Ref, Note_Links.Note_2, Note_Links.Note_2_Ref, Note_Links.Note_1_FN_ID;
Link To Column Definitions: Note_Links_Latest

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_List
Query_Type: Select
Query_DateCreated: 13/07/2013 14:21:40
Query_DateChanged: 25/07/2013 15:27:34
Query_SQL: SELECT Notes.* FROM Notes ORDER BY Notes.Item_Title;
Link To Column Definitions: Note_List

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Paper_Link_Latest_Add2
Query_Type: Select
Query_DateCreated: 23/07/2010 20:07:03
Query_DateChanged: 23/07/2010 20:26:00
Query_SQL: SELECT Note_Paper_Links.Note, Note_Paper_Links.Note_Ref, Note_Paper_Links.Paper, Note_Paper_Links.Timestamp, Note_Paper_Links.Origin FROM Note_Paper_Links WHERE (((Note_Paper_Links.Timestamp)<>1));
Link To Column Definitions: Note_Paper_Link_Latest_Add2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Paper_Links_List
Query_Type: Select
Query_DateCreated: 30/03/2014 19:14:16
Query_DateChanged: 30/03/2014 19:16:57
Query_SQL: SELECT Note_Paper_Links_Prelim.Author, Note_Paper_Links_Prelim.Title, IIf([MinOfTimestamp]=0,[PapersToNoteLink],".") AS [Current Note], IIf([MinOfTimestamp]<>0,[PapersToNoteLink],".") AS [Archive Note Only] FROM Note_Paper_Links_Prelim INNER JOIN Paper_Note_Link_Refs ON Note_Paper_Links_Prelim.ID = Paper_Note_Link_Refs.ID ORDER BY Note_Paper_Links_Prelim.Author, Note_Paper_Links_Prelim.Title;
Link To Column Definitions: Note_Paper_Links_List

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Paper_Links_List (Letters)
Query_Type: Select
Query_DateCreated: 30/03/2014 19:15:07
Query_DateChanged: 31/10/2018 18:18:14
Query_SQL: SELECT Left([Author],1) AS Letter FROM Note_Paper_Links_List GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Note_Paper_Links_List (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Paper_Links_Prelim
Query_Type: Select
Query_DateCreated: 30/03/2014 19:05:07
Query_DateChanged: 30/03/2014 19:07:08
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.ID, Min(Note_Paper_Links.Timestamp) AS MinOfTimestamp, Max(Note_Paper_Links.Timestamp) AS MaxOfTimestamp FROM Note_Paper_Links INNER JOIN Papers ON Note_Paper_Links.Paper = Papers.ID GROUP BY Papers.Author, Papers.Title, Papers.ID ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Note_Paper_Links_Prelim

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Regen_Ranges_Latest
Query_Type: Select
Query_DateCreated: 20/05/2018 00:09:34
Query_DateChanged: 20/05/2018 00:09:34
Query_SQL: SELECT "Note_Regen_Ranges" AS Title, Min(Note_Regen_Ranges.Latest_Note_Range_Update) AS MinOfLatest_Note_Range_Update FROM Note_Regen_Ranges GROUP BY "Note_Regen_Ranges";
Link To Column Definitions: Note_Regen_Ranges_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Usage_Temp_MinLevel
Query_Type: Select
Query_DateCreated: 19/08/2007 17:07:04
Query_DateChanged: 19/08/2007 17:07:04
Query_SQL: SELECT Note_Usage_Temp.Note_ID, Min(Note_Usage_Temp.Note_Level) AS MinOfNote_Level FROM Note_Usage_Temp GROUP BY Note_Usage_Temp.Note_ID;
Link To Column Definitions: Note_Usage_Temp_MinLevel

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Note_Usage_Temp_MinLevel_Dups
Query_Type: Select
Query_DateCreated: 20/08/2007 09:37:45
Query_DateChanged: 20/08/2007 09:45:54
Query_SQL: SELECT Note_Usage_Temp.Note_ID, Count(Note_Usage_Temp.Note_Level) AS CountOfNote_Level, Min(Note_Usage_Temp.Note_Usage) AS MinOfNote_Usage FROM Note_Usage_Temp GROUP BY Note_Usage_Temp.Note_ID HAVING (((Count(Note_Usage_Temp.Note_Level))>1));
Link To Column Definitions: Note_Usage_Temp_MinLevel_Dups

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Animadversions
Query_Type: Select
Query_DateCreated: 21/08/2007 14:32:32
Query_DateChanged: 24/07/2017 17:32:35
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=8)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Animadversions

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_Files
Query_Type: Select
Query_DateCreated: 08/04/2014 17:58:00
Query_DateChanged: 21/06/2014 12:58:37
Query_SQL: SELECT Backup_Site_Map.FIle_Name, Backup_Site_Map.Size, Val(IIf(Len([FIle_Name])<15,Mid([FIle_Name],InStr([FIle_Name],"_")+1,InStr([FIle_Name],".")-InStr([FIle_Name],"_")-1),Mid([FIle_Name],InStr([FIle_Name],"_")+1,InStr(InStr([FIle_Name],"_")+1,[FIle_Name],"_")-InStr([FIle_Name],"_")-1))) AS ID, IIf(Len([FIle_Name])<15,"",Mid([FIle_Name],InStr(InStr([FIle_Name],"_")+1,[FIle_Name],"_")+1,InStr([FIle_Name],".")-InStr(InStr([FIle_Name],"_")+1,[FIle_Name],"_")-1)) AS [Timestamp] FROM Backup_Site_Map WHERE (((Backup_Site_Map.FIle_Name) Like "notes*" And (Backup_Site_Map.FIle_Name) Not Like "*print*" And (Backup_Site_Map.FIle_Name)<"Notes_a") AND ((Left([Directory],Len("C:\Theo's Files\Websites\Theo's Website\")))="C:\Theo's Files\Websites\Theo's Website\")) ORDER BY Backup_Site_Map.FIle_Name;
Link To Column Definitions: Notes_Archive_Files

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_Files_Checker
Query_Type: Select
Query_DateCreated: 10/07/2015 13:19:32
Query_DateChanged: 10/07/2015 17:31:41
Query_SQL: SELECT Notes_Archive_Files_Checker_Union.[Note ID], Notes_Archive_Files_Checker_Union.[(Archived) Note Title], Notes_Archive_Files_Checker_Union.Timestamp, Notes_Archive_Files_Checker_Union.[Archived Timestamp], Notes_Archive_Files_Checker_Union.[File Size (Bytes)], Notes_Archive_Files_Checker_Union.[Note Title], Notes_Archive_Files_Checker_Union.Note_Group, Notes_Archive_Files_Checker_Union.Link FROM Notes_Archive_Files_Checker_Union ORDER BY Notes_Archive_Files_Checker_Union.[Note ID], Notes_Archive_Files_Checker_Union.Timestamp DESC , Notes_Archive_Files_Checker_Union.[Archived Timestamp] DESC;
Link To Column Definitions: Notes_Archive_Files_Checker

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_Files_Checker_1
Query_Type: Select
Query_DateCreated: 08/04/2014 18:02:50
Query_DateChanged: 10/07/2015 13:03:56
Query_SQL: SELECT Notes.ID AS [Note ID], Note_Groups.Note_Group, [Notes]![Last_Changed] AS [Timestamp], "Notes_" & [notes]![ID] & ".htm" AS Link, Len([Item_Text]) AS [File Size (Bytes)], [Notes]![Item_Title] AS [Note Title], [Notes]![Item_Title] AS [(Archived) Note Title], "Live Note" AS [Archived Timestamp] FROM Notes INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID WHERE (((Notes.ID)>0)) ORDER BY Notes.ID, [Notes]![Last_Changed], "Notes_" & [notes]![ID] & ".htm" DESC;
Link To Column Definitions: Notes_Archive_Files_Checker_1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_Files_Checker_2
Query_Type: Select
Query_DateCreated: 10/07/2015 13:05:47
Query_DateChanged: 10/07/2015 13:31:00
Query_SQL: SELECT [Notes_Archive]![ID] AS [Note ID], Note_Groups.Note_Group, [Notes_Archive]![Timestamp] AS [Timestamp], "Notes_" & [Notes_Archive]![ID] & "_" & [Notes_Archive]![Timestamp] & ".htm" AS Link, Len([Notes_Archive]![Item_Text]) AS [File Size (Bytes)], Notes.Item_Title AS [Note Title], Notes_Archive.Item_Title AS [(Archived) Note Title], Notes_Archive.Timestamp AS [Archived Timestamp] FROM (Notes INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID) INNER JOIN Notes_Archive ON Notes.ID = Notes_Archive.ID WHERE ((([Notes_Archive]![ID])>0)) ORDER BY [Notes_Archive]![ID], [Notes_Archive]![Timestamp], "Notes_" & [Notes_Archive]![ID] & "_" & [Notes_Archive]![Timestamp] & ".htm" DESC;
Link To Column Definitions: Notes_Archive_Files_Checker_2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_Files_Checker_Saved
Query_Type: Select
Query_DateCreated: 10/07/2015 12:51:40
Query_DateChanged: 10/07/2015 12:51:40
Query_SQL: SELECT Val([Notes_Archive_Files]![ID]) AS [Note ID], Note_Groups.Note_Group, IIf([Notes_Archive_Files]![Timestamp] & ""="",[Notes]![Last_Changed],[Notes_Archive_Files]![Timestamp]) AS [Timestamp], Notes_Archive_Files.FIle_Name AS Link, Notes_Archive_Files.Size AS [File Size (Bytes)], Notes_Archive_List_Checker.Notes.Item_Title AS [Note Title], IIf([Notes_Archive_Files]![Timestamp] & ""="",[Notes]![Item_Title],[Notes_Archive_List_Checker]![Notes_Archive.Item_Title]) AS [(Archived) Note Title], IIf([Notes_Archive_Files]![Timestamp] & ""="","Live Note",[Notes_Archive_List_Checker]![Timestamp]) AS [Archived Timestamp] FROM ((Notes_Archive_Files LEFT JOIN Notes_Archive_List_Checker ON Notes_Archive_Files.FIle_Name = Notes_Archive_List_Checker.Archive_Filename) INNER JOIN Notes ON Notes_Archive_Files.ID = Notes.ID) INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID WHERE (((Val([Notes_Archive_Files]![ID]))>0)) ORDER BY Val([Notes_Archive_Files]![ID]), IIf([Notes_Archive_Files]![Timestamp] & ""="",[Notes]![Last_Changed],[Notes_Archive_Files]![Timestamp]), Notes_Archive_Files.FIle_Name DESC;
Link To Column Definitions: Notes_Archive_Files_Checker_Saved

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_Latest
Query_Type: Select
Query_DateCreated: 18/06/2007 13:14:42
Query_DateChanged: 07/08/2007 11:14:13
Query_SQL: SELECT Notes_Archive.ID, Notes_Archive.Item_Text, Notes_Archive.[Private?] FROM Notes_Archive INNER JOIN Notes_Archive_Latest_Time ON (Notes_Archive.Timestamp = Notes_Archive_Latest_Time.MaxOfTimestamp) AND (Notes_Archive.ID = Notes_Archive_Latest_Time.ID);
Link To Column Definitions: Notes_Archive_Latest

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_Latest_Time
Query_Type: Select
Query_DateCreated: 18/06/2007 13:13:05
Query_DateChanged: 20/07/2020 17:50:32
Query_SQL: SELECT Notes_Archive.ID, Min(Notes_Archive.Timestamp) AS MinOfTimestamp, Max(Notes_Archive.Timestamp) AS MaxOfTimestamp FROM Notes_Archive GROUP BY Notes_Archive.ID;
Link To Column Definitions: Notes_Archive_Latest_Time

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_List
Query_Type: Select
Query_DateCreated: 07/06/2011 18:22:10
Query_DateChanged: 02/07/2019 13:13:22
Query_SQL: SELECT Notes_Archive.ID, Notes_Archive.Timestamp, Notes_Archive.Item_Title, Notes_Archive.Item_Text, Len([Item_Text]) AS [Text Length], Notes_Archive.[Jump_Table?], Notes_Archive.Note_Group, Notes_Archive.Master_Note, Notes_Archive.Last_Changed, Notes_Archive.[Private?], Notes_Archive.Status, Notes_Archive.[Title?], Notes_Archive.[Respondent?], Notes_Archive.Frozen_Timestamp FROM Notes_Archive WHERE (((Notes_Archive.ID)=[Enter ID])) ORDER BY Notes_Archive.ID, Notes_Archive.Timestamp;
Link To Column Definitions: Notes_Archive_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_List_Auto
Query_Type: Select
Query_DateCreated: 04/08/2013 13:44:48
Query_DateChanged: 26/10/2018 18:15:50
Query_SQL: SELECT Notes_Archive.ID, Notes_Archive.Item_Title, Notes_Archive.Item_Text, Notes_Archive.[Jump_Table?], Note_Groups.Note_Group, IIf([Notes_1]![Item_Title] & ""="","None","<A href =""../../" & IIf([Notes_1]![Note_Group]=10,"Secure_Jen/","Notes/") & "Notes_" & Int([Notes_1]![ID]/100) & "/Notes_" & [Notes_1]![ID] & ".htm"">" & [Notes_1]![Item_Title] & "</A>") AS [Master Note], Notes_Archive.Timestamp, Notes_Archive.[Private?], Note_Groups.[ReadingList?], Notes_Archive.[Title?], Notes_Archive.[Respondent?], Notes_Archive.Status, Notes_Archive.Frozen_Timestamp, 0 AS Immediate_Promotion FROM (Notes_Archive INNER JOIN Note_Groups ON Notes_Archive.Note_Group = Note_Groups.ID) LEFT JOIN Notes AS Notes_1 ON Notes_Archive.Master_Note = Notes_1.ID ORDER BY Notes_Archive.ID;
Link To Column Definitions: Notes_Archive_List_Auto

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_List_Checker
Query_Type: Select
Query_DateCreated: 08/04/2014 17:42:55
Query_DateChanged: 08/04/2014 17:51:39
Query_SQL: SELECT Notes.ID, Notes.Item_Title, Notes_Archive.Item_Title, Notes_Archive.Timestamp, "Notes_" & [Notes]![ID] & "_" & [Notes_Archive]![Timestamp] & ".htm" AS Archive_Filename FROM Notes LEFT JOIN Notes_Archive ON Notes.ID = Notes_Archive.ID ORDER BY Notes.ID, Notes.Item_Title;
Link To Column Definitions: Notes_Archive_List_Checker

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_List_ID
Query_Type: Select
Query_DateCreated: 05/10/2014 18:40:10
Query_DateChanged: 04/08/2015 00:12:38
Query_SQL: SELECT Len([Item_Text]) AS Length, Notes_Archive.* FROM Notes_To_Regen INNER JOIN Notes_Archive ON Notes_To_Regen.Note_ID = Notes_Archive.ID ORDER BY Notes_Archive.Timestamp;
Link To Column Definitions: Notes_Archive_List_ID

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Archive_List_ID+Timestamp
Query_Type: Select
Query_DateCreated: 05/10/2014 18:35:34
Query_DateChanged: 05/10/2014 19:15:55
Query_SQL: SELECT Notes_Archive.* FROM Notes_To_Regen INNER JOIN Notes_Archive ON (Notes_To_Regen.Timestamp = Notes_Archive.Timestamp) AND (Notes_To_Regen.Note_ID = Notes_Archive.ID);
Link To Column Definitions: Notes_Archive_List_ID+Timestamp

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Autobiography
Query_Type: Select
Query_DateCreated: 12/05/2018 23:08:24
Query_DateChanged: 12/05/2018 23:08:24
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=3)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Autobiography

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Bible
Query_Type: Select
Query_DateCreated: 21/07/2007 10:05:26
Query_DateChanged: 05/08/2010 22:31:31
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion FROM Notes WHERE (((Notes.Note_Group)=7)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Bible

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Blog
Query_Type: Select
Query_DateCreated: 09/07/2007 12:44:09
Query_DateChanged: 24/07/2017 18:29:44
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=5)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Blog

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Carthusians
Query_Type: Select
Query_DateCreated: 12/05/2018 23:12:23
Query_DateChanged: 12/05/2018 23:12:23
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=9)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Carthusians

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Cited_By_Authors_List
Query_Type: Select
Query_DateCreated: 05/09/2015 11:51:01
Query_DateChanged: 05/09/2015 11:57:30
Query_SQL: SELECT Authors.Author_Name AS Author, " N/A" AS Title, "Author" AS Medium, "" AS Display_Text, "" AS Icon, "N/A" AS [Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Note_ID FROM Authors INNER JOIN Cross_Reference ON Authors.Author_ID = Cross_Reference.Calling_ID WHERE (((Cross_Reference.Called_Type)="N") AND ((Cross_Reference.Called_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="A")) ORDER BY Authors.Author_Name, "N/A", Cross_Reference.Calling_NameRef;
Link To Column Definitions: Notes_Cited_By_Authors_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Cited_By_Books_List
Query_Type: Select
Query_DateCreated: 05/09/2015 09:56:25
Query_DateChanged: 05/09/2015 10:01:15
Query_SQL: SELECT Books.Author, Books.Title, "Book" AS Medium, Quality_Markers.Display_Text, Quality_Markers.Icon, Books.[Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Note_ID FROM (Cross_Reference INNER JOIN Books ON Cross_Reference.Calling_ID = Books.ID1) INNER JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality WHERE (((Cross_Reference.Called_Type)="N") AND ((Cross_Reference.Called_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="B")) ORDER BY Books.Author, Books.Title, Cross_Reference.Calling_NameRef;
Link To Column Definitions: Notes_Cited_By_Books_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Cited_By_Papers_List
Query_Type: Select
Query_DateCreated: 04/09/2015 22:49:23
Query_DateChanged: 05/09/2015 01:13:09
Query_SQL: SELECT Papers.Author, Papers.Title, "Paper" AS Medium, Quality_Markers.Display_Text, Quality_Markers.Icon, Papers.[Read?], Cross_Reference.Calling_ID, Cross_Reference.Calling_NameRef, Cross_Reference.Called_ID AS Note_ID FROM (Papers INNER JOIN Cross_Reference ON Papers.ID = Cross_Reference.Calling_ID) INNER JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality WHERE (((Cross_Reference.Called_Type)="N") AND ((Cross_Reference.Called_Timestamp)=0) AND ((Cross_Reference.Calling_Type)="P")) ORDER BY Papers.Author, Papers.Title, Cross_Reference.Calling_NameRef;
Link To Column Definitions: Notes_Cited_By_Papers_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Control
Query_Type: Select
Query_DateCreated: 18/11/2015 19:03:38
Query_DateChanged: 24/07/2017 19:07:50
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=14)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Control

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Essays
Query_Type: Select
Query_DateCreated: 12/05/2018 23:14:28
Query_DateChanged: 12/05/2018 23:14:28
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=15)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Essays

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Heythrop
Query_Type: Select
Query_DateCreated: 02/12/2010 16:34:09
Query_DateChanged: 18/12/2010 10:36:12
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion FROM Notes WHERE (((Notes.Note_Group)=11)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Heythrop

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Jump
Query_Type: Select
Query_DateCreated: 18/06/2007 08:47:57
Query_DateChanged: 28/08/2007 21:44:02
Query_SQL: SELECT Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.Frozen_Timestamp FROM Notes ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Jump

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Jump (Titles)
Query_Type: Select
Query_DateCreated: 17/06/2007 18:52:56
Query_DateChanged: 22/07/2017 13:28:09
Query_SQL: SELECT Notes.Item_Title, Notes.ID, Notes.Note_Group, Notes.Last_Changed, Notes.Immediate_Promotion, Notes_Latest.Timestamp, Note_Qualities.Note_Quality_Text, Note_Qualities.Note_Quality_Colour FROM (Notes LEFT JOIN Notes_Latest ON Notes.ID = Notes_Latest.ID) LEFT JOIN Note_Qualities ON Notes.Note_Quality = Note_Qualities.Note_Quality WHERE (((Notes.[Jump_Table?])=Yes) AND ((Notes.[Private?])="No")) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Jump (Titles)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Jump (Titles)_All
Query_Type: Select
Query_DateCreated: 22/08/2010 16:02:27
Query_DateChanged: 23/07/2017 01:07:39
Query_SQL: SELECT Notes.Item_Title, Notes.ID, Notes.Note_Group, Notes.Last_Changed, Notes.Immediate_Promotion, Notes_Latest.Timestamp, Note_Qualities.Note_Quality_Text, Note_Qualities.Note_Quality_Colour FROM (Notes LEFT JOIN Notes_Latest ON Notes.ID = Notes_Latest.ID) LEFT JOIN Note_Qualities ON Notes.Note_Quality = Note_Qualities.Note_Quality ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Jump (Titles)_All

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Latest
Query_Type: Select
Query_DateCreated: 06/08/2007 23:35:24
Query_DateChanged: 26/09/2007 00:23:49
Query_SQL: SELECT Notes_Archive.ID, Max([Notes_Archive]![Timestamp]) AS [Timestamp] FROM Notes_Archive GROUP BY Notes_Archive.ID ORDER BY Notes_Archive.ID;
Link To Column Definitions: Notes_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_List_Auto
Query_Type: Select
Query_DateCreated: 19/06/2007 08:27:39
Query_DateChanged: 26/10/2018 18:03:04
Query_SQL: SELECT Notes.ID, Notes.Item_Title, Notes.Item_Text, Notes.[Jump_Table?], Note_Groups.Note_Group, IIf([Notes_1]![Note_Group] & ""="","None","<A href =""../../" & IIf([Notes_1]![Note_Group]=10,"Secure_Jen/","Notes/") & "Notes_" & Int([Notes_1]![ID]/100) & "/Notes_" & [Notes_1]![ID] & ".htm"">" & [Notes_1]![Item_Title] & "</A>") AS [Master Note], Notes.Last_Changed, Notes.[Private?], Note_Groups.[ReadingList?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Frozen_Timestamp, Notes.Immediate_Promotion FROM (Notes INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID) LEFT JOIN Notes AS Notes_1 ON Notes.Master_Note = Notes_1.ID ORDER BY Notes.ID;
Link To Column Definitions: Notes_List_Auto

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_List_Group
Query_Type: Select
Query_DateCreated: 10/07/2009 15:01:00
Query_DateChanged: 23/07/2017 13:28:05
Query_SQL: SELECT Note_Groups.Note_Group, IIf([Note_Groups]![ReadingList?] & ""="Yes","Yes") AS [Reading List?], Notes.ID, "<A href =""../" & IIf([Note_Groups]![Note_Group]="Supervisions","Secure_Jen/","Notes/") & "Notes_" & Int([Notes]![ID]/100) & "/Notes_" & [Notes]![ID] & ".htm"">" & [Notes]![Item_Title] & "</A>" AS [Note Title & Link], IIf([Notes_1]![Item_Title] & ""="","","<A href =""../" & IIf([Note_Groups]![Note_Group]="Supervisions","Secure_Jen/","Notes/") & "Notes_" & Int([Notes_1]![ID]/100) & "/Notes_" & [Notes_1]![ID] & ".htm"">" & [Notes_1]![Item_Title] & "</A>") AS [Master Note], IIf([Notes]![Last_Changed] & ""<>"",Year([Notes]![Last_Changed]/1000) & "-" & Right(Month([Notes]![Last_Changed]/1000)+100,2) & "-" & Right(Day([Notes]![Last_Changed]/1000)+100,2)) AS [Last Changed], IIf([Notes]![Private?] & ""="Yes","Yes") AS [Private?], IIf([Notes]![Respondent?]=Yes,"Yes") AS [Respondent Note?], Notes.Status, Note_Qualities.[Note_Quality_Text] AS [Note Quality], Len([Notes]![Item_Text]) AS [Note Length], Notes.Item_Text FROM (((Notes INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID) LEFT JOIN Notes AS Notes_1 ON Notes.Master_Note = Notes_1.ID) INNER JOIN Note_Group_Select ON Note_Groups.ID = Note_Group_Select.Note_Group_ID) LEFT JOIN Note_Qualities ON Notes.Note_Quality = Note_Qualities.Note_Quality WHERE (((Notes.[Jump_Table?])=Yes)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_List_Group

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_PID
Query_Type: Select
Query_DateCreated: 28/06/2007 22:24:21
Query_DateChanged: 22/07/2017 16:59:45
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=1) AND (([Status] & "All") Like "*" & [All or Temp?] & "*")) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_PID

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Religion
Query_Type: Select
Query_DateCreated: 02/12/2010 16:48:25
Query_DateChanged: 24/07/2017 19:21:42
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=12)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Religion

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Search
Query_Type: Select
Query_DateCreated: 29/08/2007 14:41:03
Query_DateChanged: 18/08/2010 12:09:56
Query_SQL: SELECT Notes.* FROM Notes WHERE (((Notes.Item_Title) Like "*" & [Enter String] & "*")) OR (((Notes.Item_Text) Like "*" & [Enter String] & "*"));
Link To Column Definitions: Notes_Search

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Status
Query_Type: Select
Query_DateCreated: 14/08/2007 09:25:55
Query_DateChanged: 24/07/2017 20:30:55
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.[Jump_Table?], Notes.Item_Text, Notes.ID, Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Frozen_Timestamp, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Item_Title) Not Like "*birkbeck*") AND ((Notes.Note_Group)=2)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Status

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Supervisions
Query_Type: Select
Query_DateCreated: 04/10/2007 19:18:14
Query_DateChanged: 18/08/2010 18:28:51
Query_SQL: SELECT Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Frozen_Timestamp, Notes.Immediate_Promotion FROM Notes WHERE (((Notes.Note_Group)=10)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Supervisions

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Temp
Query_Type: Select
Query_DateCreated: 20/10/2007 19:46:05
Query_DateChanged: 18/05/2020 19:13:27
Query_SQL: SELECT Notes.* FROM Notes WHERE (((Notes.Status)="Temp")) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Temp

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_to_Print_Add1
Query_Type: Select
Query_DateCreated: 21/05/2010 11:03:00
Query_DateChanged: 21/05/2010 14:36:12
Query_SQL: SELECT Notes.ID FROM Notes LEFT JOIN Notes_to_Print ON Notes.ID = Notes_to_Print.Note_ID WHERE (((Notes.Status)="Temp") AND ((Notes_to_Print.Note_ID) Is Null));
Link To Column Definitions: Notes_to_Print_Add1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_to_Print_List
Query_Type: Select
Query_DateCreated: 07/06/2011 18:33:01
Query_DateChanged: 15/04/2019 22:57:36
Query_SQL: SELECT Notes_to_Print.Note_ID, Notes_to_Print.Max_Depth, Notes_to_Print.Private, Notes_to_Print.Print_ReadingList, Notes_to_Print.Print_DupNoteRefs, Notes_to_Print.Current, Notes_to_Print.Title, Notes_to_Print.Group FROM Notes_to_Print WHERE (((Notes_to_Print.Note_ID)=[Enter ID])) ORDER BY Notes_to_Print.Max_Depth, Notes_to_Print.Private, Notes_to_Print.Print_ReadingList, Notes_to_Print.Print_DupNoteRefs;
Link To Column Definitions: Notes_to_Print_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_Tractatus
Query_Type: Select
Query_DateCreated: 02/07/2007 21:39:59
Query_DateChanged: 19/08/2010 20:43:34
Query_SQL: SELECT Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion FROM Notes WHERE (((Notes.Note_Group)=4)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_Tractatus

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_WebDocs
Query_Type: Select
Query_DateCreated: 22/05/2013 22:06:44
Query_DateChanged: 24/07/2017 20:38:57
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=13)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_WebDocs

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Notes_WriteUp
Query_Type: Select
Query_DateCreated: 19/07/2007 08:29:55
Query_DateChanged: 24/07/2017 20:44:36
Query_SQL: SELECT Len([Item_Text]) AS [Size], Notes.Item_Title, Notes.Item_Text, Notes.ID, Notes.[Jump_Table?], Notes.Note_Group, Notes.Master_Note, Notes.Last_Changed, Notes.[Private?], Notes.[Title?], Notes.[Respondent?], Notes.Status, Notes.Immediate_Promotion, Notes.Note_Quality FROM Notes WHERE (((Notes.Note_Group)=6)) ORDER BY Notes.Item_Title;
Link To Column Definitions: Notes_WriteUp

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Oboe_Practice_Hours_List
Query_Type: Select
Query_DateCreated: 04/10/2019 18:49:08
Query_DateChanged: 03/08/2020 19:05:19
Query_SQL: SELECT Oboe_Practice_Hours.Topic AS [Piece Performed], Oboe_Practice_Hours.Grade, Audio_Files.Creation_Date AS [Latest Audio], IIf([Oboe_Practice_Hours]![Practice?]=True,"Yes","") AS [Practice?], IIf([Oboe_Practice_Hours]![Exclude?]=True,"Yes","") AS [Exclude?], IIf([Oboe_Practice_Hours]![From_Memory]=True,"Yes","") AS [From Memory?], Oboe_Practice_Hours.Since_Last_Lesson AS [Hours Since Last Lesson], Nz([18/19])+Nz([19/20]) AS [Total Hours], "" AS [Annual Breakdown &rarr;], Oboe_Practice_Hours.[19/20], Oboe_Practice_Hours.[18/19] FROM Oboe_Practice_Hours LEFT JOIN Audio_Files ON Oboe_Practice_Hours.Latest_Audio_File_ID = Audio_Files.ID WHERE (((Oboe_Practice_Hours.[No_Reporting?])=No)) ORDER BY Oboe_Practice_Hours.Topic;
Link To Column Definitions: Oboe_Practice_Hours_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Page_Regen_GEN_Test
Query_Type: Select
Query_DateCreated: 25/06/2020 17:42:34
Query_DateChanged: 25/06/2020 17:43:46
Query_SQL: SELECT Cross_Reference_Changes.Called_Type, Cross_Reference_Changes.Called_ID, Cross_Reference_Changes.Calling_Type, Count(Cross_Reference_Changes.ID) AS Records, Min(Cross_Reference_Changes.Timestamp) AS Earliest_Change, Max(Cross_Reference_Changes.Timestamp) AS Latest_Change FROM Cross_Reference_Changes GROUP BY Cross_Reference_Changes.Called_Type, Cross_Reference_Changes.Called_ID, Cross_Reference_Changes.Calling_Type HAVING (((Cross_Reference_Changes.Called_Type)<>"W"));
Link To Column Definitions: Page_Regen_GEN_Test

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Abstract_Ranges_Latest
Query_Type: Select
Query_DateCreated: 20/05/2018 00:07:08
Query_DateChanged: 20/05/2018 00:07:08
Query_SQL: SELECT "Paper_Abstract_Ranges" AS Title, Min(Paper_Abstract_Ranges.Latest_Paper_Range_Update) AS MinOfLatest_Paper_Range_Update FROM Paper_Abstract_Ranges GROUP BY "Paper_Abstract_Ranges";
Link To Column Definitions: Paper_Abstract_Ranges_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Author_List
Query_Type: Select
Query_DateCreated: 25/06/2011 17:48:13
Query_DateChanged: 14/01/2015 17:01:20
Query_SQL: SELECT Author_Paper_Links.Author AS Author_Name, Author_Paper_Links.Paper_Author AS Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Papers.ID AS Paper_ID, "Paper" AS Medium FROM (Author_Paper_Links INNER JOIN (Papers LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality) ON Author_Paper_Links.Paper_ID = Papers.ID) LEFT JOIN Book_Paper_Solitons ON Papers.Book_ID = Book_Paper_Solitons.Book_ID GROUP BY Author_Paper_Links.Author, Author_Paper_Links.Paper_Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Papers.ID, "Paper", Book_Paper_Solitons.Book_ID HAVING (((Book_Paper_Solitons.Book_ID) Is Null)) ORDER BY Author_Paper_Links.Author, Papers.Title;
Link To Column Definitions: Paper_Author_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Author_List_Changed
Query_Type: Select
Query_DateCreated: 26/06/2011 18:20:14
Query_DateChanged: 28/06/2011 10:36:35
Query_SQL: SELECT Paper_Author_List.Author_Name, Paper_Author_List.Author, Paper_Author_List.Title, Paper_Author_List.Pages, Paper_Author_List.[Read?], Paper_Author_List.[Further Information], Paper_Author_List.Paper_ID, Paper_Author_List.Medium FROM Authors_Changed INNER JOIN Paper_Author_List ON Authors_Changed.Author_Name = Paper_Author_List.Author_Name;
Link To Column Definitions: Paper_Author_List_Changed

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Author_List_Changed1
Query_Type: Select
Query_DateCreated: 28/06/2011 10:26:02
Query_DateChanged: 29/07/2013 11:09:21
Query_SQL: SELECT Author_Paper_Links.Author AS Author_Name FROM Author_Paper_Links, System_Parameters WHERE (((Author_Paper_Links.Timestamp)>Now()-[Author_Change_Days])) GROUP BY Author_Paper_Links.Author;
Link To Column Definitions: Paper_Author_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Book_List
Query_Type: Select
Query_DateCreated: 27/06/2011 13:15:29
Query_DateChanged: 27/06/2011 13:32:44
Query_SQL: SELECT Book_Paper_Links.Paper_ID, Books.Author, Books.Title, Books.Pages, IIf([Books]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Book_Paper_Links.Book_ID1 AS Object_ID, "Book" AS Medium FROM Book_Paper_Links INNER JOIN (Books LEFT JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality) ON Book_Paper_Links.Book_ID1 = Books.ID1 GROUP BY Book_Paper_Links.Paper_ID, Books.Author, Books.Title, Books.Pages, IIf([Books]![Read?]=True,"Yes","No"), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Book_Paper_Links.Book_ID1, "Book";
Link To Column Definitions: Paper_Book_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Book_List_Changed
Query_Type: Select
Query_DateCreated: 27/06/2011 13:49:59
Query_DateChanged: 28/06/2011 14:41:54
Query_SQL: SELECT Paper_Book_List.Paper_ID, Paper_Book_List.Author, Paper_Book_List.Title, Paper_Book_List.Pages, Paper_Book_List.[Read?], Paper_Book_List.[Further Information], Paper_Book_List.Object_ID, Paper_Book_List.Medium FROM Paper_Citings_List_Changed1 INNER JOIN Paper_Book_List ON Paper_Citings_List_Changed1.Paper_ID = Paper_Book_List.Paper_ID ORDER BY Paper_Book_List.Paper_ID, Paper_Book_List.Author, Paper_Book_List.Title;
Link To Column Definitions: Paper_Book_List_Changed

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Book_List_Changed_New
Query_Type: Select
Query_DateCreated: 30/08/2015 17:36:05
Query_DateChanged: 30/08/2015 17:37:33
Query_SQL: SELECT Paper_Book_List_New.Paper_ID, Paper_Book_List_New.Author, Paper_Book_List_New.Title, Paper_Book_List_New.Pages, Paper_Book_List_New.[Read?], Paper_Book_List_New.[Further Information], Paper_Book_List_New.Object_ID, Paper_Book_List_New.Medium, Paper_Book_List_New.Calling_NameRef FROM Paper_Citings_List_Changed1 INNER JOIN Paper_Book_List_New ON Paper_Citings_List_Changed1.Paper_ID = Paper_Book_List_New.Paper_ID ORDER BY Paper_Book_List_New.Paper_ID, Paper_Book_List_New.Author, Paper_Book_List_New.Title;
Link To Column Definitions: Paper_Book_List_Changed_New

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Book_List_Changed1
Query_Type: Select
Query_DateCreated: 28/06/2011 14:34:46
Query_DateChanged: 28/06/2011 14:37:58
Query_SQL: SELECT Paper_Book_List.Paper_ID FROM Book_Summary_Changed_List INNER JOIN Paper_Book_List ON Book_Summary_Changed_List.ID1 = Paper_Book_List.Object_ID GROUP BY Paper_Book_List.Paper_ID ORDER BY Paper_Book_List.Paper_ID;
Link To Column Definitions: Paper_Book_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Book_List_New
Query_Type: Select
Query_DateCreated: 30/08/2015 16:41:50
Query_DateChanged: 30/08/2015 16:55:16
Query_SQL: SELECT Cross_Reference.Called_ID AS Paper_ID, Books.Author, Books.Title, Books.Pages, IIf([Books]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Cross_Reference.Calling_ID AS Object_ID, "Book" AS Medium, Cross_Reference.Calling_NameRef FROM Cross_Reference INNER JOIN (Books LEFT JOIN Quality_Markers ON Books.Abstract_Quality = Quality_Markers.Quality) ON Cross_Reference.Calling_ID = Books.ID1 WHERE (((Cross_Reference.Calling_Type)="B") AND ((Cross_Reference.Called_Type)="P")) GROUP BY Cross_Reference.Called_ID, Books.Author, Books.Title, Books.Pages, IIf([Books]![Read?]=True,"Yes","No"), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Cross_Reference.Calling_ID, "Book", Cross_Reference.Calling_NameRef;
Link To Column Definitions: Paper_Book_List_New

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Citings_List_New_List
Query_Type: Select
Query_DateCreated: 11/07/2020 23:40:34
Query_DateChanged: 11/07/2020 23:40:34
Query_SQL: SELECT Paper_Citings_List_New.Paper_ID, Paper_Citings_List_New.Author, Paper_Citings_List_New.Title, Paper_Citings_List_New.Pages, Paper_Citings_List_New.[Read?], Paper_Citings_List_New.[Further Information], Paper_Citings_List_New.Object_ID, Paper_Citings_List_New.Medium, Paper_Citings_List_New.Calling_NameRef FROM Paper_Citings_List_New ORDER BY Paper_Citings_List_New.Paper_ID, Paper_Citings_List_New.Author, Paper_Citings_List_New.Title, Paper_Citings_List_New.Calling_NameRef;
Link To Column Definitions: Paper_Citings_List_New_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Citings_Page_List
Query_Type: Select
Query_DateCreated: 15/06/2014 16:25:31
Query_DateChanged: 30/08/2015 17:50:46
Query_SQL: SELECT Papers.Author, Papers.Title, "<a href= ""PaperSummaries/PaperSummary_" & Mid([ID]+100000,2,2) & "/PaperCitings_" & [ID] & ".htm"">" & "Link</a>" AS [Citings Link] FROM Paper_Citings_List_New INNER JOIN Papers ON Paper_Citings_List_New.Paper_ID = Papers.ID GROUP BY Papers.Author, Papers.Title, "<a href= ""PaperSummaries/PaperSummary_" & Mid([ID]+100000,2,2) & "/PaperCitings_" & [ID] & ".htm"">" & "Link</a>" ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Paper_Citings_Page_List

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Citings_Page_List (Letters)
Query_Type: Select
Query_DateCreated: 15/06/2014 16:31:51
Query_DateChanged: 15/06/2014 16:32:13
Query_SQL: SELECT Left([Author],1) AS Letter FROM Paper_Citings_Page_List GROUP BY Left([Author],1) ORDER BY Left([Author],1);
Link To Column Definitions: Paper_Citings_Page_List (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Names_Fix
Query_Type: Select
Query_DateCreated: 14/05/2011 08:47:08
Query_DateChanged: 29/05/2011 09:57:29
Query_SQL: SELECT Papers.Author, Papers.Comments, Papers.Abstract, Papers.Abstract_Quality, Papers.[Photopcopy?], Papers.Location, Papers.Title, Papers.Source FROM Papers WHERE (((Papers.Author)<>"Admin") AND ((InStr([Author],"("))=0) AND ((Papers.[On_Laptop?])=True) AND ((Left([Author],1))>"C")) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Paper_Names_Fix

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Note_Counts
Query_Type: Select
Query_DateCreated: 27/01/2009 22:07:49
Query_DateChanged: 25/07/2010 19:48:15
Query_SQL: SELECT Note_Paper_Links.Paper, Count(Note_Paper_Links.Note) AS CountOfNote FROM Note_Paper_Links WHERE (((Note_Paper_Links.Origin)="Note")) GROUP BY Note_Paper_Links.Paper ORDER BY Note_Paper_Links.Paper;
Link To Column Definitions: Paper_Note_Counts

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Note_Link_List
Query_Type: Select
Query_DateCreated: 22/07/2020 19:00:35
Query_DateChanged: 23/07/2020 19:00:59
Query_SQL: SELECT Papers.ID AS Paper_ID, Notes.ID AS [Note ID], Papers.Author AS [Paper Author], Papers.Title AS [Paper Title], IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]) AS [Note], Note_Groups.Note_Group AS [Note Group], IIf([Live_Note?]=0,Year(Int([Notes]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes]![Last_Changed]/1000))+100,2),Year(Int([Notes_Archive]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes_Archive]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes_Archive]![Last_Changed]/1000))+100,2)) AS [Date Last Changed], Cross_Reference.Calling_Timestamp, Cross_Reference.Calling_NameRef FROM (((Cross_Reference INNER JOIN Papers ON Cross_Reference.Called_ID = Papers.ID) INNER JOIN (Notes INNER JOIN Note_Groups ON Notes.Note_Group = Note_Groups.ID) ON Cross_Reference.Calling_ID = Notes.ID) INNER JOIN Cross_Reference_Prelims ON (Cross_Reference.Called_ID = Cross_Reference_Prelims.Called_ID) AND (Cross_Reference.Called_Type = Cross_Reference_Prelims.Called_Type) AND (Cross_Reference.Calling_Type = Cross_Reference_Prelims.Calling_Type) AND (Cross_Reference.Calling_ID = Cross_Reference_Prelims.Calling_ID)) INNER JOIN Notes_Archive ON (Cross_Reference_Prelims.Latest_Archive_Note = Notes_Archive.Timestamp) AND (Cross_Reference_Prelims.Calling_ID = Notes_Archive.ID) WHERE (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="P") AND ((Cross_Reference_Prelims.[Live_Note?])=0) AND ((Cross_Reference.Calling_Timestamp)=0)) OR (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="P") AND ((Cross_Reference_Prelims.[Live_Note?])=1) AND ((Cross_Reference.Calling_Timestamp)=[Latest_Archive_Note])) GROUP BY Papers.ID, Notes.ID, Papers.Author, Papers.Title, IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]), Note_Groups.Note_Group, IIf([Live_Note?]=0,Year(Int([Notes]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes]![Last_Changed]/1000))+100,2),Year(Int([Notes_Archive]![Last_Changed]/1000)) & "-" & Right(Month(Int([Notes_Archive]![Last_Changed]/1000))+100,2) & "-" & Right(Day(Int([Notes_Archive]![Last_Changed]/1000))+100,2)), Cross_Reference.Calling_Timestamp, Cross_Reference.Calling_NameRef ORDER BY Papers.ID, Papers.Author, Papers.Title, IIf([Live_Note?]=0,[Notes]![Item_Title],[Notes_Archive]![Item_Title]);
Link To Column Definitions: Paper_Note_Link_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Note_Link_Refs
Query_Type: Select
Query_DateCreated: 30/03/2014 19:08:34
Query_DateChanged: 30/03/2014 19:11:48
Query_SQL: SELECT Papers.ID, "<A HREF = ""PaperSummaries/PaperSummary_" & Mid(Str(100000+[Papers]![ID]),3,2) & "/PapersToNotes_" & [Papers]![ID] & ".htm"">Link</A>" AS PapersToNoteLink FROM Papers;
Link To Column Definitions: Paper_Note_Link_Refs

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Paper_List
Query_Type: Select
Query_DateCreated: 27/06/2011 13:33:48
Query_DateChanged: 27/06/2011 13:37:07
Query_SQL: SELECT Paper_Paper_Links.Paper_ID2 AS Paper_ID, Papers.Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Paper_Paper_Links.Paper_ID AS Object_ID, "Paper" AS Medium FROM Paper_Paper_Links INNER JOIN (Papers LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality) ON Paper_Paper_Links.Paper_ID = Papers.ID GROUP BY Paper_Paper_Links.Paper_ID2, Papers.Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=True,"Yes","No"), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Paper_Paper_Links.Paper_ID, "Paper" ORDER BY Paper_Paper_Links.Paper_ID2;
Link To Column Definitions: Paper_Paper_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Paper_List_Changed
Query_Type: Select
Query_DateCreated: 27/06/2011 13:51:51
Query_DateChanged: 28/06/2011 14:42:57
Query_SQL: SELECT Paper_Paper_List.Paper_ID, Paper_Paper_List.Author, Paper_Paper_List.Title, Paper_Paper_List.Pages, Paper_Paper_List.[Read?], Paper_Paper_List.[Further Information], Paper_Paper_List.Object_ID, Paper_Paper_List.Medium FROM Paper_Citings_List_Changed1 INNER JOIN Paper_Paper_List ON Paper_Citings_List_Changed1.Paper_ID = Paper_Paper_List.Paper_ID ORDER BY Paper_Paper_List.Paper_ID, Paper_Paper_List.Author, Paper_Paper_List.Title;
Link To Column Definitions: Paper_Paper_List_Changed

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Paper_List_Changed_New
Query_Type: Select
Query_DateCreated: 30/08/2015 17:38:48
Query_DateChanged: 30/08/2015 17:39:52
Query_SQL: SELECT Paper_Paper_List_New.Paper_ID, Paper_Paper_List_New.Author, Paper_Paper_List_New.Title, Paper_Paper_List_New.Pages, Paper_Paper_List_New.[Read?], Paper_Paper_List_New.[Further Information], Paper_Paper_List_New.Object_ID, Paper_Paper_List_New.Medium, Paper_Paper_List_New.Calling_NameRef FROM Paper_Citings_List_Changed1 INNER JOIN Paper_Paper_List_New ON Paper_Citings_List_Changed1.Paper_ID = Paper_Paper_List_New.Paper_ID ORDER BY Paper_Paper_List_New.Paper_ID, Paper_Paper_List_New.Author, Paper_Paper_List_New.Title;
Link To Column Definitions: Paper_Paper_List_Changed_New

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Paper_List_Changed1
Query_Type: Select
Query_DateCreated: 28/06/2011 14:38:22
Query_DateChanged: 28/06/2011 14:38:41
Query_SQL: SELECT Paper_Paper_List.Paper_ID FROM Paper_Summary_Changed_List INNER JOIN Paper_Paper_List ON Paper_Summary_Changed_List.ID = Paper_Paper_List.Object_ID GROUP BY Paper_Paper_List.Paper_ID ORDER BY Paper_Paper_List.Paper_ID;
Link To Column Definitions: Paper_Paper_List_Changed1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Paper_List_New
Query_Type: Select
Query_DateCreated: 30/08/2015 16:56:33
Query_DateChanged: 30/08/2015 17:03:37
Query_SQL: SELECT Cross_Reference.Called_ID AS Paper_ID, Papers.Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=True,"Yes","No") AS [Read?], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">",".") AS [Further Information], Cross_Reference.Calling_ID AS Object_ID, "Paper" AS Medium, Cross_Reference.Calling_NameRef FROM Cross_Reference INNER JOIN (Papers LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality) ON Cross_Reference.Calling_ID = Papers.ID WHERE (((Cross_Reference.Calling_Type)="P") AND ((Cross_Reference.Called_Type)="P")) GROUP BY Cross_Reference.Called_ID, Papers.Author, Papers.Title, Papers.Pages, IIf([Papers]![Read?]=True,"Yes","No"), IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","."), Cross_Reference.Calling_ID, "Paper", Cross_Reference.Calling_NameRef ORDER BY Cross_Reference.Called_ID;
Link To Column Definitions: Paper_Paper_List_New

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Subject_All
Query_Type: Select
Query_DateCreated: 12/04/2009 16:55:01
Query_DateChanged: 12/04/2009 16:55:28
Query_SQL: SELECT Paper_Subject_Union.ID, Paper_Subject_Union.Subject FROM Paper_Subject_Union GROUP BY Paper_Subject_Union.ID, Paper_Subject_Union.Subject;
Link To Column Definitions: Paper_Subject_All

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Subject_Topic_Subtopic_List
Query_Type: Select
Query_DateCreated: 12/04/2009 17:08:18
Query_DateChanged: 12/04/2009 17:09:24
Query_SQL: SELECT Paper_Subject_All.ID, Paper_Subject_All.Subject, Paper_Topic_All.Topic, Paper_SubTopic_All.[Sub-Topic] FROM (Paper_Subject_All INNER JOIN Paper_SubTopic_All ON Paper_Subject_All.ID = Paper_SubTopic_All.ID) INNER JOIN Paper_Topic_All ON Paper_SubTopic_All.ID = Paper_Topic_All.ID;
Link To Column Definitions: Paper_Subject_Topic_Subtopic_List

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Subject1
Query_Type: Select
Query_DateCreated: 12/04/2009 16:51:12
Query_DateChanged: 12/04/2009 16:52:32
Query_SQL: SELECT Papers.ID, Papers.Subject FROM Papers WHERE (((Papers.Subject) Is Not Null));
Link To Column Definitions: Paper_Subject1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Subject2
Query_Type: Select
Query_DateCreated: 12/04/2009 16:52:40
Query_DateChanged: 12/04/2009 16:52:55
Query_SQL: SELECT Papers.ID, Papers.Subject2 AS Subject FROM Papers WHERE (((Papers.Subject2) Is Not Null));
Link To Column Definitions: Paper_Subject2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Subject3
Query_Type: Select
Query_DateCreated: 12/04/2009 16:53:04
Query_DateChanged: 12/04/2009 16:53:09
Query_SQL: SELECT Papers.ID, Papers.Subject3 AS Subject FROM Papers WHERE (((Papers.Subject3) Is Not Null));
Link To Column Definitions: Paper_Subject3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_SubTopic_All
Query_Type: Select
Query_DateCreated: 12/04/2009 17:07:13
Query_DateChanged: 12/04/2009 17:07:40
Query_SQL: SELECT Paper_SubTopic_Union.ID, Paper_SubTopic_Union.[Sub-Topic] FROM Paper_SubTopic_Union GROUP BY Paper_SubTopic_Union.ID, Paper_SubTopic_Union.[Sub-Topic];
Link To Column Definitions: Paper_SubTopic_All

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_SubTopic1
Query_Type: Select
Query_DateCreated: 12/04/2009 17:00:24
Query_DateChanged: 12/04/2009 17:00:46
Query_SQL: SELECT Papers.ID, Papers.[Sub-Topic] FROM Papers WHERE (((Papers.[Sub-Topic]) Is Not Null));
Link To Column Definitions: Paper_SubTopic1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_SubTopic2
Query_Type: Select
Query_DateCreated: 12/04/2009 17:00:57
Query_DateChanged: 12/04/2009 17:01:21
Query_SQL: SELECT Papers.ID, Papers.[Sub-Topic2] AS [Sub-Topic] FROM Papers WHERE (((Papers.[Sub-Topic2]) Is Not Null));
Link To Column Definitions: Paper_SubTopic2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_SubTopic3
Query_Type: Select
Query_DateCreated: 12/04/2009 17:01:32
Query_DateChanged: 12/04/2009 17:05:44
Query_SQL: SELECT Papers.ID, Papers.[Sub-Topic3] AS [Sub-Topic] FROM Papers WHERE (((Papers.[Sub-Topic3]) Is Not Null));
Link To Column Definitions: Paper_SubTopic3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Summary_Changed_List
Query_Type: Select
Query_DateCreated: 09/06/2007 17:18:14
Query_DateChanged: 02/09/2015 23:13:31
Query_SQL: SELECT Papers.ID, Papers.Author, Papers.Title, Paper_Summary.TimeStamp FROM Papers LEFT JOIN Paper_Summary ON Papers.ID = Paper_Summary.ID WHERE ((([Author] & [Title] & [Subject] & [Subject2] & [Subject3] & [Location] & [Medium] & [Book] & [Topic] & [Topic2] & [Topic3] & [Sub-Topic] & [Sub-Topic2] & [Sub-Topic3] & [Source] & [Pages] & [Priority] & [Difficulty] & [Estimate] & Nz([Actual - Total]) & [Read?] & [Precis?] & [Referenced?] & [On_Laptop?] & [Photopcopy?] & IIf([Abstract] & ""="","No","Yes") & IIf([Comments] & ""="","No","Yes") & [Write_Up_Note_ID])<>[Paper_Summary]![Key])) OR (((Paper_Summary.ID) Is Null)) ORDER BY Papers.ID, Papers.Author, Papers.Title;
Link To Column Definitions: Paper_Summary_Changed_List

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Summary_Ranges_Latest
Query_Type: Select
Query_DateCreated: 19/05/2018 23:14:14
Query_DateChanged: 19/05/2018 23:14:14
Query_SQL: SELECT "Paper_Summary_Ranges" AS Title, Min(Paper_Summary_Ranges.Latest_Paper_Range_Update) AS MinOfLatest_Paper_Range_Update FROM Paper_Summary_Ranges GROUP BY "Paper_Summary_Ranges";
Link To Column Definitions: Paper_Summary_Ranges_Latest

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Summary_Refs
Query_Type: Select
Query_DateCreated: 23/06/2007 20:07:52
Query_DateChanged: 20/10/2007 10:13:11
Query_SQL: SELECT Papers.ID, "<A HREF = ""PaperSummaries/PaperSummary_" & Mid(Str(100000+[ID]),3,2) & "/PaperSummary_" & [ID] & ".htm"">More</A>. " AS Paper_Summary FROM Papers;
Link To Column Definitions: Paper_Summary_Refs

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Topic_All
Query_Type: Select
Query_DateCreated: 12/04/2009 16:58:56
Query_DateChanged: 12/04/2009 16:59:23
Query_SQL: SELECT Paper_Topic_Union.ID, Paper_Topic_Union.Topic FROM Paper_Topic_Union GROUP BY Paper_Topic_Union.ID, Paper_Topic_Union.Topic;
Link To Column Definitions: Paper_Topic_All

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Topic1
Query_Type: Select
Query_DateCreated: 12/04/2009 16:56:35
Query_DateChanged: 12/04/2009 16:57:01
Query_SQL: SELECT Papers.ID, Papers.Topic FROM Papers WHERE (((Papers.Topic) Is Not Null));
Link To Column Definitions: Paper_Topic1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Topic2
Query_Type: Select
Query_DateCreated: 12/04/2009 16:57:10
Query_DateChanged: 12/04/2009 16:57:32
Query_SQL: SELECT Papers.ID, Papers.Topic2 AS Topic FROM Papers WHERE (((Papers.Topic2) Is Not Null));
Link To Column Definitions: Paper_Topic2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Paper_Topic3
Query_Type: Select
Query_DateCreated: 12/04/2009 16:57:41
Query_DateChanged: 12/04/2009 16:57:46
Query_SQL: SELECT Papers.ID, Papers.Topic3 AS Topic FROM Papers WHERE (((Papers.Topic3) Is Not Null));
Link To Column Definitions: Paper_Topic3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - Abstracts - Author (Search)
Query_Type: Select
Query_DateCreated: 28/05/2007 10:08:52
Query_DateChanged: 28/05/2007 10:50:58
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.Subject, Papers.Topic, Papers.[Sub-Topic], Papers.Abstract, Papers.Source, Papers.Pages FROM Papers WHERE (((Papers.Author) Like "*" & [Enter Author] & "*")) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Papers - Abstracts - Author (Search)

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - All - Categorised - Sub
Query_Type: Select
Query_DateCreated: 15/12/2010 14:12:17
Query_DateChanged: 15/12/2010 15:31:26
Query_SQL: SELECT [Papers - All - Categorised - Sub_Table].Category, [Papers - All - Categorised - Sub_Table].Author, [Papers - All - Categorised - Sub_Table].Title, [Papers - All - Categorised - Sub_Table].Priority, [Papers - All - Categorised - Sub_Table].Abstract, [Papers - All - Categorised - Sub_Table].Source, [Papers - All - Categorised - Sub_Table].Pages, [Papers - All - Categorised - Sub_Table].[Read?], [Papers - All - Categorised - Sub_Table].Topic, [Papers - All - Categorised - Sub_Table].ID2, [Papers - All - Categorised - Sub_Table].ID FROM [Papers - All - Categorised - Sub_Table] ORDER BY [Papers - All - Categorised - Sub_Table].Category, [Papers - All - Categorised - Sub_Table].Author, [Papers - All - Categorised - Sub_Table].Title;
Link To Column Definitions: Papers - All - Categorised - Sub

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - All - Categorised - Sub (Titles)
Query_Type: Select
Query_DateCreated: 15/12/2010 14:26:56
Query_DateChanged: 22/09/2013 17:33:24
Query_SQL: SELECT [Papers - All - Categorised - Sub (Titles) - Prelist]![Category] & "<BR>(" & [Count] & IIf([Count]=1," item)"," items)") AS Category, [Papers - All - Categorised - Sub (Titles) - Prelist].ID2 AS ID, Trim(Str(IIf(InStr([ID2],"_")=0,[ID2],Val(Left([ID2],InStr([ID2],"_")-1))))) AS Top_ID FROM [Papers - All - Categorised - Sub (Titles) - Prelist] ORDER BY [Papers - All - Categorised - Sub (Titles) - Prelist].Category;
Link To Column Definitions: Papers - All - Categorised - Sub (Titles)

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - All - Categorised - Sub (Titles) - Counter
Query_Type: Select
Query_DateCreated: 15/12/2010 15:46:19
Query_DateChanged: 22/09/2013 17:36:17
Query_SQL: SELECT ([Top_ID]) AS [Top ID], Count([Papers - All - Categorised - Sub (Titles)].ID) AS CountOfID FROM [Papers - All - Categorised - Sub (Titles)] GROUP BY ([Top_ID]);
Link To Column Definitions: Papers - All - Categorised - Sub (Titles) - Counter

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - All - Categorised - Sub (Titles) - Prelist
Query_Type: Select
Query_DateCreated: 15/12/2010 14:16:39
Query_DateChanged: 15/12/2010 15:33:34
Query_SQL: SELECT [Papers - All - Categorised - Sub].Category, [Papers - All - Categorised - Sub].ID2, [Papers - All - Categorised - Sub].Topic, Count([Papers - All - Categorised - Sub].ID) AS [Count] FROM [Papers - All - Categorised - Sub] GROUP BY [Papers - All - Categorised - Sub].Category, [Papers - All - Categorised - Sub].ID2, [Papers - All - Categorised - Sub].Topic;
Link To Column Definitions: Papers - All - Categorised - Sub (Titles) - Prelist

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - All - Categorised - Sub (Titles) - Prelist - Top
Query_Type: Select
Query_DateCreated: 15/12/2010 15:40:07
Query_DateChanged: 22/09/2013 17:34:09
Query_SQL: SELECT IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)) AS Category1, IIf(InStr([ID2],"_")=0,[ID2],[Topic]) AS ID, Count([Papers - All - Categorised - Sub].ID) AS [Count] FROM [Papers - All - Categorised - Sub] GROUP BY IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)), IIf(InStr([ID2],"_")=0,[ID2],[Topic]) ORDER BY IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)), IIf(InStr([ID2],"_")=0,[ID2],[Topic]);
Link To Column Definitions: Papers - All - Categorised - Sub (Titles) - Prelist - Top

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - All - Categorised - Sub (Titles) - Top
Query_Type: Select
Query_DateCreated: 15/12/2010 15:43:52
Query_DateChanged: 15/12/2010 15:52:11
Query_SQL: SELECT [Papers - All - Categorised - Sub (Titles) - Top1].Legend, [Papers - All - Categorised - Sub (Titles) - Top1].ID2, [Papers - All - Categorised - Sub (Titles) - Counter].CountOfID FROM [Papers - All - Categorised - Sub (Titles) - Top1] INNER JOIN [Papers - All - Categorised - Sub (Titles) - Counter] ON [Papers - All - Categorised - Sub (Titles) - Top1].ID2 = [Papers - All - Categorised - Sub (Titles) - Counter].[Top ID] GROUP BY [Papers - All - Categorised - Sub (Titles) - Top1].Legend, [Papers - All - Categorised - Sub (Titles) - Top1].ID2, [Papers - All - Categorised - Sub (Titles) - Counter].CountOfID ORDER BY [Papers - All - Categorised - Sub (Titles) - Top1].Legend;
Link To Column Definitions: Papers - All - Categorised - Sub (Titles) - Top

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - All - Categorised - Sub (Titles) - Top1
Query_Type: Select
Query_DateCreated: 15/12/2010 15:42:18
Query_DateChanged: 15/12/2010 15:43:21
Query_SQL: SELECT [Category1] & "<BR>(" & [Count] & IIf([Count]=1," item)"," items)") AS Legend, [Papers - All - Categorised - Sub (Titles) - Prelist - Top].ID AS ID2 FROM [Papers - All - Categorised - Sub (Titles) - Prelist - Top] ORDER BY [Papers - All - Categorised - Sub (Titles) - Prelist - Top].Category1;
Link To Column Definitions: Papers - All - Categorised - Sub (Titles) - Top1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers - Search for Update
Query_Type: Select
Query_DateCreated: 10/09/2005 12:42:39
Query_DateChanged: 30/06/2020 00:26:38
Query_SQL: SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Book_ID, Papers.Sequence, Papers.Priority, Papers.[Read?], Papers.[Precis?], Papers.[Referenced?], Papers.Subject, Papers.Subject2, Papers.Subject3, Papers.Topic, Papers.Topic2, Papers.Topic3, Papers.Medium, Papers.Location, Papers.Book, Papers.[Sub-Topic], Papers.[Sub-Topic2], Papers.[Sub-Topic3], Papers.Comments, Papers.Abstract, Papers.Abstract_Quality, Papers.Source, Papers.Pages, Papers.Difficulty, Papers.Estimate, Papers.[Actual - Total], Papers.[Hours Left], Papers.Status, Papers.[On_Laptop?], Papers.[Photopcopy?], Papers.[Abstract_Fixed?], Papers.Write_Up_Note_ID FROM Papers WHERE (((Papers.Author) Like "*" & [Enter String] & "*")) OR (((Papers.Title) Like "*" & [Enter String] & "*")) OR (((Papers.Comments) Like "*" & [Enter String] & "*")) OR (((Papers.Book) Like "*" & [Enter String] & "*")) OR (((Papers.Abstract) Like "*" & [Enter String] & "*")) OR (((Papers.Source) Like "*" & [Enter String] & "*")) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Papers - Search for Update

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers_By_SubTopic1
Query_Type: Select
Query_DateCreated: 27/07/2009 09:59:24
Query_DateChanged: 30/07/2009 17:53:07
Query_SQL: SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Paper - By Subtopic" AS Medium, qryBooks.ID1 AS [Book ID], Papers.ID AS [Paper ID], Papers.Author, Papers.Title, Papers.Source, Papers.[Sub-Topic], Papers.Priority, IIf([Papers]![Read?]=Yes,"Yes") AS [Read?] FROM (((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) INNER JOIN ((Papers INNER JOIN qryBooks ON Papers.Book = qryBooks.IDs) LEFT JOIN Papers_Cited ON Papers.ID = Papers_Cited.[Paper ID]) ON [Sub-Topics].ID = Papers.[Sub-Topic] WHERE (((IIf([Note_From]=0,IIf([Papers]![Priority]<4,1,0),IIf([Max_Level]>1,IIf([Note_Level]<1,IIf([Papers]![Priority]<4,1,0),IIf([Papers]![Priority]<2,1,0)),IIf([Papers]![Priority]<2,1,0))))=1) AND ((Papers_Cited.[Paper ID]) Is Null));
Link To Column Definitions: Papers_By_SubTopic1

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers_By_SubTopic2
Query_Type: Select
Query_DateCreated: 27/07/2009 09:58:23
Query_DateChanged: 30/07/2009 17:52:44
Query_SQL: SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Paper - By Subtopic" AS Medium, qryBooks.ID1 AS [Book ID], Papers.ID AS [Paper ID], Papers.Author, Papers.Title, Papers.Source, Papers.[Sub-Topic2], Papers.Priority, IIf([Papers]![Read?]=Yes,"Yes") AS [Read?] FROM (((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) INNER JOIN ((Papers INNER JOIN qryBooks ON Papers.Book = qryBooks.IDs) LEFT JOIN Papers_Cited ON Papers.ID = Papers_Cited.[Paper ID]) ON [Sub-Topics].ID = Papers.[Sub-Topic2] WHERE (((IIf([Note_From]=0,IIf([Papers]![Priority]<4,1,0),IIf([Max_Level]>1,IIf([Note_Level]<1,IIf([Papers]![Priority]<4,1,0),IIf([Papers]![Priority]<2,1,0)),IIf([Papers]![Priority]<2,1,0))))=1) AND ((Papers_Cited.[Paper ID]) Is Null));
Link To Column Definitions: Papers_By_SubTopic2

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers_By_SubTopic3
Query_Type: Select
Query_DateCreated: 27/07/2009 09:57:48
Query_DateChanged: 30/07/2009 17:52:31
Query_SQL: SELECT Note_Usage_Temp.Note_ID AS [Note ID], "Paper - By Subtopic" AS Medium, qryBooks.ID1 AS [Book ID], Papers.ID AS [Paper ID], Papers.Author, Papers.Title, Papers.Source, Papers.[Sub-Topic3], Papers.Priority, IIf([Papers]![Read?]=Yes,"Yes") AS [Read?] FROM (((Note_Usage_Temp INNER JOIN Notes ON Note_Usage_Temp.Note_ID = Notes.ID) INNER JOIN [Sub-Topics] ON Notes.Item_Title = [Sub-Topics].[Sub-Topic]) INNER JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group) INNER JOIN ((Papers INNER JOIN qryBooks ON Papers.Book = qryBooks.IDs) LEFT JOIN Papers_Cited ON Papers.ID = Papers_Cited.[Paper ID]) ON [Sub-Topics].ID = Papers.[Sub-Topic3] WHERE (((IIf([Note_From]=0,IIf([Papers]![Priority]<4,1,0),IIf([Max_Level]>1,IIf([Note_Level]<1,IIf([Papers]![Priority]<4,1,0),IIf([Papers]![Priority]<2,1,0)),IIf([Papers]![Priority]<2,1,0))))=1) AND ((Papers_Cited.[Paper ID]) Is Null));
Link To Column Definitions: Papers_By_SubTopic3

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers_Cited
Query_Type: Select
Query_DateCreated: 31/10/2007 21:44:19
Query_DateChanged: 02/08/2013 22:13:25
Query_SQL: SELECT Note_Usage_Temp.Note_ID AS [Note ID], IIf([Origin]="Note","Paper - Cited","Paper - Referencing") AS Medium, qryBooks.ID1 AS [Book ID], Papers.ID AS [Paper ID], Papers.Author, Papers.Title, Papers.Source, Papers.[Sub-Topic], Papers.Priority, IIf([Papers]![Read?]=Yes,"Yes") AS [Read?] FROM (Notes INNER JOIN (Note_Usage_Temp INNER JOIN (Note_Paper_Links INNER JOIN (Papers INNER JOIN qryBooks ON Papers.Book = qryBooks.IDs) ON Note_Paper_Links.Paper = Papers.ID) ON Note_Usage_Temp.Note_ID = Note_Paper_Links.Note) ON Notes.ID = Note_Usage_Temp.Note_ID) LEFT JOIN Citations_Note_Group ON Notes.Note_Group = Citations_Note_Group.Note_Group WHERE (((Note_Paper_Links.Timestamp)=0));
Link To Column Definitions: Papers_Cited

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Papers_On_Order
Query_Type: Select
Query_DateCreated: 04/09/2013 19:15:18
Query_DateChanged: 04/09/2013 19:15:18
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.Location, Papers.Priority FROM Papers WHERE (((Papers.Location)="In transit"));
Link To Column Definitions: Papers_On_Order

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: PaperSummaries_Changed_List
Query_Type: Select
Query_DateCreated: 17/12/2008 08:37:24
Query_DateChanged: 26/09/2014 13:16:19
Query_SQL: SELECT Papers.ID, Papers.Author, Papers.Title, Abstract_Refs.Abstract AS [Abstract / Comment], IIf([Quality]<>"","<img src=""../../" & [Icon] & """ alt=""" & [Display_Text] & " Abstract"">","") AS [Abstract Quality], Papers.Write_Up_Note_ID AS [Write-Up Note], Subjects.Subject AS Subject, Subjects_1.Subject AS [Subject 2], Subjects_2.Subject AS [Subject 3], Topics.Topic, Topics_1.Topic AS [Topic 2], Topics_2.Topic AS [Topic 3], [Sub-Topics].[Sub-Topic] AS [Sub-Topic], [Sub-Topics_1].[Sub-Topic] AS [Sub-Topic 2], [Sub-Topics_2].[Sub-Topic] AS [Sub-Topic 3], "<A HREF = ""../../BookSummaries/BookSummary_" & Mid(Str(100000+[qryBooks]![ID1]),3,2) & "/BookSummary_" & [qryBooks]![ID1] & ".htm"">" & IIf(Len([A+T])>150,Replace(Left([A+T],150) & "...","Various - ",""),Replace([A+T],"Various - ","")) & "</A>" AS [Book/Folder], Papers.Location, Papers.Medium, Papers.Source, Papers.Pages, Papers.Priority, Papers.Difficulty, Papers.Estimate AS [Estimated Hours], Nz([Actual - Total]) AS [Total Actual Hours], Papers.[Hours Left], Papers.Status, IIf([Read?]=True,"Yes","") AS [Read], IIf([Precis?]=True,"Yes","") AS Precis, IIf([Referenced?]=True,"Yes","") AS Referenced, IIf([On_Laptop?]=True,"Yes","") AS [Soft Copy], IIf([Photopcopy?]=True,"Yes","") AS [Hard Copy], IIf([CountOfNote] & ""="","","<A HREF = ""PapersToNotes_" & [Papers]![ID] & ".htm"">Notes</A>") AS [Notes Referencing this Paper] FROM (((((((((Paper_Summary_Temp INNER JOIN ((((Papers LEFT JOIN Subjects ON Papers.Subject = Subjects.ID) LEFT JOIN Subjects AS Subjects_1 ON Papers.Subject2 = Subjects_1.ID) LEFT JOIN Subjects AS Subjects_2 ON Papers.Subject3 = Subjects_2.ID) LEFT JOIN qryBooks ON Papers.Book = qryBooks.IDs) ON Paper_Summary_Temp.ID = Papers.ID) LEFT JOIN Topics ON Papers.Topic = Topics.ID) LEFT JOIN Topics AS Topics_1 ON Papers.Topic2 = Topics_1.ID) LEFT JOIN Topics AS Topics_2 ON Papers.Topic3 = Topics_2.ID) LEFT JOIN [Sub-Topics] ON Papers.[Sub-Topic] = [Sub-Topics].ID) LEFT JOIN [Sub-Topics] AS [Sub-Topics_1] ON Papers.[Sub-Topic2] = [Sub-Topics_1].ID) LEFT JOIN [Sub-Topics] AS [Sub-Topics_2] ON Papers.[Sub-Topic3] = [Sub-Topics_2].ID) LEFT JOIN Abstract_Refs ON Papers.ID = Abstract_Refs.ID) LEFT JOIN Paper_Note_Counts ON Papers.ID = Paper_Note_Counts.Paper) LEFT JOIN Quality_Markers ON Papers.Abstract_Quality = Quality_Markers.Quality ORDER BY Papers.ID;
Link To Column Definitions: PaperSummaries_Changed_List

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: PapersWithBookLinks
Query_Type: Select
Query_DateCreated: 25/01/2009 20:05:44
Query_DateChanged: 28/06/2011 17:22:35
Query_SQL: SELECT Papers.ID, Left([Comments],200) AS Expr1 FROM Papers WHERE (((Left([Comments],200)) Like "*+B*")) ORDER BY Papers.ID;
Link To Column Definitions: PapersWithBookLinks

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosopher's Index Search
Query_Type: Select
Query_DateCreated: 17/08/2006 19:35:35
Query_DateChanged: 15/10/2017 10:00:21
Query_SQL: SELECT Philosophers_Index.* FROM Philosophers_Index WHERE (((Philosophers_Index.TI) Like "*" & [Enter String] & "*")) OR (((Philosophers_Index.AU) Like "*" & [Enter String] & "*")) OR (((Philosophers_Index.SO) Like "*" & [Enter String] & "*")) OR (((Philosophers_Index.AB) Like "*" & [Enter String] & "*")) ORDER BY Philosophers_Index.TI, Philosophers_Index.AU;
Link To Column Definitions: Philosopher's Index Search

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophers_Index_List_OA
Query_Type: Select
Query_DateCreated: 11/10/2010 14:16:29
Query_DateChanged: 19/03/2020 12:49:00
Query_SQL: SELECT Philosophers_Index.AU AS Author, Philosophers_Index.TI AS Title, Philosophers_Index.SO AS Source, Philosophers_Index.AB AS [Paper Abstract], Philosophers_Index.PY AS [Year] FROM Philosophers_Index WHERE (((Philosophers_Index.PY)>"1999") AND ((Philosophers_Index.TI) Like "*ontological argument*" And (Philosophers_Index.TI) Not Like "*deontological argument*")) OR (((Philosophers_Index.AB) Like "*ontological argument*" And (Philosophers_Index.AB) Not Like "*deontological argument*") AND ((Philosophers_Index.PY)>"1999")) ORDER BY Philosophers_Index.AU, Philosophers_Index.TI, Philosophers_Index.TI;
Link To Column Definitions: Philosophers_Index_List_OA

Tables / Queries Used By This QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophers_Index_List_OA (Letters)
Query_Type: Select
Query_DateCreated: 11/10/2010 15:00:31
Query_DateChanged: 13/10/2010 11:42:12
Query_SQL: SELECT Left([AU],1) AS Expr1 FROM Philosophers_Index WHERE (((Philosophers_Index.TI) Like "*ontological argument*" And (Philosophers_Index.TI) Not Like "*deontological argument*") AND ((Philosophers_Index.PY)>"1999")) OR (((Philosophers_Index.PY)>"1999") AND ((Philosophers_Index.AB) Like "*ontological argument*" And (Philosophers_Index.AB) Not Like "*deontological argument*")) GROUP BY Left([AU],1) ORDER BY Left([AU],1);
Link To Column Definitions: Philosophers_Index_List_OA (Letters)

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophy Papers - All
Query_Type: Select
Query_DateCreated: 06/05/2007 18:26:16
Query_DateChanged: 03/12/2011 13:08:46
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.Priority, Topics.Topic, [Sub-Topics].[Sub-Topic], IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Source, Papers.Pages, IIf([Papers]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], Papers.ID FROM (Papers INNER JOIN [Sub-Topics] ON Papers.[Sub-Topic] = [Sub-Topics].ID) INNER JOIN Topics ON Papers.Topic = Topics.ID WHERE (((Papers.Author)<>"Admin")) ORDER BY Papers.Author, Papers.Title, Papers.Priority;
Link To Column Definitions: Philosophy Papers - All

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophy Papers - All - Categorised
Query_Type: Select
Query_DateCreated: 28/09/2009 09:27:22
Query_DateChanged: 28/09/2009 09:27:23
Query_SQL: SELECT [Philosophy Papers - All - Categorised_Table].Category, [Philosophy Papers - All - Categorised_Table].Author, [Philosophy Papers - All - Categorised_Table].Title, [Philosophy Papers - All - Categorised_Table].Priority, [Philosophy Papers - All - Categorised_Table].Abstract, [Philosophy Papers - All - Categorised_Table].Source, [Philosophy Papers - All - Categorised_Table].Pages, [Philosophy Papers - All - Categorised_Table].[Read?], [Philosophy Papers - All - Categorised_Table].Topic, [Philosophy Papers - All - Categorised_Table].ID2, [Philosophy Papers - All - Categorised_Table].ID FROM [Philosophy Papers - All - Categorised_Table] ORDER BY [Philosophy Papers - All - Categorised_Table].Category, [Philosophy Papers - All - Categorised_Table].Author, [Philosophy Papers - All - Categorised_Table].Title;
Link To Column Definitions: Philosophy Papers - All - Categorised

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophy Papers - All - Categorised - Recat
Query_Type: Select
Query_DateCreated: 20/01/2010 10:47:56
Query_DateChanged: 20/01/2010 21:32:57
Query_SQL: SELECT Duplicate_Webpages.Category1, [Philosophy Papers - All - Categorised_Table].ID2, Papers.Subject, Papers.Subject2, Papers.Subject3, Papers.Topic, Papers.Topic2, Papers.Topic3, Papers.[Sub-Topic], Papers.[Sub-Topic2], Papers.[Sub-Topic3], Papers.Author, Papers.Title FROM (Duplicate_Webpages INNER JOIN [Philosophy Papers - All - Categorised_Table] ON Duplicate_Webpages.Category1 = [Philosophy Papers - All - Categorised_Table].Category) INNER JOIN Papers ON [Philosophy Papers - All - Categorised_Table].ID = Papers.ID ORDER BY Duplicate_Webpages.Category1, [Philosophy Papers - All - Categorised_Table].ID2, Papers.Subject, Papers.Subject2, Papers.Subject3, Papers.Topic, Papers.Topic2, Papers.Topic3, Papers.[Sub-Topic], Papers.[Sub-Topic2], Papers.[Sub-Topic3], Papers.Author, Papers.Title;
Link To Column Definitions: Philosophy Papers - All - Categorised - Recat

Tables / Queries Used By This Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophy Papers - All - Categorised (Titles)
Query_Type: Select
Query_DateCreated: 20/09/2013 07:48:40
Query_DateChanged: 12/05/2014 23:53:36
Query_SQL: SELECT [Philosophy Papers - All - Categorised (Titles)_Table].Category, [Philosophy Papers - All - Categorised (Titles)_Table].ID, [Philosophy Papers - All - Categorised (Titles)_Table].Top_ID FROM [Philosophy Papers - All - Categorised (Titles)_Table] ORDER BY [Philosophy Papers - All - Categorised (Titles)_Table].Category, [Philosophy Papers - All - Categorised (Titles)_Table].ID;
Link To Column Definitions: Philosophy Papers - All - Categorised (Titles)

Tables / Queries Used By This QueryQueries Using this QueryCode Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophy Papers - All - Categorised (Titles) - Counter
Query_Type: Select
Query_DateCreated: 29/09/2009 20:47:47
Query_DateChanged: 21/09/2013 18:13:50
Query_SQL: SELECT [Philosophy Papers - All - Categorised (Titles)].[Top_ID] AS [Top ID], Count([Philosophy Papers - All - Categorised (Titles)].ID) AS CountOfID FROM [Philosophy Papers - All - Categorised (Titles)] GROUP BY [Philosophy Papers - All - Categorised (Titles)].[Top_ID];
Link To Column Definitions: Philosophy Papers - All - Categorised (Titles) - Counter

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophy Papers - All - Categorised (Titles) - Prelist
Query_Type: Select
Query_DateCreated: 12/04/2009 17:31:00
Query_DateChanged: 27/09/2009 17:01:35
Query_SQL: SELECT [Philosophy Papers - All - Categorised].Category, [Philosophy Papers - All - Categorised].ID2, [Philosophy Papers - All - Categorised].Topic, Count([Philosophy Papers - All - Categorised].ID) AS [Count] FROM [Philosophy Papers - All - Categorised] GROUP BY [Philosophy Papers - All - Categorised].Category, [Philosophy Papers - All - Categorised].ID2, [Philosophy Papers - All - Categorised].Topic;
Link To Column Definitions: Philosophy Papers - All - Categorised (Titles) - Prelist

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophy Papers - All - Categorised (Titles) - Prelist - Top
Query_Type: Select
Query_DateCreated: 23/09/2009 10:02:37
Query_DateChanged: 21/09/2013 18:15:44
Query_SQL: SELECT IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)) AS Category1, IIf(InStr([ID2],"_")=0,[ID2],[Topic]) AS ID, Count([Philosophy Papers - All - Categorised].ID) AS [Count] FROM [Philosophy Papers - All - Categorised] GROUP BY IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)), IIf(InStr([ID2],"_")=0,[ID2],[Topic]) ORDER BY IIf(InStr([Category]," -")=0,[Category],Left([Category],InStr([Category]," -")-1)), IIf(InStr([ID2],"_")=0,[ID2],[Topic]);
Link To Column Definitions: Philosophy Papers - All - Categorised (Titles) - Prelist - Top

Tables / Queries Used By This QueryQueries Using this Query Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Philosophy Papers - All - Categorised (Titles) - Solitons
Query_Type: Select
Query_DateCreated: 20/09/2013 07:39:29
Query_DateChanged: 13/05/2014 13:09:59
Query_SQL: SELECT [Philosophy Papers - All - Catego