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 (619 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_Date_Fixes
Aeon_LookupAeon_Missing_Author_NarrativesAeon_Papers_Add_PrelistAeon_Papers_LastYearHours_Total
Aeon_Papers_Update_Query_Year_ChkAeon_PrioritiseAeon_SearchAeon_Test_Time
Aeon_Timesheet_UpdatesAeon_Timesheet_Updates_PrelistAmbiguous_ObjectsArchived_Notes_Files
Author_Citation_CountsAuthor_Letters_LatestAuthorNarrs - Search for UpdateAuthors_Cited_By_Authors_List
Authors_Cited_By_Books_ListAuthors_Cited_By_Notes_ListAuthors_Cited_By_Papers_ListAuthors_List
Authors_List_AuthorsAuthors_List_ChangedAuthors_List_FixAuthors_List_Letter
Authors_List_Selected_AuthorsAuthors_List2Authors_SummaryAuthors_Summary (Letters)
Auto_Ref_Notes_Stats_DetailedAuto_Ref_Notes_Stats_Grand_SummaryAuto_Ref_Notes_Stats_Grandest_SummaryAuto_Ref_Notes_Stats_Summary
Auto_Translate_Reference_Notes_Actions_ListAverage_PlansBackup_Directory_Structure_ListBackup_Site_Map_List
Backup_Site_Map_SearchBible_Completion_Elapsed_DaysBible_Latest_Prelist_1Bible_Latest_Prelist_2
Bible_Latest_Verses_ReadBible_Latest_Verses_Read_1Bible_Progress_UpdtBible_Reading_Progress
Bible_Reading_Progress1Bible_Reading_Summary_1Blocked_Spider_FilesBook_Abstract_Quality_List
Book_Abstracts_RecentBook_Author_ListBook_Author_List_ChangedBook_Author_List_Changed1
Book_Book_ListBook_Book_List_ChangedBook_Book_List_Changed_NewBook_Book_List_Changed1
Book_Book_List_NewBook_Citings_List_New_ListBook_Citings_Page_ListBook_Citings_Page_List (Letters)
Book_Location_RefsBook_Note_CountsBook_Note_Link_ListBook_Note_Link_List_New
Book_Note_Link_RefsBook_Paper_FilingBook_Paper_ListBook_Paper_List_Changed
Book_Paper_List_Changed_NewBook_Paper_List_Changed1Book_Paper_List_NewBook_Papers_Changed
Book_Papers_Changed_FullBook_Papers1Book_Papers3Book_Papers4
Book_Papers5Book_Papers6Book_Papers7Book_Subject_All
Book_Subject_Topic_Subtopic_ListBook_Subject1Book_Subject2Book_Subject3
Book_SubTopic_AllBook_SubTopic1Book_SubTopic2Book_SubTopic3
Book_Summary_Changed_ListBook_Summary_Ranges_LatestBook_Summary_RefsBook_Topic_All
Book_Topic1Book_Topic2Book_Topic3Booklist - On Order
Booklist - Spare CopiesBookPaperAbstract_Ranges_LatestBookPaperAbstracts_List_ChangedBookPaperAbstracts_List_Query
BookPaperAbstracts_List_RangeBookPaperAbstracts_List_RegenBookPaperAbstracts_List_Regen_OldBookPaperAbstracts_List_Regen_Old_List
BookPaperControl_LatestBookPaperControl_ListBookPaperLinks_Ranges_LatestBooks - All
Books - All - CategorisedBooks - All - Categorised (Titles)Books - All - Categorised (Titles) - CounterBooks - All - Categorised (Titles) - Prelist
Books - All - Categorised (Titles) - Prelist - TopBooks - All - Categorised (Titles) - TopBooks - All - Categorised (Titles) - Top1Books - All (Letters)
Books - Collections of PapersBooks - MoveBooks - Papers CataloguedBooks - Papers Uncatalogued
Books - ReadBooks - RecentBooks - Recent - CategorisedBooks - Recent - Categorised (Titles)
Books - Recent - Categorised (Titles) - PrelistBooks - Recent (Letters)Books Search - GeneralBooks_By_SubTopic1
Books_By_SubTopic2Books_By_SubTopic3Books_CitedBooks_from_Papers_By_Subtopic
Books_from_Papers_CitedBooks_LocationsBooks_Locations (Titles)Books_Locations (Titles) - Counter
Books_Locations (Titles) - PrelistBooks_Locations (Titles) - Prelist - TopBooks_Locations (Titles) - TopBooks_Locations (Titles) - Top1
Books_Missing_By_Thesis_ChapterBooks_Nearly_ReadBooks_Versus_PapersBooks_Versus_Papers_List
Books_Versus_Papers_List_RegenBookSummaries_Changed_ListBookSummaryCountCostLocationCitations_Count
Citations_ListCitations_List_ShortCitations_Note_GroupCode_Archive_Table_Latest
Coxes_Farm_GardensCoxes_Farm_Photos_BackupCoxes_Farm_Pre_RepairsCoxes_Farm_Repairs
Cross_Reference_By_YearCross_Reference_Changes_By_MonthCross_Reference_Changes_By_YearCross_Reference_Latest
Cross_Reference_MaxIDCurrent_Year_Papers_Actuals_CheckDeleted_QueriesDevelopment_Log_Categories
Development_Log_ListDevelopment_Log_List_Complete_DateDevelopment_Log_List_Complete_Others_CategoryDevelopment_Log_List_Complete_Others_Category_Recent
Development_Log_List_Complete_Others_Category_Recent_PreviousDevelopment_Log_List_Complete_Own_CategoryDevelopment_Log_List_Complete_Own_Category_RecentDevelopment_Log_List_Complete_Own_Category_Recent_Previous
Development_Log_List_Outstanding_Others_CategoryDevelopment_Log_List_Outstanding_Others_Category_Pri1Development_Log_List_Outstanding_Others_PriorityDevelopment_Log_List_Outstanding_Own_Category
Development_Log_List_Outstanding_Own_Category_Pri1Development_Log_List_Outstanding_Own_PriorityDevelopment_Log_SearchDirectory_Structure_Suffixed
Dodgy_PapersDud_Abstracts_BooksDud_Abstracts_Books (Letters)Dud_Abstracts_Books_Updateable
Dud_Abstracts_PapersDud_Abstracts_Papers (Letters)Dud_Abstracts_Papers_UpdateableDud_Cross_References_This_Year
Dud_DevLog_DescriptionsDup_PapersDup_Papers1Duplicate_Papers
Duplicate_Papers_CountDuplicate_Papers_PrelistDuplicate_Papers_Temp_EditEarliest_Lang
Earliest_Lang_Dates_LingEarliest_Lang_Dates_Non_LingElectronic ResourcesElectronic Resources (Letters)
Full_Backup_Site_Map_SearchFull_Backup_Site_Map_Temp_Delete_ControlFull_Backup_Site_Map_Temp_Delete_FailedFunctor_Calls
Functor_Descriptions_ListFunctors_FbyNFunctors_NbyFHits_Pages_Totals
Hits_Pages_Totals_LastYearHome_Page_Static_Page_BackupsIdentity Papers - Abstracts - FullIdentity Papers - Abstracts - Full - SubTopic
Identity Papers - Abstracts - Full - SubTopic (Titles)Identity Papers - Abstracts - Full (Letters)Identity Papers - Abstracts - ReadIdentity Papers - Abstracts - Read - SubTopic
Identity Papers - Abstracts - Read - SubTopic (Titles)Identity Papers - Abstracts - Read (Letters)Identity Papers - Abstracts - Read (Updateable)Identity_Papers_SubTopic_All
Identity_Papers_SubTopic1Identity_Papers_SubTopic2Identity_Papers_SubTopic3IdentityBooks_Unreferenced
IdentityBooks_Unreferenced_CountIdentityPapersReadIdentityPapersRead_UnreferencedIdentityPapersRead_Unreferenced_Count
Image_UsageKoran_Latest_Prelist_1Koran_Latest_Verses_ReadKoran_Reading_Summary
Language_Animadversions_CountsLanguage_Animadversions_Counts_PrelistLanguage_Animadversions_ListLanguage_Animadversions_List1
Language_Animadversions_List2Language_Animadversions_List4Language_Animadversions_XRef1Language_Animadversions_XRef2
Large_Page_ListLarge_Page_List_CountLatest_ArchivesLing_Dialogue_Lesson_Counts
Ling_English_CategoriesLing_English_Category_CategoriesLing_English_Category_Extras_EditableLing_Language_Dialogue_List_All_Prelist
Ling_Language_Dialogue_List_LatinLing_Language_Dialogue_List_NonLatinLing_Language_Vocab_List_All_Prelist_1Ling_Language_Vocab_List_All_Prelist_1_ru_uk
Ling_Language_Vocab_List_All_Prelist_2Ling_Language_Vocab_List_LatinLing_Language_Vocab_List_NonLatinLing_Language_Vocab_Phrase_List_All_Prelist_1
Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_ukLing_Language_Vocab_Phrase_List_All_Prelist_2Ling_ProgressLing_Vocab_Categorised_List
Ling_Vocab_Lesson_CountsLocation_Group_IDsLocation_Supergroup_IDsMissing Priority Tasks For Timesheet
Missing_Papers_For_ActualsMissing_Webref_DisplayText_ListMissing_Webref_DisplayText_List_BooksMissing_Webref_DisplayText_List_Books_Count
Missing_Webref_DisplayText_List_CountMissing_Webref_DisplayText_List_Editable_ListNew_Year_Crosstab_Prime_NewYear_SubListNewSubTopics_GEN
Next_Qtr_PlansNGS_Latest_ImportNote_Archive_Regen_Ranges_LatestNote_Book_Link_Latest_Add2
Note_Book_Links_ListNote_Book_Links_List (Letters)Note_Book_Links_PrelimNote_Lengths_PI
Note_Links_LatestNote_ListNote_Paper_Link_Latest_Add2Note_Paper_Links_List
Note_Paper_Links_List (Letters)Note_Paper_Links_PrelimNote_Regen_Ranges_LatestNote_Snippet_Lookup
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_Raw_Link_Counts
Page_Regen_GEN_TestPaper_Abstract_Ranges_LatestPaper_Author_ListPaper_Author_List_Changed
Paper_Author_List_Changed1Paper_Book_ListPaper_Book_List_ChangedPaper_Book_List_Changed_New
Paper_Book_List_Changed1Paper_Book_List_NewPaper_Citings_List_New_ListPaper_Citings_Page_List
Paper_Citings_Page_List (Letters)Paper_Comment_PDF_UpdatePaper_Names_FixPaper_Note_Counts
Paper_Note_Link_ListPaper_Note_Link_RefsPaper_Pages_TotalPaper_Paper_List
Paper_Paper_List_ChangedPaper_Paper_List_Changed_NewPaper_Paper_List_Changed1Paper_Paper_List_New
Paper_Subject_AllPaper_Subject_Topic_Subtopic_ListPaper_Subject1Paper_Subject2
Paper_Subject3Paper_SubTopic_AllPaper_SubTopic1Paper_SubTopic2
Paper_SubTopic3Paper_Summary_Changed_ListPaper_Summary_Ranges_LatestPaper_Summary_Refs
Paper_Topic_AllPaper_Topic1Paper_Topic2Paper_Topic3
Papers - Abstracts - Author (Search)Papers - All - Categorised - SubPapers - All - Categorised - Sub (Titles)Papers - All - Categorised - Sub (Titles) - Counter
Papers - All - Categorised - Sub (Titles) - PrelistPapers - All - Categorised - Sub (Titles) - Prelist - TopPapers - All - Categorised - Sub (Titles) - TopPapers - All - Categorised - Sub (Titles) - Top1
Papers - Search for UpdatePapers_By_SubTopic1Papers_By_SubTopic2Papers_By_SubTopic3
Papers_CitedPapers_Inconsistently_ElectronicPapers_Inconsistently_Electronic_CountPapers_Inconsistently_Electronic_Editable
Papers_Missing_By_Thesis_ChapterPapers_On_OrderPapersToNotes_Prelims_GEN_ListPaperSummaries_Changed_List
PapersWithBookLinksPDF_File_ListPDF_File_List_CountPDF_Missing_List
PDF_Missing_List_CountPhilosopher'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_UsedPID_Books_Referenced_Undated_Editable
PID_Missing_Online_Papers_Editable_ListPID_Missing_Online_Papers_ListPID_Missing_Online_Papers_List_CountPID_Missing_Online_Papers_List_Summary
PID_Note_ID_LookupPID_Note_Reading_Lists_BooksPID_Note_Reading_Lists_Books_ChkPID_Note_Reading_Lists_Date_XChk
PID_Note_Reading_Lists_Date_XChk1PID_Note_Reading_Lists_ListPID_Note_Reading_Lists_List_SelectedPID_Note_Reading_Lists_Paper_Citation_Counts
PID_Note_Reading_Lists_PapersPID_Note_Reading_Lists_Papers_ChkPID_Notes_By_Thesis_ChapterPID_Notes_Unused_By_Thesis
PID_Notes_Unused_By_Thesis_CountPID_Notes_Unused_By_Thesis_Note_ListsPID_Notes_Unused_By_Thesis_Note_Lists_CountPID_Notes_Used_By_Thesis_Chapter
PID_Notes_Used_By_Thesis_Chapter_Notes_Lists_IDsPID_Notes_Used_By_Thesis_IDsPID_Pages_TotalPID_Papers_Filed
PID_Papers_Filed_Not_ReferencedPID_Papers_Filed_Not_Referenced_CountPID_Papers_Referenced_No_AbstractPID_Papers_Referenced_No_Abstract_Count
PID_Papers_Referenced_No_Abstract_EditablePID_Papers_Referenced_UndatedPID_Papers_Referenced_Undated_CountPID_Papers_Referenced_Undated_Editable
Precis_Web_GenPrecis_Web_Gen (Titles)qry_PID_Note_Reading_Lists_Bookqry_PID_Note_Reading_Lists_Note
qry_PID_Note_Reading_Lists_PaperqryActualvsPlanqryAuthorsqryAuthorsBooks
qryAuthorsPapersqryBook_N+TsqryBooksqryLocations
qryNextQtrPlanqryPapersqryPaperTitlesqryPlanRestOfYear1
qryPlanRestOfYear2qrySearch_Webrefs_TableqrySubjectsqryWebRefs_Check_Manual
qryYearPlanAverageqryYearPlanAverage_NextYearqryYearPlanAverage_ThisYearqryYTDActuals
Query_Name_Fragment_ListQuery10Query11Query12
Query13Query14Query16Query17
Query19Query2Query20Query21
Query22Query23Query24Query25
Query26Query27Query28Query29
Query3Query31Query32Query33
Query34Query35Query36Query37
Query38Query6Query7Query8
Query9Raw_Broken_Links_CountsRaw_Broken_Links_Counts_DetailRaw_Broken_Links_Detail_List
Raw_Broken_Links_Fixed_CountsRaw_Broken_Links_Old_Counts_DetailRecent_Notes_Books_LinksRecent_Notes_Papers_Links
Reporting_PeriodsReusedQueryNamesSearch_Photos_RawSnippet_List
Spider_Audit_1Spider_Audit_2Spider_Directory_Structure_ListSpider_Missing_Internal_Links
Spider_Missing_LinksSpider_WebLink_Fix_CheckSpider_WebLink_Fix_Check_ConsolidatedSpider_WebLink_Fix_Check_Counts
Spider_WebLink_Fix_Check_Counts_NotDefunctSpider_WebLink_Fix_Check_Counts_PrelistSpider_WebLink_Fix_Check_Counts_Prelist_NotDefunctSpider_WebLink_Fix_Check_NotDefunct
Spider_WebLink_Full_ListSpider_WeblinksSpider_Weblinks_Leading_SpaceSpider_Webrefs_Add_Check
strDevelopmentsSub_Notes_TempSub_Topics_ListSubject_Topic_Unclassifieds
SubjectEqualsTopicSubTopic_From_Topic1SubTopic_From_Topic2SubTopic_From_Topic3
Sub-Topics_ID_MaxTemp_PIDThesis_ChaptersThesis_Note_XRef_List
Thesis_Progress_Dashboard_ListThesis_Reading_ListThesis_Reading_List_CitedThesis_Reading_List_Cited_Count
Thesis_Reading_List_Cited_NoteThesis_Reading_List_CountThesis_Reading_ListsThesis_Reading_Lists_Books
Thesis_Reading_Lists_PapersThis_Qtr_PlansTime_By_Language_Locations_CurrentTime_By_Weekday_QTD
Time_By_Weekday_YTDTime_This_MonthTime_This_Month_Grand_Tots_NewTime_This_Month_New_Full
Time_This_Month_PrelistTime_This_Month_Prelist_NewTime_This_Month_Prelist1Time_This_Month_Prelist1_New
Time_This_Month_TotsTime_This_Month_Tots_NewTimeline_CoxesFarmTimeline_Duplicate_Secondary_IDs
Timeline_Second_IDsTopicEqualsSubTopicTopics_ID_MaxUnused_Queries
Unused_VariablesVariable_Code_Name_ClashesWebLink_Fix_Check_CountsWebLink_Fix_Check_Counts_NotDefunct
WebLink_Fix_Check_Counts_PrelistWebLink_Fix_Check_Counts_Prelist_NotDefunctWebLink_Fix_Check_MapWebLink_Fix_Check_Map_NotDefunct
Weblink_Full_List_MapWebRefs_CodedWebRefs_DuplicatesWebRefs_Error_List
WebRefs_Error_SummaryWebrefs_To_Be_Added_By_SpiderWebrefs_To_Be_Added_By_Spider_DetailWebRefs_Translation_Check
Website_Regen_Control_ListWebsite_Regen_Last_Run_StartWebsite_Regen_LatestWorks_Missing_By_Thesis_Chapter
Works_Missing_By_Thesis_Chapter_CountYear_Crosstab_Prime_PeriodsYear_Crosstab_Prime_Task_GroupsYear_Crosstab_Prime_Task_Periods
Year_PlansYTD_Plansyy_Gen.

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_Date_Fixes
Query_Type: Select
Query_DateCreated: 09/04/2021 15:49:13
Query_DateChanged: 10/10/2021 23:42:29
Query_SQL: SELECT PID_Note_Reading_Lists.Note_Title, PID_Note_Reading_Lists.Note_ID, PID_Note_Reading_Lists.Category, Papers.Author, Papers.Title, Papers.Comments, PID_Note_Reading_Lists.Item_Year, Papers.Source, Papers.Pages, Papers.[On_Laptop?], PID_Note_Reading_Lists.[Aeon_Video_Fixed?], "Fix pages, Category, Date + On Laptop. Print to PDF." AS [To Do] FROM PID_Note_Reading_Lists INNER JOIN Papers ON PID_Note_Reading_Lists.Called_ID = Papers.ID WHERE (((Papers.Source) Like "Aeon, *") AND ((Papers.[On_Laptop?])=No) AND ((PID_Note_Reading_Lists.[Aeon_Video_Fixed?])=No)) ORDER BY PID_Note_Reading_Lists.Note_Title, PID_Note_Reading_Lists.Category, Papers.Author, Papers.Title;
Link To Column Definitions: Aeon_Date_Fixes

Tables / Queries Used By This QueryCode Using 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_Missing_Author_Narratives
Query_Type: Select
Query_DateCreated: 02/06/2022 14:33:27
Query_DateChanged: 02/06/2022 14:33:27
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.[Video?])=False) AND ((Aeon_Files.Aeon_Author_Narrative) Is Null) AND ((Aeon_Files.Aeon_Note_ID)=1292) AND ((Aeon_Files.[Read?])=True) 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_Missing_Author_Narratives

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


Query_Name: Aeon_Papers_Add_Prelist
Query_Type: Select
Query_DateCreated: 06/04/2021 19:33:01
Query_DateChanged: 10/04/2023 11:40:10
Query_SQL: SELECT "+W" & [WebRef_ID] & "W+" AS WebRef, IIf([Author_Names] & ""="","Aeon",Replace(Replace([Author_Names] & "","+A",""),"A+","")) AS Authors, IIf([Video?]=True,"Video - ","") & [Aeon_Files]![Aeon_Title] AS Aeon_Title, Aeon_Files.Aeon_Extract, "<u>Notes</u>|..|" & IIf([TT_Notes] & ""="","|.|To be supplied.",[TT_Notes]) & "|..|" AS [TT Notes], "|..|" & IIf([Aeon_SubTitle] & ""="","","|.|Sub-Title: ""|Colour_2|" & [Aeon_SubTitle] & "|Colour_R|""") & "|.|For the full text see +W" & [WebRef_ID] & "W+." & IIf([Video?]=True,"|.|Aeon Video.","") & "|..|" AS Comments, Aeon_Files.Identity_Note_ID, Aeon_Files.[Read?], IIf([Aeon_Author_Narrative] & ""="","","<u>Author Narrative</u>|Colour_2|" & IIf(InStr([Aeon_Author_Narrative],"|##|")>0,"","|..||.|") & [Aeon_Author_Narrative] & IIf(InStr([Aeon_Author_Narrative],"|##|")>0,"","|..|") & "|Colour_R|") AS [Author Narr], FormatDateTime([Aeon_Date_Published],1) AS [Pub Date], Aeon_Files.Paper_ID, Aeon_Files.WebRef_ID FROM Aeon_Files WHERE (((Aeon_Files.Identity_Note_ID)>0) AND ((Aeon_Files.[Read?])=True) AND ((Aeon_Files.Paper_ID)=0) AND ((Aeon_Files.[Exclude?])=No)) ORDER BY IIf([Author_Names] & ""="","Aeon",Replace(Replace([Author_Names] & "","+A",""),"A+","")), Aeon_Files.Aeon_Note_ID, Aeon_Files.Author_Names;
Link To Column Definitions: Aeon_Papers_Add_Prelist

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: Aeon_Papers_LastYearHours_Total
Query_Type: Select
Query_DateCreated: 07/04/2021 20:10:48
Query_DateChanged: 10/10/2021 11:23:02
Query_SQL: SELECT 24006 AS [Paper_Actuals ID], Sum([Timesheet_Last Year].Hours) AS SumOfHours, 2021-2 AS [Year], "Update Paper_Actuals ... reduce by the Hours in this Query" AS Comments FROM (Papers INNER JOIN (Aeon_Papers_Add_Prelist INNER JOIN [Timesheet_Last Year] ON Aeon_Papers_Add_Prelist.WebRef = [Timesheet_Last Year].Topic) ON (Papers.Title = Aeon_Papers_Add_Prelist.Aeon_Title) AND (Papers.Author = Aeon_Papers_Add_Prelist.Authors)) LEFT JOIN Paper_Actuals ON Papers.ID = Paper_Actuals.ID GROUP BY 24006, "Update Paper_Actuals ... reduce by the Hours in this Query";
Link To Column Definitions: Aeon_Papers_LastYearHours_Total

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


Query_Name: Aeon_Papers_Update_Query_Year_Chk
Query_Type: Select
Query_DateCreated: 07/04/2021 20:27:50
Query_DateChanged: 12/10/2022 19:17:30
Query_SQL: SELECT IIf([Reporting Year]<>2022,"Yes","No") AS Issue FROM Next_Reporting_Month;
Link To Column Definitions: Aeon_Papers_Update_Query_Year_Chk

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: 19/05/2023 14:41:55
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: Aeon_Search
Query_Type: Select
Query_DateCreated: 30/01/2021 19:19:00
Query_DateChanged: 30/01/2021 19:39:06
Query_SQL: SELECT Aeon_Files.* FROM Aeon_Files WHERE (((Aeon_Files.Aeon_Author_Narrative) Like "*" & [Enter Search String] & "*")) OR (((Aeon_Files.Aeon_Title) Like "*" & [Enter Search String] & "*")) OR (((Aeon_Files.Author_Names) Like "*" & [Enter Search String] & "*")) OR (((Aeon_Files.Aeon_SubTitle) Like "*" & [Enter Search String] & "*")) OR (((Aeon_Files.Author_Names) Like "*" & [Enter Search String] & "*")) OR (((Aeon_Files.Aeon_Extract) Like "*" & [Enter Search String] & "*")) OR (((Aeon_Files.TT_Notes) Like "*" & [Enter Search String] & "*"));
Link To Column Definitions: Aeon_Search

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


Query_Name: Aeon_Test_Time
Query_Type: Select
Query_DateCreated: 09/04/2021 12:07:17
Query_DateChanged: 09/04/2021 12:11:45
Query_SQL: SELECT PID_Note_Reading_Lists.Note_Title, Count(Papers.ID) AS CountOfID FROM PID_Note_Reading_Lists INNER JOIN Papers ON PID_Note_Reading_Lists.Called_ID = Papers.ID WHERE (((Papers.Source) Like "Aeon, *") AND ((PID_Note_Reading_Lists.[Book/Paper])="Paper") AND ((Papers.ID)>24522)) GROUP BY PID_Note_Reading_Lists.Note_Title ORDER BY PID_Note_Reading_Lists.Note_Title;
Link To Column Definitions: Aeon_Test_Time

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


Query_Name: Aeon_Timesheet_Updates
Query_Type: Select
Query_DateCreated: 09/04/2021 16:08:56
Query_DateChanged: 20/06/2021 10:43:26
Query_SQL: SELECT Aeon_Timesheet_Updates_Prelist.Ref, Aeon_Timesheet_Updates_Prelist.Task, Aeon_Timesheet_Updates_Prelist.WebRef, Timesheet.[Topic Total], Aeon_Timesheet_Updates_Prelist.[To Do] FROM Timesheet INNER JOIN Aeon_Timesheet_Updates_Prelist ON Timesheet.Topic = Aeon_Timesheet_Updates_Prelist.WebRef GROUP BY Aeon_Timesheet_Updates_Prelist.Ref, Aeon_Timesheet_Updates_Prelist.Task, Aeon_Timesheet_Updates_Prelist.WebRef, Timesheet.[Topic Total], Aeon_Timesheet_Updates_Prelist.[To Do] HAVING (((Timesheet.[Topic Total])>"0"));
Link To Column Definitions: Aeon_Timesheet_Updates

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


Query_Name: Aeon_Timesheet_Updates_Prelist
Query_Type: Select
Query_DateCreated: 08/04/2021 14:04:31
Query_DateChanged: 09/04/2021 16:05:14
Query_SQL: SELECT "T-" & [ID]+30000 AS Ref, [Author] & " - " & [Title] AS Task, "+W" & [WebRef_ID] & "W+" AS WebRef, "Update timesheet" AS [To Do] FROM Aeon_Files INNER JOIN Papers ON Aeon_Files.Paper_ID = Papers.ID WHERE (((Papers.Source) Like "Aeon, *") AND ((Papers.ID)>24522));
Link To Column Definitions: Aeon_Timesheet_Updates_Prelist

Tables / Queries Used By This QueryQueries 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: 24/11/2020 20:01:57
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: Auto_Ref_Notes_Stats_Detailed
Query_Type: Select
Query_DateCreated: 24/09/2020 14:09:09
Query_DateChanged: 21/10/2020 18:04:27
Query_SQL: SELECT IIf([Object_Type]="Notes","Note","Other") AS [Object Category], Auto_Reference_Notes_Actions.Object_Type AS [Object Type], Sum(IIf([Accepted]=True,1,IIf([Suppressed]=True,0,IIf([Already_Linked]=True,1,0)))) AS [Accepted?], Sum(IIf([Suppressed]=True,1,0)) AS [Suppressed?], Sum(IIf([Ignored]=True,1,IIf([Already_Linked]=True,0,1))) AS [Unprocessed / Ignored?], Sum(IIf([Quoted_Text]=True,1,0)) AS [In Quoted Text?], Sum(IIf([Footnote]=True,1,0)) AS [In Footnote?] FROM Note_Alternates INNER JOIN Auto_Reference_Notes_Actions ON Note_Alternates.ID = Auto_Reference_Notes_Actions.Note_ID WHERE (((Note_Alternates.[Auto_Link?])=True) AND ((Auto_Reference_Notes_Actions.Cognate_Rejected)=False) AND ((Auto_Reference_Notes_Actions.In_Author)=False) AND ((Auto_Reference_Notes_Actions.In_HTML_Tag)=False)) GROUP BY IIf([Object_Type]="Notes","Note","Other"), Auto_Reference_Notes_Actions.Object_Type ORDER BY IIf([Object_Type]="Notes","Note","Other");
Link To Column Definitions: Auto_Ref_Notes_Stats_Detailed

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


Query_Name: Auto_Ref_Notes_Stats_Grand_Summary
Query_Type: Select
Query_DateCreated: 22/10/2020 20:02:33
Query_DateChanged: 24/10/2020 19:05:34
Query_SQL: SELECT IIf([Object_Type]="Notes","[" & [Item_Title] & "]+L" & [Note_ID] & "L+",[Item_Title]) AS [Note], IIf([Object_Type]="Notes","Note","Other") AS [Object Category], Sum(IIf([Accepted]=True,1,IIf([Suppressed]=True,0,IIf([Already_Linked]=True,1,0)))) AS [Accepted?], Sum(IIf([Suppressed]=True,1,0)) AS [Suppressed?], Sum(IIf([Ignored]=True,1,IIf([Already_Linked]=True,0,1))) AS [Unprocessed / Ignored?], Sum(IIf([Quoted_Text]=True,1,0)) AS [In Quoted Text?], Sum(IIf([Footnote]=True,1,0)) AS [In Footnote?] FROM Note_Alternates INNER JOIN Auto_Reference_Notes_Actions ON Note_Alternates.ID = Auto_Reference_Notes_Actions.Note_ID WHERE (((Auto_Reference_Notes_Actions.Cognate_Rejected)=False) AND ((Auto_Reference_Notes_Actions.In_Author)=False) AND ((Auto_Reference_Notes_Actions.In_HTML_Tag)=False) AND ((Note_Alternates.Item_Title)=[Item_Alt_Title])) GROUP BY IIf([Object_Type]="Notes","[" & [Item_Title] & "]+L" & [Note_ID] & "L+",[Item_Title]), IIf([Object_Type]="Notes","Note","Other"), Note_Alternates.Item_Title ORDER BY Note_Alternates.Item_Title, IIf([Object_Type]="Notes","Note","Other");
Link To Column Definitions: Auto_Ref_Notes_Stats_Grand_Summary

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


Query_Name: Auto_Ref_Notes_Stats_Grandest_Summary
Query_Type: Select
Query_DateCreated: 24/10/2020 17:43:19
Query_DateChanged: 24/10/2020 17:47:55
Query_SQL: SELECT IIf([Object_Type]="Notes","Note","Other") AS [Object Category], Sum(IIf([Accepted]=True,1,IIf([Suppressed]=True,0,IIf([Already_Linked]=True,1,0)))) AS [Accepted?], Sum(IIf([Suppressed]=True,1,0)) AS [Suppressed?], Sum(IIf([Ignored]=True,1,IIf([Already_Linked]=True,0,1))) AS [Unprocessed / Ignored?], Sum(IIf([Quoted_Text]=True,1,0)) AS [In Quoted Text?], Sum(IIf([Footnote]=True,1,0)) AS [In Footnote?] FROM Auto_Reference_Notes_Actions WHERE (((Auto_Reference_Notes_Actions.Cognate_Rejected)=False) AND ((Auto_Reference_Notes_Actions.In_Author)=False) AND ((Auto_Reference_Notes_Actions.In_HTML_Tag)=False)) GROUP BY IIf([Object_Type]="Notes","Note","Other") ORDER BY IIf([Object_Type]="Notes","Note","Other");
Link To Column Definitions: Auto_Ref_Notes_Stats_Grandest_Summary

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


Query_Name: Auto_Ref_Notes_Stats_Summary
Query_Type: Select
Query_DateCreated: 24/09/2020 13:46:33
Query_DateChanged: 21/10/2020 18:04:48
Query_SQL: SELECT IIf([Object_Type]="Notes","Note","Other") AS [Object Category], Sum(IIf([Accepted]=True,1,IIf([Suppressed]=True,0,IIf([Already_Linked]=True,1,0)))) AS [Accepted?], Sum(IIf([Suppressed]=True,1,0)) AS [Suppressed?], Sum(IIf([Ignored]=True,1,IIf([Already_Linked]=True,0,1))) AS [Unprocessed / Ignored?], Sum(IIf([Quoted_Text]=True,1,0)) AS [In Quoted Text?], Sum(IIf([Footnote]=True,1,0)) AS [In Footnote?] FROM Note_Alternates INNER JOIN Auto_Reference_Notes_Actions ON Note_Alternates.ID = Auto_Reference_Notes_Actions.Note_ID WHERE (((Note_Alternates.[Auto_Link?])=True) AND ((Auto_Reference_Notes_Actions.Cognate_Rejected)=False) AND ((Auto_Reference_Notes_Actions.In_Author)=False) AND ((Auto_Reference_Notes_Actions.In_HTML_Tag)=False)) GROUP BY IIf([Object_Type]="Notes","Note","Other") ORDER BY IIf([Object_Type]="Notes","Note","Other");
Link To Column Definitions: Auto_Ref_Notes_Stats_Summary

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


Query_Name: Auto_Translate_Reference_Notes_Actions_List
Query_Type: Select
Query_DateCreated: 26/10/2020 19:23:54
Query_DateChanged: 26/10/2020 23:26:21
Query_SQL: SELECT Auto_Translate_Reference_Notes_Actions.Timestamp_Logged, Auto_Translate_Reference_Notes_Actions.Object_Type, Auto_Translate_Reference_Notes_Actions.Object_ID, Auto_Translate_Reference_Notes_Actions.Timestamp, Auto_Translate_Reference_Notes_Actions.Key_Word_Offset, Auto_Translate_Reference_Notes_Actions.Tag_Found, Auto_Translate_Reference_Notes_Actions.Key_Word_Detected, Auto_Translate_Reference_Notes_Actions.Note_ID, Auto_Translate_Reference_Notes_Actions.Action_Taken FROM Auto_Translate_Reference_Notes_Actions WHERE (((Auto_Translate_Reference_Notes_Actions.Timestamp_Logged)>Now()-1)) ORDER BY Auto_Translate_Reference_Notes_Actions.Object_Type, Auto_Translate_Reference_Notes_Actions.Object_ID, Auto_Translate_Reference_Notes_Actions.Timestamp, Auto_Translate_Reference_Notes_Actions.Key_Word_Offset;
Link To Column Definitions: Auto_Translate_Reference_Notes_Actions_List

Tables / Queries Used By This QueryCode Using 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 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: 21/12/2022 18:44:34
Query_SQL: SELECT Backup_Site_Map.* 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: Bible_Completion_Elapsed_Days
Query_Type: Select
Query_DateCreated: 06/09/2022 19:56:43
Query_DateChanged: 27/12/2022 19:17:28
Query_SQL: SELECT Bible_Completion_Dates_Aim.OT_NT_LXX, IIf([Completion_Date_Actual]>0,[Completion_Date_Actual]-[Start],Now()-[Start]) AS Elapsed_Days FROM Bible_Completion_Dates_Aim INNER JOIN Bible_Reading_Summary ON Bible_Completion_Dates_Aim.OT_NT_LXX = Bible_Reading_Summary.OT_NT_LXX;
Link To Column Definitions: Bible_Completion_Elapsed_Days

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


Query_Name: Bible_Latest_Prelist_1
Query_Type: Select
Query_DateCreated: 02/08/2021 17:38:03
Query_DateChanged: 31/07/2022 19:32:19
Query_SQL: SELECT Bible_Reading_Control.OT_NT_LXX, Max(Bible_Reading_Control.Book_ID) AS MaxOfBook_ID FROM Bible_Reading_Control WHERE (((Bible_Reading_Control.Last_Verse_Read)>0) AND ((Bible_Reading_Control.Out_Of_Order)=No)) GROUP BY Bible_Reading_Control.OT_NT_LXX;
Link To Column Definitions: Bible_Latest_Prelist_1

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


Query_Name: Bible_Latest_Prelist_2
Query_Type: Select
Query_DateCreated: 02/08/2021 17:43:04
Query_DateChanged: 02/08/2021 17:43:25
Query_SQL: SELECT Bible_Reading_Control.OT_NT_LXX, Bible_Reading_Control.Book_ID, Max(Bible_Reading_Control.Chapter_No) AS MaxOfChapter_No FROM Bible_Latest_Prelist_1 INNER JOIN Bible_Reading_Control ON (Bible_Latest_Prelist_1.MaxOfBook_ID = Bible_Reading_Control.Book_ID) AND (Bible_Latest_Prelist_1.OT_NT_LXX = Bible_Reading_Control.OT_NT_LXX) WHERE (((Bible_Reading_Control.Last_Verse_Read)>0)) GROUP BY Bible_Reading_Control.OT_NT_LXX, Bible_Reading_Control.Book_ID;
Link To Column Definitions: Bible_Latest_Prelist_2

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


Query_Name: Bible_Latest_Verses_Read
Query_Type: Select
Query_DateCreated: 14/11/2022 13:23:22
Query_DateChanged: 14/11/2022 13:27:43
Query_SQL: SELECT Bible_Latest_Verses_Read_2.OT_NT_LXX, Bible_Latest_Verses_Read_2.[Last Verse Read], Bible_Latest_Verses_Read_2.OT_NT_LXX FROM Bible_Latest_Verses_Read_2 ORDER BY IIf([Bible_Latest_Verses_Read_2]![OT_NT_LXX]="OT",1,2), IIf([Bible_Latest_Verses_Read_2]![OT_NT_LXX]="Koran",2,1), Bible_Latest_Verses_Read_2.OT_NT_LXX;
Link To Column Definitions: Bible_Latest_Verses_Read

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


Query_Name: Bible_Latest_Verses_Read_1
Query_Type: Select
Query_DateCreated: 02/08/2021 17:57:33
Query_DateChanged: 14/11/2022 13:17:23
Query_SQL: SELECT Bible_Reading_Control.OT_NT_LXX, [Book_Name] & " " & [Chapter_No] & ":" & [Last_Verse_Read] AS [Last Verse Read] FROM Bible_Latest_Prelist_2 INNER JOIN Bible_Reading_Control ON (Bible_Latest_Prelist_2.MaxOfChapter_No = Bible_Reading_Control.Chapter_No) AND (Bible_Latest_Prelist_2.Book_ID = Bible_Reading_Control.Book_ID) AND (Bible_Latest_Prelist_2.OT_NT_LXX = Bible_Reading_Control.OT_NT_LXX) ORDER BY IIf([Bible_Reading_Control]![OT_NT_LXX]="OT",1,2), Bible_Latest_Prelist_2.OT_NT_LXX;
Link To Column Definitions: Bible_Latest_Verses_Read_1

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


Query_Name: Bible_Progress_Updt
Query_Type: Select
Query_DateCreated: 21/07/2021 01:35:20
Query_DateChanged: 24/07/2023 23:32:31
Query_SQL: SELECT Bible_Reading_Control.* FROM Bible_Reading_Control WHERE (((Bible_Reading_Control.OT_NT_LXX)="OT") AND ((Bible_Reading_Control.Book_Name)="1 Samuel")) OR (((Bible_Reading_Control.OT_NT_LXX)="LXX") AND ((Bible_Reading_Control.Book_Name)="2 Esdras")) OR (((Bible_Reading_Control.OT_NT_LXX)="NT2") AND ((Bible_Reading_Control.Book_Name)="John")) ORDER BY Bible_Reading_Control.OT_NT_LXX DESC , Bible_Reading_Control.Book_Name, Bible_Reading_Control.Chapter_No;
Link To Column Definitions: Bible_Progress_Updt

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


Query_Name: Bible_Reading_Progress
Query_Type: Select
Query_DateCreated: 02/07/2022 18:26:48
Query_DateChanged: 06/01/2023 23:42:25
Query_SQL: SELECT Bible_Reading_Progress1.OT_NT_LXX AS Testament, Bible_Reading_Progress1.[Total Verses], Bible_Reading_Progress1.[Start Date], Bible_Reading_Progress1.[Days Elapsed], Bible_Reading_Progress1.[Verses Read], Bible_Reading_Progress1.[Verses / Day], Bible_Reading_Progress1.[Verses to Read], Bible_Reading_Progress1.[Completion Aim], Bible_Reading_Progress1.[Estimated Completion Date] AS [Estimated / Actual Completion Date], Bible_Reading_Progress1.[Last Verse Read], IIf([Verses to Read]=0,"(Complete)<br>","") & Abs(DateValue([Estimated Completion Date])-DateValue([Completion Aim])) & IIf(DateValue([Estimated Completion Date])<DateValue([Completion Aim])," Days Ahead"," Days Behind") AS [Ahead / Behind] FROM Bible_Reading_Progress1 ORDER BY IIf([Bible_Reading_Progress1]![OT_NT_LXX]="OT",1,2), IIf([Bible_Reading_Progress1]![OT_NT_LXX]="LXX",1,2), Bible_Reading_Progress1.OT_NT_LXX;
Link To Column Definitions: Bible_Reading_Progress

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


Query_Name: Bible_Reading_Progress1
Query_Type: Select
Query_DateCreated: 21/07/2021 08:51:36
Query_DateChanged: 06/09/2022 20:12:05
Query_SQL: SELECT Bible_Reading_Summary.OT_NT_LXX, Bible_Reading_Summary.[Total Verses], Bible_Reading_Summary.Start AS [Start Date], Round([Elapsed_Days]) AS [Days Elapsed], Bible_Reading_Summary.[Verses Read], Round([Verses Read]/[Elapsed_Days],1) AS [Verses / Day], [Total Verses]-[Verses Read] AS [Verses to Read], Bible_Completion_Dates_Aim.Completion_Date_Aim AS [Completion Aim], IIf([Completion_Date_Actual]>0,[Completion_Date_Actual],Left(Now()+([Total Verses]-[Verses Read])*(Now()-[Start]+1)/[Verses Read],10)) AS [Estimated Completion Date], Bible_Latest_Verses_Read.[Last Verse Read] FROM ((Bible_Reading_Summary INNER JOIN Bible_Latest_Verses_Read ON Bible_Reading_Summary.OT_NT_LXX = Bible_Latest_Verses_Read.OT_NT_LXX) INNER JOIN Bible_Completion_Dates_Aim ON Bible_Reading_Summary.OT_NT_LXX = Bible_Completion_Dates_Aim.OT_NT_LXX) INNER JOIN Bible_Completion_Elapsed_Days ON Bible_Completion_Dates_Aim.OT_NT_LXX = Bible_Completion_Elapsed_Days.OT_NT_LXX ORDER BY IIf([Bible_Reading_Summary]![OT_NT_LXX]="OT",1,2), Bible_Reading_Summary.OT_NT_LXX;
Link To Column Definitions: Bible_Reading_Progress1

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


Query_Name: Bible_Reading_Summary_1
Query_Type: Select
Query_DateCreated: 21/07/2021 01:41:39
Query_DateChanged: 27/12/2022 19:14:37
Query_SQL: SELECT Bible_Reading_Control.OT_NT_LXX, Sum(Bible_Reading_Control.Verses) AS [Total Verses], Sum(Bible_Reading_Control.Last_Verse_Read) AS [Verses Read], Bible_Completion_Dates_Aim.Start_Date AS Start FROM Bible_Reading_Control INNER JOIN Bible_Completion_Dates_Aim ON Bible_Reading_Control.OT_NT_LXX = Bible_Completion_Dates_Aim.OT_NT_LXX GROUP BY Bible_Reading_Control.OT_NT_LXX, Bible_Completion_Dates_Aim.Start_Date;
Link To Column Definitions: Bible_Reading_Summary_1

Tables / Queries Used By This QueryQueries 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: 01/05/2021 00:31:22
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 INNER JOIN Books ON Book_Citings_List_New.Book_ID = Books.ID1 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: 19/02/2021 20:01:19
Query_SQL: SELECT Books.ID1, "<A HREF = ""BookSummaries/BookSummary_" & Mid(Str(100000+[Books]![ID1]),3,2) & "/BookSummary_" & [Books]![ID1] & ".htm"">Summary</A>" & "<br><A HREF = ""BookSummaries/BookSummary_" & Mid(Str(100000+[Books]![ID1]),3,2) & "/BooksToPapers_" & [Books]![ID1] & ".htm"">Papers</A>" & "<br><A HREF = ""BookSummaries/BookSummary_" & Mid(Str(100000+[Books]![ID1]),3,2) & "/BookPaperAbstracts/BookPaperAbstracts_" & [Books]![ID1] & ".htm"">Abstract</A>" & IIf(InStr([Image],".png")>0,[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: 11/08/2020 00:22:32
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)) LEFT 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: BookPaperAbstracts_List_Regen_Old
Query_Type: Select
Query_DateCreated: 10/10/2020 21:56:49
Query_DateChanged: 11/10/2020 23:41:33
Query_SQL: SELECT BookPaperAbstracts_List_Regen_Old_List.* FROM BookPaperAbstracts_List_Regen_Old_List INNER JOIN Books_To_Regen ON BookPaperAbstracts_List_Regen_Old_List.[Book ID] = Books_To_Regen.Book_ID ORDER BY BookPaperAbstracts_List_Regen_Old_List.[Book Author], BookPaperAbstracts_List_Regen_Old_List.[Book Title], BookPaperAbstracts_List_Regen_Old_List.Seq, BookPaperAbstracts_List_Regen_Old_List.[Paper Author], BookPaperAbstracts_List_Regen_Old_List.[Paper Title];
Link To Column Definitions: BookPaperAbstracts_List_Regen_Old

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


Query_Name: BookPaperAbstracts_List_Regen_Old_List
Query_Type: Select
Query_DateCreated: 10/10/2020 22:52:20
Query_DateChanged: 10/10/2020 22:52:34
Query_SQL: SELECT Int([BookPaperAbstracts_List_Query]![Book ID]) AS [Book ID], Int([BookPaperAbstracts_List_Query]![Paper ID]) AS [Paper ID], BookPaperAbstracts_List_Query.[Book Author], BookPaperAbstracts_List_Query.[Book Title], BookPaperAbstracts_List_Query.[Paper Author], BookPaperAbstracts_List_Query.[Paper Title], BookPaperAbstracts_List_Query.Source, BookPaperAbstracts_List_Query.[Read?], BookPaperAbstracts_List_Query.[Further Information], BookPaperAbstracts_List_Query.[Book Abstract], BookPaperAbstracts_List_Query.[Book Comments], BookPaperAbstracts_List_Query.[Paper Abstracts], BookPaperAbstracts_List_Query.[Paper Comments], BookPaperAbstracts_List_Query.Seq, BookPaperAbstracts_List_Query.Book_BlurbLen, BookPaperAbstracts_List_Query.Paper_BlurbLen, BookPaperAbstracts_List_Query.Write_Up_Note_ID, BookPaperAbstracts_List_Query.PseudoBook FROM BookPaperAbstracts_List_Query;
Link To Column Definitions: BookPaperAbstracts_List_Regen_Old_List

Tables / Queries Used By This QueryQueries Using 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: BookPaperControl_List
Query_Type: Select
Query_DateCreated: 16/02/2022 13:18:08
Query_DateChanged: 16/02/2022 19:08:02
Query_SQL: SELECT "<A Href=""../../" & [Link] & """>" & [Page Title] & "</A>" AS [Link to Page], BookPaperControl.Time_To_Regenerate, BookPaperControl.ID FROM BookPaperControl ORDER BY BookPaperControl.[Page Title];
Link To Column Definitions: BookPaperControl_List

Tables / Queries Used By This QueryCode 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: 26/07/2022 14:19:13
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_Missing_By_Thesis_Chapter
Query_Type: Select
Query_DateCreated: 09/03/2021 16:49:08
Query_DateChanged: 20/07/2022 20:56:17
Query_SQL: SELECT Notes.Item_Title AS [Calling Note], Cross_Reference.Calling_ID, Books.Author, Books.Title, "Book" AS [Work Type], Cross_Reference.Called_ID FROM ((Cross_Reference INNER JOIN Notes ON Cross_Reference.Calling_ID = Notes.ID) LEFT JOIN Thesis_Reading_Lists_Books ON (Cross_Reference.Calling_ID = Thesis_Reading_Lists_Books.Thesis_Chapter_Note_ID) AND (Cross_Reference.Called_ID = Thesis_Reading_Lists_Books.Called_ID)) INNER JOIN Books ON Cross_Reference.Called_ID = Books.ID1 WHERE (((Notes.Note_Group)=1) AND ((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B") AND ((Cross_Reference.Calling_Timestamp)=0) AND (([Book/Paper] & "")<>"Book")) GROUP BY Notes.Item_Title, Cross_Reference.Calling_ID, Books.Author, Books.Title, "Book", Cross_Reference.Called_ID HAVING (((Notes.Item_Title) Like "*thesis*" And Not (Notes.Item_Title)="Thesis - References")) ORDER BY Notes.Item_Title, Books.Author, Books.Title;
Link To Column Definitions: Books_Missing_By_Thesis_Chapter

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_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: 26/04/2021 10:35:35
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([Books]![Author]="Various",[Papers]![Author],""), IIf([Books]![Author]="Various",[Papers]![Title],""), 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: 27/04/2021 21:20:16
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 QueryQueries Using 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: 06/10/2021 17:54:39
Query_SQL: SELECT Development_Log.[Own_Website?], 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.[Own_Website?], 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: 01/06/2022 20:02:17
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 (([Abstract] & "")<>"") AND ((Books.[Abstract_Fixed?])=False)) 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: 01/06/2022 20:01:44
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 FROM Papers WHERE (((Papers.Abstract) Not Like "*|Colour_*") AND (([Abstract] & "")<>"") AND ((Papers.[Abstract_Fixed?])=False)) 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: Duplicate_Papers
Query_Type: Select
Query_DateCreated: 05/06/2021 16:04:31
Query_DateChanged: 13/06/2021 13:34:05
Query_SQL: SELECT "+P" & [ID] & "P+" AS Paper, "+B" & [Papers]![Book_ID] & "B+" AS Book, Papers.Pages, Papers.[Actual - Total] FROM (Duplicate_Papers_Prelist INNER JOIN Papers ON (Duplicate_Papers_Prelist.Author = Papers.Author) AND (Duplicate_Papers_Prelist.Title = Papers.Title)) INNER JOIN Duplicate_Papers_Temp ON Papers.ID = Duplicate_Papers_Temp.Paper_ID WHERE (((Duplicate_Papers_Temp.[Fixed?])=False)) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Duplicate_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: Duplicate_Papers_Count
Query_Type: Select
Query_DateCreated: 05/06/2021 16:25:07
Query_DateChanged: 05/06/2021 16:25:07
Query_SQL: SELECT Count(Duplicate_Papers.Paper) AS CountOfPaper FROM Duplicate_Papers;
Link To Column Definitions: Duplicate_Papers_Count

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


Query_Name: Duplicate_Papers_Prelist
Query_Type: Select
Query_DateCreated: 05/06/2021 15:59:51
Query_DateChanged: 05/06/2021 16:13:49
Query_SQL: SELECT Papers.Author, Papers.Title, Count(Papers.ID) AS CountOfID FROM Papers GROUP BY Papers.Author, Papers.Title HAVING (((Count(Papers.ID))>1));
Link To Column Definitions: Duplicate_Papers_Prelist

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


Query_Name: Duplicate_Papers_Temp_Edit
Query_Type: Select
Query_DateCreated: 13/06/2021 11:41:24
Query_DateChanged: 18/06/2021 23:18:16
Query_SQL: SELECT Duplicate_Papers_Temp.[Fixed?], Papers.ID, Papers.Author, Papers.Title, Papers.Comments, [Books]![Title] AS [Book Title], [Books]![Comments] AS [Book Comments], Duplicate_Papers_Temp.Pages, Duplicate_Papers_Temp.[Actual - Total], Papers.Abstract, Papers.Abstract_Quality FROM Books INNER JOIN (Duplicate_Papers_Temp INNER JOIN Papers ON Duplicate_Papers_Temp.Paper_ID = Papers.ID) ON Books.ID1 = Papers.Book_ID WHERE (((Duplicate_Papers_Temp.[Fixed?])=False)) ORDER BY Papers.Author, Papers.Title;
Link To Column Definitions: Duplicate_Papers_Temp_Edit

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


Query_Name: Earliest_Lang
Query_Type: Select
Query_DateCreated: 13/11/2020 10:45:55
Query_DateChanged: 12/12/2020 12:46:19
Query_SQL: SELECT Language_Location_Primer.Priority, Min(IIf([Date_Last_Study]>"0",[Date_Last_Study],"999999999")) AS Aeon, Min(Language_Location_Primer.[Date_Last_Study_Non_Ling]) AS Non_Aeon FROM Language_Location_Primer INNER JOIN Language_Animadversions_Counts_Prelist ON Language_Location_Primer.Language = Language_Animadversions_Counts_Prelist.Language GROUP BY Language_Location_Primer.Priority HAVING (((Language_Location_Primer.Priority)>0));
Link To Column Definitions: Earliest_Lang

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


Query_Name: Earliest_Lang_Dates_Ling
Query_Type: Select
Query_DateCreated: 13/11/2020 10:49:19
Query_DateChanged: 02/03/2022 19:50:32
Query_SQL: SELECT "Ling" AS Category, Language_Location_Primer.Priority, Val(IIf([Date_Last_Study] & ""="",0,[Date_Last_Study])) AS [Date], Language_Location_Primer.Language, Language_Location_Primer.Ling_Progress, Language_Location_Primer.Ling_Revision_Progress FROM Language_Location_Primer INNER JOIN Language_Animadversions_Counts_Prelist ON Language_Location_Primer.Language_Key = Language_Animadversions_Counts_Prelist.Language ORDER BY Language_Location_Primer.Priority, Val(IIf([Date_Last_Study] & ""="",0,[Date_Last_Study])), Language_Location_Primer.Language;
Link To Column Definitions: Earliest_Lang_Dates_Ling

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


Query_Name: Earliest_Lang_Dates_Non_Ling
Query_Type: Select
Query_DateCreated: 11/12/2020 12:50:47
Query_DateChanged: 02/03/2022 19:50:50
Query_SQL: SELECT "Non-Ling" AS Category, Language_Location_Primer.Priority, Val(IIf([Date_Last_Study_Non_Ling] & ""="",0,[Date_Last_Study_Non_Ling])) AS [Date], Language_Location_Primer.Language, "" AS Ling_Progress, "" AS Ling_Revision_Progress FROM Language_Location_Primer INNER JOIN Language_Animadversions_Counts_Prelist ON Language_Location_Primer.Language_Key = Language_Animadversions_Counts_Prelist.Language ORDER BY Language_Location_Primer.Priority, Val(IIf([Date_Last_Study_Non_Ling] & ""="",0,[Date_Last_Study_Non_Ling])), Language_Location_Primer.Language;
Link To Column Definitions: Earliest_Lang_Dates_Non_Ling

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_Backup_Site_Map_Search
Query_Type: Select
Query_DateCreated: 21/12/2022 18:42:13
Query_DateChanged: 21/12/2022 19:19:25
Query_SQL: SELECT Full_Backup_Site_Map.*, Full_Backup_Directory_Structure.Directory, Full_Backup_Directory_Structure.Directory_Level, Full_Backup_Directory_Structure.Timestamp_Indexed, Full_Backup_Directory_Structure.Directory_Timestamp FROM Full_Backup_Site_Map INNER JOIN Full_Backup_Directory_Structure ON Full_Backup_Site_Map.Directory_ID = Full_Backup_Directory_Structure.Directory_ID WHERE (((Full_Backup_Site_Map.FIle_Name) Like "*" & [Enter String] & "*")) ORDER BY Full_Backup_Site_Map.FIle_Name, Full_Backup_Directory_Structure.Directory_ID;
Link To Column Definitions: Full_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: Full_Backup_Site_Map_Temp_Delete_Control
Query_Type: Select
Query_DateCreated: 07/12/2022 12:36:58
Query_DateChanged: 07/12/2022 20:01:35
Query_SQL: SELECT Full_Backup_Directory_Structure_Temp.Directory, Full_Backup_Site_Map_Temp.File_Name, Full_Backup_Site_Map_Temp.Delete, Full_Backup_Site_Map_Temp.Deleted, Full_Backup_Site_Map_Temp.Deletion_Failed FROM Full_Backup_Site_Map_Temp INNER JOIN Full_Backup_Directory_Structure_Temp ON Full_Backup_Site_Map_Temp.Directory_ID = Full_Backup_Directory_Structure_Temp.Directory_ID WHERE (((Full_Backup_Site_Map_Temp.Delete)=Yes) AND ((Full_Backup_Site_Map_Temp.Deleted)=No)) ORDER BY Full_Backup_Directory_Structure_Temp.Directory, Full_Backup_Site_Map_Temp.File_Name;
Link To Column Definitions: Full_Backup_Site_Map_Temp_Delete_Control

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: Full_Backup_Site_Map_Temp_Delete_Failed
Query_Type: Select
Query_DateCreated: 07/12/2022 16:20:21
Query_DateChanged: 07/12/2022 19:57:42
Query_SQL: SELECT Full_Backup_Site_Map_Temp_Delete_Control.Directory, Full_Backup_Site_Map_Temp_Delete_Control.File_Name, Full_Backup_Site_Map_Temp_Delete_Control.Delete, Full_Backup_Site_Map_Temp_Delete_Control.Deleted, Full_Backup_Site_Map_Temp_Delete_Control.Deletion_Failed FROM Full_Backup_Site_Map_Temp_Delete_Control WHERE (((Full_Backup_Site_Map_Temp_Delete_Control.Deletion_Failed)=Yes)) ORDER BY Full_Backup_Site_Map_Temp_Delete_Control.File_Name, Full_Backup_Site_Map_Temp_Delete_Control.Directory;
Link To Column Definitions: Full_Backup_Site_Map_Temp_Delete_Failed

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


Query_Name: Functor_Calls
Query_Type: Select
Query_DateCreated: 05/10/2020 23:33:57
Query_DateChanged: 05/10/2020 23:37:20
Query_SQL: SELECT "+C" & [Called_Procedure_Name] & "C+" AS [Procedure Called], "+C" & [Calling_Procedure_Name] & "C+" AS [Called From], Code_Links_Table.Calling_Procedure_Line AS [From Line] FROM Code_Links_Table WHERE (((Code_Links_Table.Called_Procedure_Name) Like "Functor*") AND ((Code_Links_Table.Calling_Procedure_Name)<>"Functor")) ORDER BY "+C" & [Called_Procedure_Name] & "C+", "+C" & [Calling_Procedure_Name] & "C+", Code_Links_Table.Calling_Procedure_Line;
Link To Column Definitions: Functor_Calls

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: Functors_FbyN
Query_Type: Select
Query_DateCreated: 10/10/2020 09:51:40
Query_DateChanged: 04/03/2021 21:01:11
Query_SQL: SELECT "+CFunctor_" & Right([Functor_ID]+100,2) & "C+" AS Functor, IIf([Functor_Option]=0,"&nbsp;",[Functor_Option]) AS [Option], Functor_Usage.Functor_Parameter AS Parameter, IIf([Functor_Usage]![Embedded?]=True,"Yes","&nbsp") AS [Embedded?], "[" & [Item_Title] & "]++" & [Functor_Usage]![Note_ID] & "++" AS [Note] FROM Functor_Usage INNER JOIN Notes ON Functor_Usage.Note_ID = Notes.ID ORDER BY Functor_Usage.Functor_ID, Functor_Usage.Functor_Option, Notes.Item_Title, Functor_Usage.[Embedded?];
Link To Column Definitions: Functors_FbyN

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


Query_Name: Functors_NbyF
Query_Type: Select
Query_DateCreated: 10/10/2020 10:25:54
Query_DateChanged: 04/03/2021 21:01:25
Query_SQL: SELECT "[" & [Item_Title] & "]++" & [Functor_Usage]![Note_ID] & "++" AS [Note], "+CFunctor_" & Right([Functor_ID]+100,2) & "C+" AS Functor, IIf([Functor_Option]=0,"&nbsp;",[Functor_Option]) AS [Option], Functor_Usage.Functor_Parameter AS Parameter, IIf([Functor_Usage]![Embedded?]=True,"Yes","&nbsp") AS [Embedded?] FROM Functor_Usage INNER JOIN Notes ON Functor_Usage.Note_ID = Notes.ID ORDER BY Notes.Item_Title, Functor_Usage.Functor_ID, Functor_Usage.Functor_Option, Functor_Usage.[Embedded?];
Link To Column Definitions: Functors_NbyF

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


Query_Name: Hits_Pages_Totals
Query_Type: Select
Query_DateCreated: 09/10/2020 17:58:53
Query_DateChanged: 09/10/2020 17:58:53
Query_SQL: SELECT Min([Year] & "-" & Right([Month]+100,2)) AS [First Period], Max([Year] & "-" & Right([Month]+100,2)) AS [Last Period], Sum(Hits_Pages.Hits) AS SumOfHits FROM Hits_Pages;
Link To Column Definitions: Hits_Pages_Totals

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


Query_Name: Hits_Pages_Totals_LastYear
Query_Type: Select
Query_DateCreated: 09/10/2020 18:31:31
Query_DateChanged: 09/10/2020 18:38:24
Query_SQL: SELECT Min([Year] & "-" & Right([Month]+100,2)) AS [First Period], Max([Year] & "-" & Right([Month]+100,2)) AS [Last Period], Sum(Hits_Pages.Hits) AS SumOfHits FROM Hits_Pages WHERE (((Year(Now())*12+Month(Now())-([Year]*12+[Month]))<13));
Link To Column Definitions: Hits_Pages_Totals_LastYear

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: IdentityBooks_Unreferenced
Query_Type: Select
Query_DateCreated: 12/03/2021 21:00:54
Query_DateChanged: 12/03/2021 21:45:30
Query_SQL: SELECT IIf([Books]![Read?]=Yes,"Yes","") AS [Read?], [Sub-Topics].[Sub-Topic] AS [Sub-Topic1], [Sub-Topics_1].[Sub-Topic] AS [Sub-Topic2], [Sub-Topics_2].[Sub-Topic] AS [Sub-Topic3], "+B" & [ID1] & "B+" AS [Book Link] FROM (((Books LEFT JOIN PID_Note_Reading_Lists_Books ON Books.ID1 = PID_Note_Reading_Lists_Books.Called_ID) INNER 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 WHERE (((Books.Topic)=104) AND ((PID_Note_Reading_Lists_Books.Called_ID) Is Null)) OR (((PID_Note_Reading_Lists_Books.Called_ID) Is Null) AND ((Books.Topic2)=104)) OR (((PID_Note_Reading_Lists_Books.Called_ID) Is Null) AND ((Books.Topic3)=104)) ORDER BY IIf([Books]![Read?]=Yes,"Yes","") DESC , [Sub-Topics].[Sub-Topic], Books.Author, Books.Title;
Link To Column Definitions: IdentityBooks_Unreferenced

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: IdentityBooks_Unreferenced_Count
Query_Type: Select
Query_DateCreated: 02/06/2021 18:48:20
Query_DateChanged: 02/06/2021 19:11:12
Query_SQL: SELECT Count(IdentityBooks_Unreferenced.[Read?]) AS [CountOfRead?] FROM IdentityBooks_Unreferenced;
Link To Column Definitions: IdentityBooks_Unreferenced_Count

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


Query_Name: IdentityPapersRead
Query_Type: Select
Query_DateCreated: 10/03/2021 09:42:21
Query_DateChanged: 10/03/2021 09:48:59
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.ID, Papers.Source, Papers.Book_ID, Papers.Priority, [Sub-Topics].[Sub-Topic], IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0) AS Abstract, Papers.Pages 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: IdentityPapersRead

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


Query_Name: IdentityPapersRead_Unreferenced
Query_Type: Select
Query_DateCreated: 10/03/2021 09:47:23
Query_DateChanged: 30/03/2021 13:58:26
Query_SQL: SELECT IIf([PID_Note_Reading_Lists_Books]![Called_ID] & ""="","",IIf([Read?]=True,"Yes - but Book read","Yes")) AS [Book Cited?], IdentityPapersRead.[Sub-Topic], "+P" & [ID] & "P+" AS [Paper Link], "+B" & [IdentityPapersRead]![Book_ID] & "B+" AS [Book Link], IdentityPapersRead.Priority FROM ((IdentityPapersRead LEFT JOIN PID_Note_Reading_Lists_Books ON IdentityPapersRead.Book_ID = PID_Note_Reading_Lists_Books.Called_ID) LEFT JOIN PID_Note_Reading_Lists_Papers ON IdentityPapersRead.ID = PID_Note_Reading_Lists_Papers.Called_ID) LEFT JOIN Book_Paper_Solitons ON PID_Note_Reading_Lists_Books.Called_ID = Book_Paper_Solitons.Book_ID WHERE (((IIf([PID_Note_Reading_Lists_Books]![Called_ID] & ""="","",IIf([Read?]=True,"Yes - but Book read","Yes")))<>"Yes - but Book read") AND ((IdentityPapersRead.Author)<>"Todman (Theo)") AND (([CountOfPaper_ID] & IIf([PID_Note_Reading_Lists_Books]![Called_ID] & ""="","","Yes"))<>"1Yes") AND ((PID_Note_Reading_Lists_Papers.Called_ID) Is Null)) ORDER BY IIf([PID_Note_Reading_Lists_Books]![Called_ID] & ""="","",IIf([Read?]=True,"Yes - but Book read","Yes")), IdentityPapersRead.[Sub-Topic], IdentityPapersRead.Author, IdentityPapersRead.Title;
Link To Column Definitions: IdentityPapersRead_Unreferenced

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: IdentityPapersRead_Unreferenced_Count
Query_Type: Select
Query_DateCreated: 02/06/2021 19:01:48
Query_DateChanged: 02/06/2021 19:01:48
Query_SQL: SELECT Count(IdentityPapersRead_Unreferenced.[Book Cited?]) AS [CountOfBook Cited?] FROM IdentityPapersRead_Unreferenced;
Link To Column Definitions: IdentityPapersRead_Unreferenced_Count

Tables / Queries Used By This QueryCode 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: Koran_Latest_Prelist_1
Query_Type: Select
Query_DateCreated: 14/11/2022 13:06:11
Query_DateChanged: 14/11/2022 13:06:11
Query_SQL: SELECT Max(Koran.Surah) AS MaxOfSurah FROM Koran WHERE (((Koran.Verses_Read_English)>0));
Link To Column Definitions: Koran_Latest_Prelist_1

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


Query_Name: Koran_Latest_Verses_Read
Query_Type: Select
Query_DateCreated: 14/11/2022 13:07:59
Query_DateChanged: 14/11/2022 13:15:34
Query_SQL: SELECT "Koran" AS OT_NT_LXX, [Surah] & ":" & [Verses_Read_English] AS [Last Verse Read] FROM Koran INNER JOIN Koran_Latest_Prelist_1 ON Koran.Surah = Koran_Latest_Prelist_1.MaxOfSurah;
Link To Column Definitions: Koran_Latest_Verses_Read

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


Query_Name: Koran_Reading_Summary
Query_Type: Select
Query_DateCreated: 14/11/2022 13:32:10
Query_DateChanged: 27/12/2022 19:16:21
Query_SQL: SELECT "Koran" AS OT_NT_LXX, Sum(Koran.Verses) AS [Total Verses], Sum(Koran.Verses_Read_English) AS [Verses Read], Bible_Completion_Dates_Aim.Start_Date AS Start FROM Koran, Bible_Completion_Dates_Aim WHERE (((Bible_Completion_Dates_Aim.OT_NT_LXX)="Koran")) GROUP BY "Koran", Bible_Completion_Dates_Aim.Start_Date;
Link To Column Definitions: Koran_Reading_Summary

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


Query_Name: Language_Animadversions_Counts
Query_Type: Select
Query_DateCreated: 26/11/2020 13:32:04
Query_DateChanged: 26/11/2020 13:32:04
Query_SQL: SELECT Language_Animadversions_Counts_Prelist.Priority, Count(Language_Animadversions_Counts_Prelist.Language) AS CountOfLanguage FROM Language_Animadversions_Counts_Prelist GROUP BY Language_Animadversions_Counts_Prelist.Priority;
Link To Column Definitions: Language_Animadversions_Counts

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


Query_Name: Language_Animadversions_Counts_Prelist
Query_Type: Select
Query_DateCreated: 26/11/2020 13:25:39
Query_DateChanged: 26/11/2020 13:30:09
Query_SQL: SELECT Language_Location_Primer.Priority, Language_Animadversions.Language, Count(Language_Animadversions.ID) AS CountOfID FROM Language_Animadversions INNER JOIN Language_Location_Primer ON Language_Animadversions.Language = Language_Location_Primer.Language_Key GROUP BY Language_Location_Primer.Priority, Language_Animadversions.Language ORDER BY Language_Location_Primer.Priority, Language_Animadversions.Language;
Link To Column Definitions: Language_Animadversions_Counts_Prelist

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


Query_Name: Language_Animadversions_List
Query_Type: Select
Query_DateCreated: 28/10/2020 23:33:29
Query_DateChanged: 12/12/2020 10:44:22
Query_SQL: SELECT Language_Animadversions_List3.Language, Language_Animadversions_List3.ID, Language_Animadversions_List3.[Date Raised], Language_Animadversions_List3.Animadversion FROM Language_Animadversions_List3 ORDER BY IIf([Language]="General",0,1), Language_Animadversions_List3.Language, IIf([Date Raised]>"0",DateValue([Date Raised]),0);
Link To Column Definitions: Language_Animadversions_List

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


Query_Name: Language_Animadversions_List1
Query_Type: Select
Query_DateCreated: 27/10/2020 00:47:11
Query_DateChanged: 28/10/2020 21:27:22
Query_SQL: SELECT Language_Animadversions.Language, Language_Animadversions.ID, Language_Animadversions.Date_Raised AS [Date Raised], Language_Animadversions.Animadversion FROM Language_Animadversions ORDER BY IIf([Language]="General",0,1), Language_Animadversions.Language, Language_Animadversions.Date_Raised;
Link To Column Definitions: Language_Animadversions_List1

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


Query_Name: Language_Animadversions_List2
Query_Type: Select
Query_DateCreated: 05/11/2020 20:11:29
Query_DateChanged: 22/10/2022 21:46:22
Query_SQL: SELECT Language_Animadversions_List4.Language, Language_Animadversions_List4.ID, Language_Animadversions_List4.[Date Raised], "<b>Resources: </b><a href=""../../" & [Resources_Books] & """>Books</a>; " & "<a href=""../../" & [Resources_Papers] & """>Papers</a>" & IIf([50lang_ID] & ""<>"","; <a href=""https://www.50languages.com/phrasebook/en/" & [50lang_ID] & "/"">50languages.com</a>","") & "|.|<b>Hours spent this academic year:</b> " & [Time_This_Year] & IIf([Date_Last_Study] & ""="","","|.|<b>Date last Studied (Ling):</b> " & [Date_Last_Study]) & "|.|<b>Date last Studied (Non-Ling):</b> " & [Date_Last_Study_NonLing] & "|.|" & [Language_Animadversions_List4]![Animadversion] AS Animadversion FROM Language_Animadversions_List4;
Link To Column Definitions: Language_Animadversions_List2

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


Query_Name: Language_Animadversions_List4
Query_Type: Select
Query_DateCreated: 28/10/2020 21:10:15
Query_DateChanged: 24/01/2021 23:22:02
Query_SQL: SELECT Language_Animadversions_XRef2.[Called Language] AS [Language], 0 AS ID, 0 AS [Date Raised], "<b>References (" & Count([ID]) & ")</b>" AS Animadversion, Language_Animadversions_XRef2.Resources_Books, Language_Animadversions_XRef2.Resources_Papers, Language_Animadversions_XRef2.Date_Last_Study, Language_Animadversions_XRef2.Time_This_Year, Language_Animadversions_XRef2.Date_Last_Study_NonLing, Language_Animadversions_XRef2.[50Lang_ID] FROM Language_Animadversions_XRef2 GROUP BY Language_Animadversions_XRef2.[Called Language], 0, Language_Animadversions_XRef2.Resources_Books, Language_Animadversions_XRef2.Resources_Papers, Language_Animadversions_XRef2.Date_Last_Study, Language_Animadversions_XRef2.Time_This_Year, Language_Animadversions_XRef2.Date_Last_Study_NonLing, Language_Animadversions_XRef2.[50Lang_ID];
Link To Column Definitions: Language_Animadversions_List4

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


Query_Name: Language_Animadversions_XRef1
Query_Type: Select
Query_DateCreated: 28/10/2020 19:57:53
Query_DateChanged: 24/01/2021 23:18:09
Query_SQL: SELECT Language_Animadversions.Language, Language_Location_Primer.Resources_Books, Language_Location_Primer.Resources_Papers, Format([Language_Location_Primer]![Date_Last_Study],"Medium Date") AS Date_Last_Study, Language_Location_Primer.Time_This_Year, IIf([Date_Last_Study_Non_Ling]>"0",Format([Language_Location_Primer]![Date_Last_Study_Non_Ling],"Medium Date"),"None") AS Date_Last_Study_NonLing, Language_Location_Primer.[50Lang_ID] FROM Language_Animadversions LEFT JOIN Language_Location_Primer ON Language_Animadversions.Language = Language_Location_Primer.Language_Key GROUP BY Language_Animadversions.Language, Language_Location_Primer.Resources_Books, Language_Location_Primer.Resources_Papers, Format([Language_Location_Primer]![Date_Last_Study],"Medium Date"), Language_Location_Primer.Time_This_Year, IIf([Date_Last_Study_Non_Ling]>"0",Format([Language_Location_Primer]![Date_Last_Study_Non_Ling],"Medium Date"),"None"), Language_Location_Primer.[50Lang_ID] ORDER BY Language_Animadversions.Language;
Link To Column Definitions: Language_Animadversions_XRef1

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: Language_Animadversions_XRef2
Query_Type: Select
Query_DateCreated: 28/10/2020 20:08:12
Query_DateChanged: 24/01/2021 23:20:00
Query_SQL: SELECT Language_Animadversions_XRef1.Resources_Books, Language_Animadversions_XRef1.Resources_Papers, Language_Animadversions_XRef1.Language AS [Called Language], Language_Animadversions.Language AS [Calling Language], Language_Animadversions_XRef1.Date_Last_Study, Language_Animadversions_XRef1.Time_This_Year, Language_Animadversions.ID, Language_Animadversions_XRef1.Date_Last_Study_NonLing, Language_Animadversions_XRef1.[50Lang_ID] FROM Language_Animadversions, Language_Animadversions_XRef1 WHERE (((Language_Animadversions.Language)<>[Language_Animadversions_XRef1]![Language]) AND ((InStr([Animadversion],[Language_Animadversions_XRef1]![Language]))>0));
Link To Column Definitions: Language_Animadversions_XRef2

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: Large_Page_List
Query_Type: Select
Query_DateCreated: 02/06/2021 21:07:14
Query_DateChanged: 03/06/2021 21:44:23
Query_SQL: SELECT Site_Map.Full_File_Name AS [File Name], Site_Map.Timestamp_Logged AS [Timestamp], Round([Size]/1024/1024,1) AS Mb, Page_Raw_Link_Counts.CountOfRaw_Link AS Links, "" AS [Note] FROM Site_Map INNER JOIN Page_Raw_Link_Counts ON (Site_Map.FIle_Name = Page_Raw_Link_Counts.File_Name) AND (Site_Map.Directory = Page_Raw_Link_Counts.Directory) ORDER BY Page_Raw_Link_Counts.CountOfRaw_Link DESC;
Link To Column Definitions: Large_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: Large_Page_List_Count
Query_Type: Select
Query_DateCreated: 03/06/2021 20:55:19
Query_DateChanged: 03/06/2021 20:55:19
Query_SQL: SELECT Count(Large_Page_List.[File Name]) AS [CountOfFile Name] FROM Large_Page_List;
Link To Column Definitions: Large_Page_List_Count

Tables / Queries Used By This QueryCode Using 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: Ling_Dialogue_Lesson_Counts
Query_Type: Select
Query_DateCreated: 13/04/2021 23:30:36
Query_DateChanged: 13/04/2021 23:49:21
Query_SQL: SELECT "Dialogue" AS Type, Ling_Dialogue_Language.Language, Count(Ling_Dialogue_Language.Lesson_ID) AS Lessons FROM Language_Location_Primer INNER JOIN Ling_Dialogue_Language ON Language_Location_Primer.Language_Key = Ling_Dialogue_Language.Language WHERE (((Ling_Dialogue_Language.Dialogue_ID)=1) AND ((Ling_Dialogue_Language.Phrase_ID)=1) AND ((Ling_Dialogue_Language.Phrase_Language)<>"")) GROUP BY "Dialogue", Ling_Dialogue_Language.Language ORDER BY "Dialogue", Ling_Dialogue_Language.Language;
Link To Column Definitions: Ling_Dialogue_Lesson_Counts

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


Query_Name: Ling_English_Categories
Query_Type: Select
Query_DateCreated: 19/08/2021 00:02:49
Query_DateChanged: 19/08/2021 00:02:49
Query_SQL: SELECT Ling_English_Category_Extras.Category, Count(Ling_English_Category_Extras.Vocab_English) AS CountOfVocab_English FROM Ling_English_Category_Extras GROUP BY Ling_English_Category_Extras.Category ORDER BY Ling_English_Category_Extras.Category;
Link To Column Definitions: Ling_English_Categories

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


Query_Name: Ling_English_Category_Categories
Query_Type: Select
Query_DateCreated: 14/07/2022 09:11:55
Query_DateChanged: 14/07/2022 09:12:33
Query_SQL: SELECT Ling_English_Category_Extras.Category FROM Ling_English_Category_Extras GROUP BY Ling_English_Category_Extras.Category;
Link To Column Definitions: Ling_English_Category_Categories

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


Query_Name: Ling_English_Category_Extras_Editable
Query_Type: Select
Query_DateCreated: 14/07/2022 09:08:27
Query_DateChanged: 14/07/2022 09:34:47
Query_SQL: SELECT Ling_English_Category_Extras.Category, Ling_English_Category_Extras.Vocab_English FROM Ling_English_Category_Extras WHERE (((Ling_English_Category_Extras.Category)="Unclassified")) ORDER BY Ling_English_Category_Extras.Vocab_English;
Link To Column Definitions: Ling_English_Category_Extras_Editable

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


Query_Name: Ling_Language_Dialogue_List_All_Prelist
Query_Type: Select
Query_DateCreated: 16/04/2021 23:23:24
Query_DateChanged: 16/04/2021 23:34:59
Query_SQL: SELECT Ling_Dialogue_English.Lesson_ID AS Lesson, Ling_Dialogue_English.Dialogue_ID AS Dialogue, Ling_Dialogue_English.Phrase_ID AS ID, Ling_Dialogue_English.[A/B], Ling_Dialogue_English.Phrase_English AS English, Ling_Dialogue_Language.Language, Ling_Dialogue_Language.Phrase_Language AS Phrase, Ling_Dialogue_Language.Phrase_Transliteration_Language AS Transliteration, Language_Location_Primer.Lang_Group, Language_Location_Primer.[Non_Latin_Script?] FROM ((Ling_Dialogue_Language INNER JOIN Ling_Dialogue_English ON (Ling_Dialogue_Language.Phrase_ID = Ling_Dialogue_English.Phrase_ID) AND (Ling_Dialogue_Language.Dialogue_ID = Ling_Dialogue_English.Dialogue_ID) AND (Ling_Dialogue_Language.Lesson_ID = Ling_Dialogue_English.Lesson_ID)) INNER JOIN Language_Location_Primer ON Ling_Dialogue_Language.Language = Language_Location_Primer.Language_Key) INNER JOIN Ling_Lessons ON Ling_Dialogue_English.Lesson_ID = Ling_Lessons.Lesson_ID WHERE (((Ling_Dialogue_Language.Phrase_Language)<>"")) ORDER BY Ling_Dialogue_English.Lesson_ID, Ling_Dialogue_English.Dialogue_ID, Ling_Dialogue_English.Phrase_ID, Ling_Dialogue_Language.Language;
Link To Column Definitions: Ling_Language_Dialogue_List_All_Prelist

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


Query_Name: Ling_Language_Dialogue_List_Latin
Query_Type: Select
Query_DateCreated: 14/04/2021 16:15:28
Query_DateChanged: 17/04/2021 23:15:34
Query_SQL: SELECT Ling_Dialogue_Language.Language, [Ling_Lessons]![Lesson_ID] AS Lesson, Ling_Dialogue_English.Dialogue_ID AS Dialogue, Ling_Dialogue_English.Phrase_ID AS ID, Ling_Dialogue_English.[A/B] AS Speaker, Ling_Dialogue_English.Phrase_English AS English, Ling_Dialogue_Language.Phrase_Language AS Phrase FROM ((Ling_Dialogue_English INNER JOIN Ling_Dialogue_Language ON (Ling_Dialogue_English.Phrase_ID = Ling_Dialogue_Language.Phrase_ID) AND (Ling_Dialogue_English.Dialogue_ID = Ling_Dialogue_Language.Dialogue_ID) AND (Ling_Dialogue_English.Lesson_ID = Ling_Dialogue_Language.Lesson_ID)) INNER JOIN Ling_Lessons ON Ling_Dialogue_English.Lesson_ID = Ling_Lessons.Lesson_ID) INNER JOIN Language_Location_Primer ON Ling_Dialogue_Language.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Dialogue_Language.Phrase_Language)<>"") AND ((Language_Location_Primer.[Non_Latin_Script?])=False)) ORDER BY Ling_Dialogue_Language.Language, Ling_Dialogue_English.Lesson_ID, Ling_Dialogue_English.Dialogue_ID, Ling_Dialogue_English.Phrase_ID;
Link To Column Definitions: Ling_Language_Dialogue_List_Latin

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


Query_Name: Ling_Language_Dialogue_List_NonLatin
Query_Type: Select
Query_DateCreated: 14/04/2021 16:04:30
Query_DateChanged: 01/07/2023 00:02:02
Query_SQL: SELECT Ling_Dialogue_Language.Language, [Ling_Lessons]![Lesson_ID] AS Lesson, Ling_Dialogue_English.Dialogue_ID AS Dialogue, Ling_Dialogue_English.Phrase_ID AS ID, Ling_Dialogue_English.[A/B] AS Speaker, Ling_Dialogue_English.Phrase_English AS English, Ling_Dialogue_Language.Phrase_Transliteration_Language AS [Phrase Transliteration], Ling_Dialogue_Language.Phrase_Language AS Phrase FROM ((Ling_Dialogue_English INNER JOIN Ling_Dialogue_Language ON (Ling_Dialogue_English.Phrase_ID = Ling_Dialogue_Language.Phrase_ID) AND (Ling_Dialogue_English.Dialogue_ID = Ling_Dialogue_Language.Dialogue_ID) AND (Ling_Dialogue_English.Lesson_ID = Ling_Dialogue_Language.Lesson_ID)) INNER JOIN Ling_Lessons ON Ling_Dialogue_English.Lesson_ID = Ling_Lessons.Lesson_ID) INNER JOIN Language_Location_Primer ON Ling_Dialogue_Language.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Dialogue_Language.Phrase_Language)<>"") AND ((Language_Location_Primer.[Non_Latin_Script?])=True)) ORDER BY Ling_Dialogue_Language.Language, Ling_Dialogue_English.Lesson_ID, Ling_Dialogue_English.Dialogue_ID, Ling_Dialogue_English.Phrase_ID;
Link To Column Definitions: Ling_Language_Dialogue_List_NonLatin

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


Query_Name: Ling_Language_Vocab_List_All_Prelist_1
Query_Type: Select
Query_DateCreated: 14/04/2021 19:31:33
Query_DateChanged: 27/08/2021 20:46:04
Query_SQL: SELECT [Ling_Vocabulary_English]![Lesson_ID] AS Lesson, Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],"") AS Sort, "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>" AS English, Ling_Vocabulary_Langauge.Language, Ling_Vocabulary_Langauge.Vocab_Language AS Vocabulary, Ling_Vocabulary_Langauge.Vocab_Transliteration_Language AS Transliteration, Language_Location_Primer.Lang_Group, Language_Location_Primer.[Non_Latin_Script?] FROM (((Ling_Lessons INNER JOIN Ling_Vocabulary_English ON Ling_Lessons.Lesson_ID = Ling_Vocabulary_English.Lesson_ID) INNER JOIN Ling_Vocabulary_Langauge ON (Ling_Vocabulary_English.Vocab_ID = Ling_Vocabulary_Langauge.Vocab_ID) AND (Ling_Vocabulary_English.Lesson_ID = Ling_Vocabulary_Langauge.Lesson_ID)) INNER JOIN Language_Location_Primer ON Ling_Vocabulary_Langauge.Language = Language_Location_Primer.Language_Key) LEFT JOIN Ling_English_Category_Extras ON Ling_Vocabulary_English.Vocab_English = Ling_English_Category_Extras.Vocab_English WHERE (((Ling_Vocabulary_Langauge.Vocab_Language)<>"")) ORDER BY Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],""), Ling_Vocabulary_Langauge.Language;
Link To Column Definitions: Ling_Language_Vocab_List_All_Prelist_1

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


Query_Name: Ling_Language_Vocab_List_All_Prelist_1_ru_uk
Query_Type: Select
Query_DateCreated: 28/03/2022 17:55:05
Query_DateChanged: 22/06/2023 18:07:04
Query_SQL: SELECT Ling_Language_Vocab_List_All_Prelist_1.* FROM Ling_Language_Vocab_List_All_Prelist_1 WHERE (((Ling_Language_Vocab_List_All_Prelist_1.Language)="Russian" Or (Ling_Language_Vocab_List_All_Prelist_1.Language)="Ukrainian" Or (Ling_Language_Vocab_List_All_Prelist_1.Language)="Polish"));
Link To Column Definitions: Ling_Language_Vocab_List_All_Prelist_1_ru_uk

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


Query_Name: Ling_Language_Vocab_List_All_Prelist_2
Query_Type: Select
Query_DateCreated: 03/06/2021 17:29:03
Query_DateChanged: 27/08/2021 20:46:19
Query_SQL: SELECT [Ling_Vocabulary_English]![Lesson_ID] AS Lesson, Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],"") AS Sort, "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>" AS English, "English" AS [Language], "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>" AS Vocabulary, "" AS Transliteration, Int([Language_Location_Primer]![Lang_Group]) & ".9" AS Lang_Group, False AS [Non_Latin_Script?] FROM Language_Location_Primer, Ling_Vocabulary_English INNER JOIN Ling_English_Category_Extras ON Ling_Vocabulary_English.Vocab_English = Ling_English_Category_Extras.Vocab_English GROUP BY [Ling_Vocabulary_English]![Lesson_ID], Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],""), "English", "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>", "", Int([Language_Location_Primer]![Lang_Group]) & ".9", False, "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>" HAVING (((Int([Language_Location_Primer]![Lang_Group]) & ".9")>1)) ORDER BY [Ling_Vocabulary_English]![Lesson_ID], Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],""), "English";
Link To Column Definitions: Ling_Language_Vocab_List_All_Prelist_2

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


Query_Name: Ling_Language_Vocab_List_Latin
Query_Type: Select
Query_DateCreated: 14/04/2021 15:22:22
Query_DateChanged: 14/04/2021 23:32:01
Query_SQL: SELECT Ling_Vocabulary_Langauge.Language, [Ling_Lessons]![Lesson_ID] AS Lesson, Ling_Vocabulary_English.Vocab_ID AS Item, Ling_Vocabulary_English.Vocab_English AS English, Ling_Vocabulary_Langauge.Vocab_Language AS Vocabulary, Ling_Vocabulary_English.Phrase_English AS [English Phrase], Ling_Vocabulary_Langauge.Phrase_Language AS Phrase FROM ((Ling_Lessons INNER JOIN Ling_Vocabulary_English ON Ling_Lessons.Lesson_ID = Ling_Vocabulary_English.Lesson_ID) INNER JOIN Ling_Vocabulary_Langauge ON (Ling_Vocabulary_English.Vocab_ID = Ling_Vocabulary_Langauge.Vocab_ID) AND (Ling_Vocabulary_English.Lesson_ID = Ling_Vocabulary_Langauge.Lesson_ID)) INNER JOIN Language_Location_Primer ON Ling_Vocabulary_Langauge.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Vocabulary_Langauge.Vocab_Language)<>"") AND ((Language_Location_Primer.[Non_Latin_Script?])=False)) ORDER BY Ling_Vocabulary_Langauge.Language, Ling_Vocabulary_English.Lesson_ID, Ling_Vocabulary_English.Vocab_ID;
Link To Column Definitions: Ling_Language_Vocab_List_Latin

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


Query_Name: Ling_Language_Vocab_List_NonLatin
Query_Type: Select
Query_DateCreated: 14/04/2021 00:59:22
Query_DateChanged: 30/06/2023 23:59:14
Query_SQL: SELECT Ling_Vocabulary_Langauge.Language, [Ling_Lessons]![Lesson_ID] AS Lesson, Ling_Vocabulary_English.Vocab_ID AS Item, Ling_Vocabulary_English.Vocab_English AS English, Ling_Vocabulary_Langauge.Vocab_Transliteration_Language AS [Vocabulary Transliteration], Ling_Vocabulary_English.Phrase_English AS [English Phrase], Ling_Vocabulary_Langauge.Phrase_Transliteration_Language AS [Phrase Transliteration], Ling_Vocabulary_Langauge.Vocab_Language AS Vocabulary, Ling_Vocabulary_Langauge.Phrase_Language AS Phrase FROM ((Ling_Lessons INNER JOIN Ling_Vocabulary_English ON Ling_Lessons.Lesson_ID = Ling_Vocabulary_English.Lesson_ID) INNER JOIN Ling_Vocabulary_Langauge ON (Ling_Vocabulary_English.Vocab_ID = Ling_Vocabulary_Langauge.Vocab_ID) AND (Ling_Vocabulary_English.Lesson_ID = Ling_Vocabulary_Langauge.Lesson_ID)) INNER JOIN Language_Location_Primer ON Ling_Vocabulary_Langauge.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Vocabulary_Langauge.Vocab_Language)<>"") AND ((Language_Location_Primer.[Non_Latin_Script?])=True)) ORDER BY Ling_Vocabulary_Langauge.Language, Ling_Vocabulary_English.Lesson_ID, Ling_Vocabulary_English.Vocab_ID;
Link To Column Definitions: Ling_Language_Vocab_List_NonLatin

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


Query_Name: Ling_Language_Vocab_Phrase_List_All_Prelist_1
Query_Type: Select
Query_DateCreated: 16/04/2021 21:39:17
Query_DateChanged: 27/08/2021 21:58:44
Query_SQL: SELECT [Ling_Vocabulary_English]![Lesson_ID] AS Lesson, Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],"") AS Sort, "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>" AS [English Vocabulary], "<b>" & [Phrase_English] & "</b>" AS [English Phrase], Ling_Vocabulary_Langauge.Language, Ling_Vocabulary_Langauge.Phrase_Language AS Phrase, Ling_Vocabulary_Langauge.Phrase_Transliteration_Language AS Transliteration, Language_Location_Primer.Lang_Group, Language_Location_Primer.[Non_Latin_Script?] FROM (((Ling_Lessons INNER JOIN Ling_Vocabulary_English ON Ling_Lessons.Lesson_ID = Ling_Vocabulary_English.Lesson_ID) INNER JOIN Ling_Vocabulary_Langauge ON (Ling_Vocabulary_English.Vocab_ID = Ling_Vocabulary_Langauge.Vocab_ID) AND (Ling_Vocabulary_English.Lesson_ID = Ling_Vocabulary_Langauge.Lesson_ID)) INNER JOIN Language_Location_Primer ON Ling_Vocabulary_Langauge.Language = Language_Location_Primer.Language_Key) LEFT JOIN Ling_English_Category_Extras ON Ling_Vocabulary_English.Vocab_English = Ling_English_Category_Extras.Vocab_English WHERE (((Ling_Vocabulary_Langauge.Phrase_Language)<>"")) ORDER BY [Ling_Vocabulary_English]![Lesson_ID], Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],""), Ling_Vocabulary_Langauge.Language;
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All_Prelist_1

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


Query_Name: Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk
Query_Type: Select
Query_DateCreated: 28/03/2022 14:29:19
Query_DateChanged: 22/06/2023 18:06:35
Query_SQL: SELECT Ling_Language_Vocab_Phrase_List_All_Prelist_1.* FROM Ling_Language_Vocab_Phrase_List_All_Prelist_1 WHERE (((Ling_Language_Vocab_Phrase_List_All_Prelist_1.Language)="Ukrainian" Or (Ling_Language_Vocab_Phrase_List_All_Prelist_1.Language)="Russian" Or (Ling_Language_Vocab_Phrase_List_All_Prelist_1.Language)="Polish"));
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk

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


Query_Name: Ling_Language_Vocab_Phrase_List_All_Prelist_2
Query_Type: Select
Query_DateCreated: 03/06/2021 18:13:13
Query_DateChanged: 27/08/2021 21:59:39
Query_SQL: SELECT [Ling_Vocabulary_English]![Lesson_ID] AS Lesson, Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],"") AS Sort, "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>" AS [English Vocabulary], "<b>" & [Ling_Vocabulary_English]![Phrase_English] & "</b>" AS [English Phrase], "English Phrase" AS [Language], "<b>" & [Phrase_English] & "</b>" AS Phrase, [Ling_Vocabulary_English]![Vocab_English] AS Transliteration, Int([Language_Location_Primer]![Lang_Group]) & ".9" AS Lang_Group, False AS [Non_Latin_Script?] FROM Language_Location_Primer, Ling_Vocabulary_English INNER JOIN Ling_English_Category_Extras ON Ling_Vocabulary_English.Vocab_English = Ling_English_Category_Extras.Vocab_English GROUP BY [Ling_Vocabulary_English]![Lesson_ID], Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],""), "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>", "<b>" & [Ling_Vocabulary_English]![Phrase_English] & "</b>", "English Phrase", "<b>" & [Phrase_English] & "</b>", [Ling_Vocabulary_English]![Vocab_English], Int([Language_Location_Primer]![Lang_Group]) & ".9", False, "<b>" & [Ling_Vocabulary_English]![Vocab_English] & "</b>" HAVING (((Int([Language_Location_Primer]![Lang_Group]) & ".9")>1)) ORDER BY [Ling_Vocabulary_English]![Lesson_ID], Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, IIf(Left([Ling_Vocabulary_English]![Vocab_English],2)="a ",Mid([Ling_Vocabulary_English]![Vocab_English],3),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="an ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(Left([Ling_Vocabulary_English]![Vocab_English],3)="to ",Mid([Ling_Vocabulary_English]![Vocab_English],4),"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")=0,[Ling_Vocabulary_English]![Vocab_English],"") & IIf(InStr([Ling_Vocabulary_English]![Vocab_English]," ")>3,[Ling_Vocabulary_English]![Vocab_English],""), "English Phrase";
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All_Prelist_2

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


Query_Name: Ling_Progress
Query_Type: Select
Query_DateCreated: 18/04/2021 14:10:58
Query_DateChanged: 25/08/2021 12:53:49
Query_SQL: SELECT Language_Location_Primer.Priority, Language_Location_Primer.Ling_Progress, Language_Location_Primer.Language_Key, Language_Location_Primer.Ling_Revision_Progress FROM Language_Location_Primer WHERE (((Language_Location_Primer.Ling_Progress)>0)) ORDER BY Language_Location_Primer.Priority, Language_Location_Primer.Ling_Progress, Language_Location_Primer.Ling_Revision_Progress, Language_Location_Primer.Language_Key;
Link To Column Definitions: Ling_Progress

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


Query_Name: Ling_Vocab_Categorised_List
Query_Type: Select
Query_DateCreated: 01/07/2023 00:19:54
Query_DateChanged: 01/07/2023 00:19:54
Query_SQL: SELECT Ling_Vocabulary_English.Lesson_ID, Ling_Vocabulary_English.Vocab_ID, Ling_English_Category_Extras.Category, Ling_Vocabulary_English.Vocab_English, Ling_Vocabulary_Langauge.Language, Ling_Vocabulary_Langauge.Vocab_Language, Ling_Vocabulary_Langauge.Vocab_Transliteration_Language FROM (Ling_Vocabulary_English INNER JOIN Ling_English_Category_Extras ON Ling_Vocabulary_English.Vocab_English = Ling_English_Category_Extras.Vocab_English) INNER JOIN Ling_Vocabulary_Langauge ON (Ling_Vocabulary_English.Vocab_ID = Ling_Vocabulary_Langauge.Vocab_ID) AND (Ling_Vocabulary_English.Lesson_ID = Ling_Vocabulary_Langauge.Lesson_ID) ORDER BY Ling_English_Category_Extras.Category, Ling_Vocabulary_English.Vocab_English, Ling_Vocabulary_Langauge.Language;
Link To Column Definitions: Ling_Vocab_Categorised_List

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


Query_Name: Ling_Vocab_Lesson_Counts
Query_Type: Select
Query_DateCreated: 13/04/2021 23:29:51
Query_DateChanged: 13/04/2021 23:43:08
Query_SQL: SELECT "Vocabulary" AS Type, Ling_Vocabulary_Langauge.Language, Count(Ling_Vocabulary_Langauge.Lesson_ID) AS Lessons FROM Ling_Vocabulary_Langauge INNER JOIN Language_Location_Primer ON Ling_Vocabulary_Langauge.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Vocabulary_Langauge.Vocab_ID)=1) AND ((Ling_Vocabulary_Langauge.Vocab_Language)<>"")) GROUP BY "Vocabulary", Ling_Vocabulary_Langauge.Language ORDER BY "Vocabulary", Ling_Vocabulary_Langauge.Language;
Link To Column Definitions: Ling_Vocab_Lesson_Counts

Tables / Queries Used By This QueryQueries 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: Missing_Webref_DisplayText_List
Query_Type: Select
Query_DateCreated: 17/06/2021 10:32:55
Query_DateChanged: 15/07/2021 16:19:25
Query_SQL: SELECT "+P" & [Papers]![ID] & "P+" AS Paper, Webrefs_Table.ID, "+W" & [Webrefs_Table!ID] & "W+" AS Webrefs, IIf([Write_Up_Note_ID] & ""="","","Note++" & [Write_Up_Note_ID] & "++") AS [Write Up Note] FROM (Cross_Reference INNER JOIN (Papers INNER JOIN PID_Note_Reading_Lists ON Papers.ID = PID_Note_Reading_Lists.Called_ID) ON Cross_Reference.Calling_ID = Papers.ID) INNER JOIN Webrefs_Table ON Cross_Reference.Called_ID = Webrefs_Table.ID WHERE (((PID_Note_Reading_Lists.[Book/Paper])="Paper") AND ((Cross_Reference.Called_Type)="W") AND ((Cross_Reference.Calling_Type)="P") AND (([Display_Text] & "")="")) OR (((PID_Note_Reading_Lists.[Book/Paper])="Paper") AND ((Cross_Reference.Called_Type)="W") AND ((Cross_Reference.Calling_Type)="P") AND ((Webrefs_Table.[Defunct?])=True)) GROUP BY "+P" & [Papers]![ID] & "P+", Webrefs_Table.ID, "+W" & [Webrefs_Table!ID] & "W+", IIf([Write_Up_Note_ID] & ""="","","Note++" & [Write_Up_Note_ID] & "++"), Webrefs_Table.[Defunct?], Papers.Author, Papers.Title, Webrefs_Table.ID ORDER BY Webrefs_Table.[Defunct?] DESC , Papers.Author, Papers.Title, Webrefs_Table.ID;
Link To Column Definitions: Missing_Webref_DisplayText_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: Missing_Webref_DisplayText_List_Books
Query_Type: Select
Query_DateCreated: 30/07/2021 21:15:52
Query_DateChanged: 30/07/2021 21:19:56
Query_SQL: SELECT "+B" & [ID1] & "B+" AS Book, Webrefs_Table.ID, "+W" & [Webrefs_Table!ID] & "W+" AS Webrefs FROM (Books INNER JOIN (Cross_Reference INNER JOIN Webrefs_Table ON Cross_Reference.Called_ID = Webrefs_Table.ID) ON Books.ID1 = Cross_Reference.Calling_ID) INNER JOIN PID_Note_Reading_Lists ON Books.ID1 = PID_Note_Reading_Lists.Called_ID WHERE (((PID_Note_Reading_Lists.[Book/Paper])="Book") AND ((Cross_Reference.Called_Type)="W") AND ((Cross_Reference.Calling_Type)="B") AND (([Display_Text] & "")="")) OR (((PID_Note_Reading_Lists.[Book/Paper])="Book") AND ((Cross_Reference.Called_Type)="W") AND ((Cross_Reference.Calling_Type)="B") AND ((Webrefs_Table.[Defunct?])=True)) GROUP BY "+B" & [ID1] & "B+", Webrefs_Table.ID, "+W" & [Webrefs_Table!ID] & "W+", Webrefs_Table.[Defunct?], Books.Author, Books.Title, Webrefs_Table.ID ORDER BY Webrefs_Table.[Defunct?] DESC , Books.Author, Books.Title, Webrefs_Table.ID;
Link To Column Definitions: Missing_Webref_DisplayText_List_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: Missing_Webref_DisplayText_List_Books_Count
Query_Type: Select
Query_DateCreated: 30/07/2021 21:21:19
Query_DateChanged: 30/07/2021 21:22:53
Query_SQL: SELECT Count(Missing_Webref_DisplayText_List_Books.ID) AS CountOfID FROM Missing_Webref_DisplayText_List_Books;
Link To Column Definitions: Missing_Webref_DisplayText_List_Books_Count

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


Query_Name: Missing_Webref_DisplayText_List_Count
Query_Type: Select
Query_DateCreated: 17/06/2021 13:01:18
Query_DateChanged: 17/06/2021 13:01:18
Query_SQL: SELECT Count(Missing_Webref_DisplayText_List.ID) AS CountOfID FROM Missing_Webref_DisplayText_List;
Link To Column Definitions: Missing_Webref_DisplayText_List_Count

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


Query_Name: Missing_Webref_DisplayText_List_Editable_List
Query_Type: Select
Query_DateCreated: 28/10/2021 18:06:58
Query_DateChanged: 29/10/2021 21:33:45
Query_SQL: SELECT Webrefs_Table.[Defunct?], Papers.Author, Papers.Title, Webrefs_Table.Display_Text, Papers.Comments, Webrefs_Table.Webref, Webrefs_Table.Date_Created, Webrefs_Table.Date_Last_Checked, Webrefs_Table.Alt_Ref, Webrefs_Table.Issue, Webrefs_Table.Tries, Webrefs_Table.Check_Time, Webrefs_Table.WebRef_Kernel, Webrefs_Table.Defunct_Explanation FROM (Missing_Webref_DisplayText_List_Editable INNER JOIN Webrefs_Table ON Missing_Webref_DisplayText_List_Editable.WebRef_ID = Webrefs_Table.ID) INNER JOIN Papers ON Missing_Webref_DisplayText_List_Editable.Paper_ID = Papers.ID ORDER BY Webrefs_Table.[Defunct?] DESC , Papers.Author, Papers.Title;
Link To Column Definitions: Missing_Webref_DisplayText_List_Editable_List

Tables / Queries Used By 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: NGS_Latest_Import
Query_Type: Select
Query_DateCreated: 08/03/2023 21:04:42
Query_DateChanged: 08/03/2023 21:21:27
Query_SQL: SELECT Max(NGS_History.Date_Following) AS MaxOfDate_Following FROM NGS_History;
Link To Column Definitions: NGS_Latest_Import

Tables / Queries Used By This QueryCode 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: 06/02/2022 12:45:21
Query_SQL: SELECT Note_Book_Links_Prelim.Author, Note_Book_Links_Prelim.Title, IIf([MinOfCalling_Timestamp]=0,[BooksToNoteLink],".") AS [Current Note], IIf([MinOfCalling_Timestamp]>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: 06/02/2022 12:42:43
Query_SQL: SELECT Books.Author, Books.Title, Books.ID1, Min(Cross_Reference.Calling_Timestamp) AS MinOfCalling_Timestamp, Max(Cross_Reference.Calling_Timestamp) AS MaxOfCalling_Timestamp FROM Books INNER JOIN Cross_Reference ON Books.ID1 = Cross_Reference.Called_ID WHERE (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="B")) 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: 05/02/2022 21:11:47
Query_SQL: SELECT Note_Paper_Links_Prelim.Author, Note_Paper_Links_Prelim.Title, IIf([MinOfCalling_Timestamp]=0,[PapersToNoteLink],".") AS [Current Note], IIf([MinOfCalling_Timestamp]>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: 05/02/2022 21:01:30
Query_SQL: SELECT Papers.Author, Papers.Title, Papers.ID, Min(Cross_Reference.Calling_Timestamp) AS MinOfCalling_Timestamp, Max(Cross_Reference.Calling_Timestamp) AS MaxOfCalling_Timestamp FROM Papers INNER JOIN Cross_Reference ON Papers.ID = Cross_Reference.Called_ID WHERE (((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="P")) 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_Snippet_Lookup
Query_Type: Select
Query_DateCreated: 12/05/2022 11:11:24
Query_DateChanged: 07/10/2022 12:32:58
Query_SQL: SELECT "Snippet" AS Snippet, Note_Snippets.PID_Note_Title, Note_Snippets.PID_Note_ID, Note_Snippets.ID AS Snippet_ID, Note_Snippets.Note_Snippet FROM Note_Snippets WHERE (((Note_Snippets.PID_Note_Title) Like "*" & [Enter Snippet Title String] & "*"));
Link To Column Definitions: Note_Snippet_Lookup

Tables / Queries Used By This QueryCode Using this Query