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 = Append (104 items)

Abstracts_Archive_AddAbstracts_ChangedActual_Hours_Temp_GENAdd_To_Philosophers_Index_Converted
Add_To_Philosophers_Index_UnconvertedAeon_New_Items_AddAuthor_Surnames_GenAuthors_Add
Authors_Cited_By_All_List_GenAuthors_List_Authors_Table_GENAuthors_List_Letter_Table_AddAuthors_List_Letter_Table_GEN
Authors_Summary_Temp_Count_Gen_BooksAuthors_Summary_Temp_Count_Gen_CitationsAuthors_Summary_Temp_Count_Gen_PapersAuthors_Summary_Temp_Count_Gen2
Authors_Summary_Temp_GenAuthors_Summary_Temp_Gen2Averages_GeneratorBackup_Directory_Structure_Add
Backup_Directory_Structure_Zapper_GENBackup_Site_Map_AddBackup_Site_Map_Zapper_DirectoryGone_GENBackup_Site_Map_Zapper_GEN
Book_Abstracts_Archive_AddBook_Abstracts_ChangedBook_Citings_List_New_GenBook_Location_Stats_Temp_GEN
Book_Paper_Solitons_GENBook_Paper_Solitons_Zapper_GenBook_Papers_Full_GENBook_Range_GEN
Book_Summary_GENBook_Summary_Temp_GENBook_Summary_Temp_GEN_AllBookPaperAbstracts_List_Gen
Books - All - Categorised_Table_GENBooks_Locations_Table_GENBooks_Versus_Papers_AddCross_Reference_Additions
Cross_Reference_DeletionsCurrent_Year_Papers_Actuals_AddDirectory_Structure_AddFunctor_Descriptions_GEN
Hits_Bots_Total_GENHits_Pages_Total_GENMaintainable_Archived_Objects_GENMaintainable_Objects_GEN
Missing_PI_PINew_Year_Crosstab_Prime_NewYear_ADDNew_Year_Crosstab_Prime_OldYear_ADDNote_Alternates_Add
Note_Book_Link_Latest_AddNote_Book_Link_Latest_Add1Note_Paper_Link_Latest_AddNote_Paper_Link_Latest_Add1
Note_Usage_Temp_Zapper_GENNote_Usage_Temp_Zapper_GEN2Notes_Archive_GENNotes_Cited_By_All_List_Gen
Notes_to_Print_AddOboe_Latest_Lesson_GENOboe_Practice_Hours_ADDOboe_Practice_Hours_Temp_Dated_GEN
Oboe_Practice_Hours_Temp_Dated_LastYear_GENOboe_Practice_Hours_Temp_GENPage_Regen_GENPaper_Books_GEN
Paper_Citings_List_New_GenPaper_Summary_GENPaper_Summary_Temp_GENPaper_Summary_Temp_GEN_All
Paper_Summary_Temp_GEN_NewPaper_Summary_Temp_GEN_QualityPapers - All - Categorised - Sub_Table_GENPhilosophy Papers - All - Categorised (Titles) - Solitons_GEN
Philosophy Papers - All - Categorised (Titles) - Top_Table_GENPhilosophy Papers - All - Categorised (Titles)_Table_GENPhilosophy Papers - All - Categorised_Table_GENPhoto_Raw_Excluded_Link_KeysQ
Photo_Raw_Non_Excluded_TripletsPhoto_Type_Goup_Mismatch_GenProject_Plans_NextYear_AddQuery_Definitions_Archive
Query1Raw_Broken_Links_Old_UpdtRaw_Links_AddRaw_Links_Zapper_GEN
Site_Map_AddSpider_Missing_Internal_Links_AddSpider_Weblinks_AddTime_By_Weekday_Prelist_GEN
Time_This_Month_List_GenTime_This_Month_List_Temp_GenTime_This_Month_List_YTD_GenTime_This_Month_New_GEN
Timesheet_Time_Outstanding_GENWebrefs_AddYear_Crosstab_AddYear_Crosstab_GEN
Year_Crosstab_List_AddYear_Crosstab_List_GENYear_Crosstab_Old_GENYear_Crosstab_Prime_Add

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

Go to top of page

Query_Name: Abstracts_Archive_Add
Query_Type: Append
Query_DateCreated: 17/05/2007 20:47:40
Query_DateChanged: 19/05/2007 14:42:22
Query_SQL: INSERT INTO Abstracts_Archive ( ID, Author, Title, Comments, Abstract, [Timestamp] ) SELECT Abstracts_Archive_Temp.ID, Abstracts_Archive_Temp.Author, Abstracts_Archive_Temp.Title, Abstracts_Archive_Temp.Comments, Abstracts_Archive_Temp.Abstract, Abstracts_Archive_Temp.Timestamp FROM Abstracts_Archive RIGHT JOIN Abstracts_Archive_Temp ON Abstracts_Archive.ID = Abstracts_Archive_Temp.ID;
Link To Column Definitions: Abstracts_Archive_Add

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
Query_Type: Append
Query_DateCreated: 17/05/2007 20:41:55
Query_DateChanged: 19/05/2007 14:38:44
Query_SQL: INSERT INTO Abstracts_Archive_Temp ( ID, Author, Title, Comments, Abstract, [Timestamp] ) SELECT Papers.ID, Papers.Author, Papers.Title, Papers.Comments, Papers.Abstract, Now() AS [Timestamp] 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.ID;
Link To Column Definitions: Abstracts_Changed

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


Query_Name: Actual_Hours_Temp_GEN
Query_Type: Append
Query_DateCreated: 15/07/2013 22:11:20
Query_DateChanged: 15/07/2013 22:11:25
Query_SQL: INSERT INTO Actual_Hours_Temp ( ID, [Actual Hours] ) SELECT Subject_Plan.ID, Subject_Plan.[Actual Hours] FROM Subject_Plan WHERE (((Subject_Plan.[Actual Hours])>0));
Link To Column Definitions: Actual_Hours_Temp_GEN

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


Query_Name: Add_To_Philosophers_Index_Converted
Query_Type: Append
Query_DateCreated: 20/06/2006 10:12:43
Query_DateChanged: 29/06/2006 09:04:25
Query_SQL: INSERT INTO Philosophers_Index ( Category, TI, AU, SO, JN, DE, LA, DT, AN, PS, [IS], PB, AB, PY, IB, RV, UD ) SELECT "General" AS Category, Change_Case([TI]) AS TI1, Change_Case([AU]) AS AU1, Change_Case_Name([SO]) AS SO1, Change_Case_Name([JN]) AS JN1, Change_Case_Name([DE]) AS DE1, Change_Case_Name([LA]) AS LA1, Change_Case_Name([DT]) AS DT1, Philosophers_Index_Load.AN, Change_Case_Name([PS]) AS PS1, Philosophers_Index_Load.[IS], Change_Case([PB]) AS PB1, Change_Case([AB]) AS AB1, Change_Case_Name([PY]) AS PY1, [Philosophers_Index_Load].[IB] AS IB1, [Philosophers_Index_Load].[RV] AS RV1, Change_Case_Name([UD]) AS UD1 FROM Philosophers_Index_Load;
Link To Column Definitions: Add_To_Philosophers_Index_Converted

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


Query_Name: Add_To_Philosophers_Index_Unconverted
Query_Type: Append
Query_DateCreated: 19/06/2006 16:30:31
Query_DateChanged: 19/06/2006 23:34:51
Query_SQL: INSERT INTO Philosophers_Index ( Category, TI, AU, SO, JN, DE, LA, DT, AN, PS, [IS], PB, AB, PY, IB, RV ) SELECT "General" AS Category, Philosophers_Index_Load.TI, Philosophers_Index_Load.AU, Philosophers_Index_Load.SO, Philosophers_Index_Load.JN, Philosophers_Index_Load.DE, Philosophers_Index_Load.LA, Philosophers_Index_Load.DT, Philosophers_Index_Load.AN, Philosophers_Index_Load.PS, Philosophers_Index_Load.[IS], Philosophers_Index_Load.PB, Philosophers_Index_Load.AB, Philosophers_Index_Load.PY, Philosophers_Index_Load.IB, Philosophers_Index_Load.RV FROM Philosophers_Index_Load;
Link To Column Definitions: Add_To_Philosophers_Index_Unconverted

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


Query_Name: Aeon_New_Items_Add
Query_Type: Append
Query_DateCreated: 27/11/2019 19:51:13
Query_DateChanged: 30/11/2019 14:43:16
Query_SQL: INSERT INTO Aeon_Files ( WebRef_ID, Date_Created, Author_Names, Aeon_Title, [Video?], Priority ) SELECT Webrefs_Table.ID, Webrefs_Table.Date_Created, Mid([Display_Text],7,InStr([Display_Text]," - ")-7) AS Expr4, Mid([Display_Text],InStr([Display_Text]," - ")+3) AS Expr3, IIf(InStr([Display_Text],"video")>0,True,False) AS Expr1, 0 AS Priority FROM Webrefs_Table LEFT JOIN Aeon_Files ON Webrefs_Table.ID = Aeon_Files.WebRef_ID WHERE (((Left([Display_Text],6))="Aeon: ") AND ((Webrefs_Table.[Defunct?])=False) AND ((Aeon_Files.WebRef_ID) Is Null));
Link To Column Definitions: Aeon_New_Items_Add

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


Query_Name: Author_Surnames_Gen
Query_Type: Append
Query_DateCreated: 10/04/2020 00:00:55
Query_DateChanged: 10/04/2020 00:00:55
Query_SQL: INSERT INTO Author_Surnames ( Author_Surname, Synonym_Count ) SELECT Authors_Summary_Temp.Author_Surname, Count(Authors_Summary_Temp.Author_ID) AS Synonym_Count FROM Authors_Summary_Temp GROUP BY Authors_Summary_Temp.Author_Surname;
Link To Column Definitions: Author_Surnames_Gen

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


Query_Name: Authors_Add
Query_Type: Append
Query_DateCreated: 26/08/2015 17:44:34
Query_DateChanged: 26/08/2015 17:45:17
Query_SQL: INSERT INTO Authors ( Author_Name ) SELECT Authors_List_Authors_Table.Author_Name FROM Authors_List_Authors_Table LEFT JOIN Authors ON Authors_List_Authors_Table.Author_Name = Authors.Author_Name WHERE (((Authors.Author_Name) Is Null));
Link To Column Definitions: Authors_Add

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_All_List_Gen
Query_Type: Append
Query_DateCreated: 13/04/2020 15:13:00
Query_DateChanged: 13/04/2020 15:13:50
Query_SQL: INSERT INTO Authors_Cited_By_All_List ( Author, Title, Medium, Display_Text, Icon, [Read?], Calling_ID, Calling_NameRef, Author_ID ) SELECT Authors_Cited_By_All_List_Query.Author, Authors_Cited_By_All_List_Query.Title, Authors_Cited_By_All_List_Query.Medium, Authors_Cited_By_All_List_Query.Display_Text, Authors_Cited_By_All_List_Query.Icon, Authors_Cited_By_All_List_Query.[Read?], Authors_Cited_By_All_List_Query.Calling_ID, Authors_Cited_By_All_List_Query.Calling_NameRef, Authors_Cited_By_All_List_Query.Author_ID FROM Authors_Cited_By_All_List_Query;
Link To Column Definitions: Authors_Cited_By_All_List_Gen

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_Authors_Table_GEN
Query_Type: Append
Query_DateCreated: 13/05/2014 22:43:32
Query_DateChanged: 13/05/2014 22:45:52
Query_SQL: INSERT INTO Authors_List_Authors_Table ( Author_Name ) SELECT Authors_List1.Author_Name FROM Authors_List1 GROUP BY Authors_List1.Author_Name ORDER BY Authors_List1.Author_Name;
Link To Column Definitions: Authors_List_Authors_Table_GEN

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_Table_Add
Query_Type: Append
Query_DateCreated: 11/01/2020 20:17:09
Query_DateChanged: 11/01/2020 20:17:09
Query_SQL: INSERT INTO Authors_List_Letter_Table ( Author_Name ) SELECT Authors.Author_Name FROM Authors LEFT JOIN Authors_List_Letter_Table ON Authors.Author_Name = Authors_List_Letter_Table.Author_Name WHERE (((Authors_List_Letter_Table.Author_Name) Is Null));
Link To Column Definitions: Authors_List_Letter_Table_Add

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_Table_GEN
Query_Type: Append
Query_DateCreated: 13/05/2014 20:19:09
Query_DateChanged: 11/01/2020 20:18:11
Query_SQL: INSERT INTO Authors_List_Letter_Table ( Author_Name, Author, Title, Pages, [Read?], [Further Information], Book_ID, Medium ) SELECT Authors_List2.Author_Name, Authors_List2.Author, Authors_List2.Title, Authors_List2.Pages, Authors_List2.[Read?], Authors_List2.[Further Information], Authors_List2.Book_ID, Authors_List2.Medium FROM Authors_List2 INNER JOIN Author_Letters ON Authors_List2.Authors_List_Initial = Author_Letters.Author_Letter WHERE (((Author_Letters.[Select?])=True)) GROUP BY Authors_List2.Author_Name, Authors_List2.Author, Authors_List2.Title, Authors_List2.Pages, Authors_List2.[Read?], Authors_List2.[Further Information], Authors_List2.Book_ID, Authors_List2.Medium ORDER BY Authors_List2.Author_Name, Authors_List2.Title, Authors_List2.Pages, Authors_List2.Medium;
Link To Column Definitions: Authors_List_Letter_Table_GEN

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_Temp_Count_Gen_Books
Query_Type: Append
Query_DateCreated: 10/04/2020 23:29:18
Query_DateChanged: 10/04/2020 23:31:57
Query_SQL: INSERT INTO Authors_Summary_Temp_Count ( Author, [Count] ) SELECT Authors_List_Letter_Table.Author_Name, Count(Authors_List_Letter_Table.Book_ID) AS CountOfBook_ID FROM Authors_List_Letter_Table WHERE (((Authors_List_Letter_Table.Medium)="Book")) GROUP BY Authors_List_Letter_Table.Author_Name;
Link To Column Definitions: Authors_Summary_Temp_Count_Gen_Books

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_Temp_Count_Gen_Citations
Query_Type: Append
Query_DateCreated: 10/04/2020 21:17:40
Query_DateChanged: 10/04/2020 21:21:31
Query_SQL: INSERT INTO Authors_Summary_Temp_Count ( Author, [Count] ) SELECT Author_Citation_Counts.Author, Author_Citation_Counts.Citations AS [Count] FROM Author_Citation_Counts;
Link To Column Definitions: Authors_Summary_Temp_Count_Gen_Citations

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_Temp_Count_Gen_Papers
Query_Type: Append
Query_DateCreated: 10/04/2020 23:32:38
Query_DateChanged: 10/04/2020 23:32:50
Query_SQL: INSERT INTO Authors_Summary_Temp_Count ( Author, [Count] ) SELECT Authors_List_Letter_Table.Author_Name, Count(Authors_List_Letter_Table.Book_ID) AS CountOfBook_ID FROM Authors_List_Letter_Table WHERE (((Authors_List_Letter_Table.Medium)="Paper")) GROUP BY Authors_List_Letter_Table.Author_Name;
Link To Column Definitions: Authors_Summary_Temp_Count_Gen_Papers

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_Temp_Count_Gen2
Query_Type: Append
Query_DateCreated: 10/04/2020 21:18:33
Query_DateChanged: 10/04/2020 23:59:30
Query_SQL: INSERT INTO Authors_Summary_Temp ( Author_ID, Author, [Author's Abstract?], [Book Count], [Paper Count], [Citation Count] ) SELECT Authors.Author_ID, Authors.Author_Name AS Author, IIf([Authors]![Author_Narrative] & ""="","&nbsp;","Yes") AS [Author's Abstract?], IIf([Book] & ""="",0,[Book]) AS [Book Count], IIf([Paper] & ""="",0,[Paper]) AS [Paper Count], IIf([Citations] & ""="",0,[Citations]) AS [Citation Count] FROM (Authors LEFT JOIN Authors_Summary_Counts ON Authors.Author_Name = Authors_Summary_Counts.Author_Name) LEFT JOIN Author_Citation_Counts ON Authors.Author_Name = Author_Citation_Counts.Author;
Link To Column Definitions: Authors_Summary_Temp_Count_Gen2

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


Query_Name: Authors_Summary_Temp_Gen
Query_Type: Append
Query_DateCreated: 09/04/2020 21:51:56
Query_DateChanged: 10/04/2020 21:15:15
Query_SQL: INSERT INTO Authors_Summary_Temp ( Author_ID, Author, [Author's Abstract?], [Book Count], [Paper Count], [Citation Count], [Synonym Count] ) SELECT Authors.Author_ID, Authors.Author_Name AS Author, IIf([Authors]![Author_Narrative] & ""="","&nbsp;","Yes") AS [Author's Abstract?], 0 AS Expr1, 0 AS Expr2, 0 AS Expr3, 1 AS Expr4 FROM Authors;
Link To Column Definitions: Authors_Summary_Temp_Gen

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_Temp_Gen2
Query_Type: Append
Query_DateCreated: 10/04/2020 21:12:48
Query_DateChanged: 10/04/2020 21:12:48
Query_SQL: INSERT INTO Authors_Summary_Temp ( Author_ID, Author, [Author's Abstract?], [Book Count], [Paper Count], [Citation Count] ) SELECT Authors.Author_ID, Authors.Author_Name AS Author, IIf([Authors]![Author_Narrative] & ""="","&nbsp;","Yes") AS [Author's Abstract?], IIf([Book] & ""="",0,[Book]) AS [Book Count], IIf([Paper] & ""="",0,[Paper]) AS [Paper Count], IIf([Citations] & ""="",0,[Citations]) AS [Citation Count] FROM (Authors LEFT JOIN Authors_Summary_Counts ON Authors.Author_Name = Authors_Summary_Counts.Author_Name) LEFT JOIN Author_Citation_Counts ON Authors.Author_Name = Author_Citation_Counts.Author;
Link To Column Definitions: Authors_Summary_Temp_Gen2

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


Query_Name: Averages_Generator
Query_Type: Append
Query_DateCreated: 21/06/2013 18:54:32
Query_DateChanged: 14/01/2014 12:45:57
Query_SQL: INSERT INTO Player_Stats ( Club, [Year], Player, Sessions, [Average %age], [Total LPs] ) SELECT Results.Club, Year([Session_Date]) AS [Year], IIf([Duplicate?]=No,[Full_Name],[Alternate_Full_Name]) AS Player, Count(Results.Session_Date) AS Sessions, Avg(Results.Percentage_Score) AS [Average %age], Sum(Results.LPs) AS [Total LPs] FROM Results INNER JOIN Joint_Project_Members ON Results.Player = Joint_Project_Members.Full_Name GROUP BY Results.Club, Year([Session_Date]), IIf([Duplicate?]=No,[Full_Name],[Alternate_Full_Name]);
Link To Column Definitions: Averages_Generator

Go To Top of This Page
Link to VBA Code Control Page


Query_Name: Backup_Directory_Structure_Add
Query_Type: Append
Query_DateCreated: 16/05/2014 19:40:14
Query_DateChanged: 07/06/2014 10:15:43
Query_SQL: INSERT INTO Backup_Directory_Structure SELECT Backup_Directory_Structure_Temp.* FROM Backup_Directory_Structure_Temp LEFT JOIN Backup_Directory_Structure ON Backup_Directory_Structure_Temp.Directory = Backup_Directory_Structure.Directory WHERE (((Backup_Directory_Structure.Directory) Is Null));
Link To Column Definitions: Backup_Directory_Structure_Add

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


Query_Name: Backup_Directory_Structure_Zapper_GEN
Query_Type: Append
Query_DateCreated: 17/05/2014 22:37:05
Query_DateChanged: 07/06/2014 10:16:20
Query_SQL: INSERT INTO Backup_Directory_Structure_Zapper ( Directory ) SELECT Backup_Directory_Structure.Directory FROM (Backup_Directory_Structure LEFT JOIN Backup_Directory_Structure_Temp ON Backup_Directory_Structure.Directory = Backup_Directory_Structure_Temp.Directory) INNER JOIN Backup_Directory_Structure_List ON Backup_Directory_Structure.Directory = Backup_Directory_Structure_List.Directory WHERE (((Backup_Directory_Structure.Directory)<>[Input_Root]) AND ((Backup_Directory_Structure_Temp.Directory) Is Null) AND ((Backup_Directory_Structure.Directory_Level)>0) AND ((Left([Backup_Directory_Structure]![Directory],Len([Input_Root])))=[Input_Root]));
Link To Column Definitions: Backup_Directory_Structure_Zapper_GEN

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_Add
Query_Type: Append
Query_DateCreated: 16/05/2014 19:45:32
Query_DateChanged: 23/05/2014 18:17:27
Query_SQL: INSERT INTO Backup_Site_Map SELECT Backup_Site_Map_Temp.* FROM Backup_Site_Map_Temp LEFT JOIN Backup_Site_Map ON (Backup_Site_Map_Temp.Directory = Backup_Site_Map.Directory) AND (Backup_Site_Map_Temp.FIle_Name = Backup_Site_Map.FIle_Name) WHERE (((Backup_Site_Map.Directory) Is Null));
Link To Column Definitions: Backup_Site_Map_Add

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_Zapper_DirectoryGone_GEN
Query_Type: Append
Query_DateCreated: 19/05/2014 16:31:01
Query_DateChanged: 23/05/2014 18:21:58
Query_SQL: INSERT INTO Backup_Site_Map_Zapper ( Directory, FIle_Name ) SELECT Backup_Site_Map.Directory, Backup_Site_Map.FIle_Name FROM Backup_Directory_Structure_List RIGHT JOIN Backup_Site_Map ON Backup_Directory_Structure_List.Directory = Backup_Site_Map.Directory WHERE (((Backup_Directory_Structure_List.Directory) Is Null)) ORDER BY Backup_Site_Map.Directory, Backup_Site_Map.FIle_Name;
Link To Column Definitions: Backup_Site_Map_Zapper_DirectoryGone_GEN

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_Zapper_GEN
Query_Type: Append
Query_DateCreated: 18/05/2014 09:47:44
Query_DateChanged: 07/06/2014 10:18:31
Query_SQL: INSERT INTO Backup_Site_Map_Zapper ( Directory, FIle_Name ) SELECT Backup_Site_Map.Directory, Backup_Site_Map.FIle_Name FROM (Backup_Directory_Structure INNER JOIN Backup_Directory_Structure_List ON Backup_Directory_Structure.Directory = Backup_Directory_Structure_List.Directory) INNER JOIN (Backup_Site_Map LEFT JOIN Backup_Site_Map_Temp ON (Backup_Site_Map.Directory = Backup_Site_Map_Temp.Directory) AND (Backup_Site_Map.FIle_Name = Backup_Site_Map_Temp.FIle_Name)) ON Backup_Directory_Structure_List.Directory = Backup_Site_Map.Directory WHERE (((Backup_Site_Map_Temp.Directory) Is Null) AND ((Left([Backup_Directory_Structure]![Directory],Len([Input_Root])))=[Input_Root]));
Link To Column Definitions: Backup_Site_Map_Zapper_GEN

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


Query_Name: Book_Abstracts_Archive_Add
Query_Type: Append
Query_DateCreated: 23/05/2014 13:31:57
Query_DateChanged: 23/05/2014 13:33:54
Query_SQL: INSERT INTO Book_Abstracts_Archive ( ID1, Author, Title, Comments, Abstract, [Timestamp] ) SELECT Book_Abstracts_Archive_Temp.ID1, Book_Abstracts_Archive_Temp.Author, Book_Abstracts_Archive_Temp.Title, Book_Abstracts_Archive_Temp.Comments, Book_Abstracts_Archive_Temp.Abstract, Book_Abstracts_Archive_Temp.Timestamp FROM Book_Abstracts_Archive RIGHT JOIN Book_Abstracts_Archive_Temp ON Book_Abstracts_Archive.ID1 = Book_Abstracts_Archive_Temp.ID1;
Link To Column Definitions: Book_Abstracts_Archive_Add

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


Query_Name: Book_Abstracts_Changed
Query_Type: Append
Query_DateCreated: 23/05/2014 13:21:11
Query_DateChanged: 23/05/2014 13:27:47
Query_SQL: INSERT INTO Book_Abstracts_Archive_Temp ( ID1, Author, Title, Comments, Abstract, [Timestamp] ) SELECT Books.ID1, Books.Author, Books.Title, Books.Comments, Books.Abstract, Now() AS [Timestamp] FROM Book_Abstracts_Archive RIGHT JOIN Books ON Book_Abstracts_Archive.ID1 = Books.ID1 WHERE ((([Books]![Comments] & "")<>([Book_Abstracts_Archive]![Comments] & ""))) OR ((([Books]![Abstract] & "")<>([Book_Abstracts_Archive]![Abstract] & ""))) OR ((([Books]![Title] & "")<>([Book_Abstracts_Archive]![Title] & ""))) OR ((([Books]![Author] & "")<>([Book_Abstracts_Archive]![Author] & ""))) ORDER BY Books.ID1;
Link To Column Definitions: Book_Abstracts_Changed

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_List_New_Gen
Query_Type: Append
Query_DateCreated: 12/04/2020 19:33:27
Query_DateChanged: 12/04/2020 19:33:56
Query_SQL: INSERT INTO Book_Citings_List_New ( Book_ID, Author, Title, Pages, [Read?], [Further Information], Object_ID, Medium, Calling_NameRef ) SELECT Book_Citings_List_New_Query.Book_ID, Book_Citings_List_New_Query.Author, Book_Citings_List_New_Query.Title, Book_Citings_List_New_Query.Pages, Book_Citings_List_New_Query.[Read?], Book_Citings_List_New_Query.[Further Information], Book_Citings_List_New_Query.Object_ID, Book_Citings_List_New_Query.Medium, Book_Citings_List_New_Query.Calling_NameRef FROM Book_Citings_List_New_Query ORDER BY Book_Citings_List_New_Query.Book_ID;
Link To Column Definitions: Book_Citings_List_New_Gen

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


Query_Name: Book_Location_Stats_Temp_GEN
Query_Type: Append
Query_DateCreated: 27/04/2013 11:52:30
Query_DateChanged: 12/05/2013 13:24:17
Query_SQL: INSERT INTO Book_Location_Stats_Temp ( Location, [Number], Pages, Cost ) SELECT Books.Location, Count(Books.ID1) AS [Number], Sum(Books.Pages) AS Pages, Sum(Books.Cost) AS Cost FROM Books GROUP BY Books.Location;
Link To Column Definitions: Book_Location_Stats_Temp_GEN

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_Solitons_GEN
Query_Type: Append
Query_DateCreated: 29/03/2013 11:50:22
Query_DateChanged: 29/03/2013 11:59:55
Query_SQL: INSERT INTO Book_Paper_Solitons ( Book_ID, CountOfPaper_ID ) SELECT Book_Papers_Full.Book_ID, Count(Book_Papers_Full.Paper_ID) AS CountOfPaper_ID FROM Book_Papers_Full GROUP BY Book_Papers_Full.Book_ID HAVING (((Count(Book_Papers_Full.Paper_ID))=1));
Link To Column Definitions: Book_Paper_Solitons_GEN

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_Solitons_Zapper_Gen
Query_Type: Append
Query_DateCreated: 06/08/2019 10:43:36
Query_DateChanged: 06/08/2019 10:44:00
Query_SQL: INSERT INTO Book_Paper_Solitons_Zapper ( Book_ID ) SELECT Book_Paper_Solitons.Book_ID FROM Book_Paper_Solitons INNER JOIN Book_Papers_Full ON Book_Paper_Solitons.Book_ID = Book_Papers_Full.Book_ID WHERE (((Book_Papers_Full.Book_Author_Title)<>[Paper_Author_Title]));
Link To Column Definitions: Book_Paper_Solitons_Zapper_Gen

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


Query_Name: Book_Papers_Full_GEN
Query_Type: Append
Query_DateCreated: 22/02/2009 15:58:32
Query_DateChanged: 20/06/2012 12:25:33
Query_SQL: INSERT INTO Book_Papers_Full ( Book_ID, Paper_ID, Book_Author_Title, [Timestamp], Paper_Author_Title, Sequence, Hours_Left, Paper_Abstract_Quality, Paper_Pages, Paper_Abstract_Length ) SELECT Book_Papers2.Book_ID, Book_Papers2.Paper_ID, Books.[Author & Title], Now() AS [Timestamp], [Papers]![Author] & " - " & [Papers]![Title] AS Expr1, Papers.Sequence, Papers.[Hours Left], Papers.Abstract_Quality, Papers.Pages, 0+Len([Papers]![Abstract] & "")+Len([Papers]![Comments] & "") AS Expr2 FROM (Books INNER JOIN Book_Papers2 ON Books.ID1 = Book_Papers2.Book_ID) INNER JOIN Papers ON Book_Papers2.Paper_ID = Papers.ID GROUP BY Book_Papers2.Book_ID, Book_Papers2.Paper_ID, Books.[Author & Title], Now(), [Papers]![Author] & " - " & [Papers]![Title], Papers.Sequence, Papers.[Hours Left], Papers.Abstract_Quality, Papers.Pages, 0+Len([Papers]![Abstract] & "")+Len([Papers]![Comments] & "");
Link To Column Definitions: Book_Papers_Full_GEN

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


Query_Name: Book_Range_GEN
Query_Type: Append
Query_DateCreated: 22/03/2014 15:32:40
Query_DateChanged: 22/03/2014 15:35:48
Query_SQL: INSERT INTO Books_To_Regen ( Book_ID ) SELECT Books.ID1 FROM Books, Current_ID INNER JOIN BookPaperLinks_Ranges ON Current_ID.Range_ID = BookPaperLinks_Ranges.Range_ID WHERE (((BookPaperLinks_Ranges.[Select?])=True) AND ((Books.ID1)>=[ID_Start]) AND ((Books.ID1)<=[ID_End]));
Link To Column Definitions: Book_Range_GEN

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


Query_Name: Book_Summary_GEN
Query_Type: Append
Query_DateCreated: 25/06/2007 15:41:07
Query_DateChanged: 25/06/2007 15:41:47
Query_SQL: INSERT INTO Book_Summary SELECT Book_Summary_Temp.* FROM Book_Summary_Temp;
Link To Column Definitions: Book_Summary_GEN

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


Query_Name: Book_Summary_Temp_GEN
Query_Type: Append
Query_DateCreated: 04/12/2007 15:03:23
Query_DateChanged: 02/09/2015 23:27:37
Query_SQL: INSERT INTO Book_Summary_Temp ( ID, [Key], [TimeStamp] ) SELECT Books.ID1, [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 [Key], Now() AS [TimeStamp] 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)) GROUP BY Books.ID1, [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],""), Now();
Link To Column Definitions: Book_Summary_Temp_GEN

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


Query_Name: Book_Summary_Temp_GEN_All
Query_Type: Append
Query_DateCreated: 25/06/2007 10:01:02
Query_DateChanged: 17/03/2014 12:32:56
Query_SQL: INSERT INTO Book_Summary_Temp ( ID, [Key], [TimeStamp] ) SELECT Books.ID1, [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 [Key], Now() AS [TimeStamp] FROM Books, Current_ID INNER JOIN Book_Summary_Ranges ON Current_ID.Range_ID = Book_Summary_Ranges.Range_ID WHERE (((Books.ID1)>=[Book_Summary_Ranges]![ID_Start] And (Books.ID1)<=[Book_Summary_Ranges]![ID_End]) AND ((Book_Summary_Ranges.[Select?])=True));
Link To Column Definitions: Book_Summary_Temp_GEN_All

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


Query_Name: BookPaperAbstracts_List_Gen
Query_Type: Append
Query_DateCreated: 13/04/2020 23:49:49
Query_DateChanged: 13/04/2020 23:54:45
Query_SQL: INSERT INTO BookPaperAbstracts_List ( [Book ID], [Paper ID], [Book Author], [Book Title], [Paper Author], [Paper Title], Source, [Read?], [Further Information], [Book Abstract], [Book Comments], [Paper Abstracts], [Paper Comments], Seq, Book_BlurbLen, Paper_BlurbLen, Write_Up_Note_ID, PseudoBook ) 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_Gen

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


Query_Name: Books - All - Categorised_Table_GEN
Query_Type: Append
Query_DateCreated: 02/10/2009 10:19:20
Query_DateChanged: 24/09/2013 19:24:49
Query_SQL: INSERT INTO [Books - All - Categorised_Table] ( Category, Author, Title, Location, Pages, Priority, [Read?], More, Topic, ID, ID1 ) 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, 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, Topics.ID, [Subjects]![ID] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject],"_" & [Topics]![ID]) & IIf([Sub-Topics]![ID]<>498,"_" & [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 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, IIf([Books]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")), IIf([Book_Summary_Refs]![ID1] Is Not Null,[Book_Summary],0), Topics.ID, [Subjects]![ID] & IIf([Topics]![ID]<>194,IIf([Topics]![Topic]<>[Subjects]![Subject],"_" & [Topics]![ID]) & IIf([Sub-Topics]![ID]<>498,"_" & [Sub-Topics]![ID])), Books.ID1, [Location] & "", Topics.Topic HAVING (((Books.Author)<>"zzzz" And (Books.Author)<>"Various") AND (([Location] & "")<>"" And ([Location] & "")<>"Senate House Library") AND ((Topics.Topic)<>"Admin")) 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 - All - Categorised_Table_GEN

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


Query_Name: Books_Locations_Table_GEN
Query_Type: Append
Query_DateCreated: 12/05/2013 17:20:31
Query_DateChanged: 13/09/2013 13:11:05
Query_SQL: INSERT INTO Books_Locations_Table ( Location, Author, Title, Category, Pages, Priority, [Read?], More, Topic, ID, ID1 ) SELECT Books.Location, Books.Author, Books.Title, [Subjects]![Subject] & IIf([Topics]![ID]<>94,IIf([Topics]![Topic]<>[Subjects]![Subject]," - " & [Topics]![Topic]) & IIf([Sub-Topics]![ID]<>98," - " & [Sub-Topics]![Sub-Topic])) AS Category, Books.Pages, Books.Priority, IIf([Books]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")) AS [Read?], IIf([Book_Location_Refs]![ID1] Is Not Null,[Book_Summary],0) AS More, Topics.ID, Locations.ID, Books.ID1 FROM ((((Books INNER JOIN Subjects ON Books.Subject = Subjects.ID) INNER JOIN Topics ON Books.Topic = Topics.ID) INNER JOIN [Sub-Topics] ON Books.[Sub-Topic] = [Sub-Topics].ID) INNER JOIN Locations ON Books.Location = Locations.Location) LEFT JOIN Book_Location_Refs ON Books.ID1 = Book_Location_Refs.ID1 WHERE ((([Books]![Location] & "")<>"" And ([Books]![Location] & "")<>"Senate House Library")) ORDER BY Books.Location, Books.Author, Books.Title;
Link To Column Definitions: Books_Locations_Table_GEN

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


Query_Name: Books_Versus_Papers_Add
Query_Type: Append
Query_DateCreated: 24/12/2006 11:22:02
Query_DateChanged: 07/07/2013 18:59:35
Query_SQL: INSERT INTO Papers ( Location, Author, Title, Book, Book_ID, Pages, Subject, Subject2, Subject3, Source, Medium, Topic, Topic2, Topic3, [Sub-Topic], [Sub-Topic2], [Sub-Topic3], Priority, Difficulty, Status, [Read?] ) SELECT qryBooks.Location, qryBooks.Author, [qryBooks]![Title] AS Expr1, qryBooks.IDs, qryBooks.ID1, qryBooks.Pages, qryBooks.Subject, qryBooks.Subject2, qryBooks.Subject3, qryBooks.[A+T], "Book - Chapter" AS Medium, Topics.ID, "" AS Topic2, "" AS Topic3, [Sub-Topics].ID, "" AS [Sub-Topic2], "" AS [Sub-Topic3], qryBooks.Priority, qryBooks.Difficulty, qryBooks.Status, qryBooks.[Source Read] FROM ((Papers RIGHT JOIN qryBooks ON Papers.Book = qryBooks.IDs) LEFT JOIN Topics ON qryBooks.Topic = Topics.Topic) LEFT JOIN [Sub-Topics] ON qryBooks.[Sub-Topic] = [Sub-Topics].[Sub-Topic] GROUP BY qryBooks.Location, qryBooks.Author, [qryBooks]![Title], qryBooks.IDs, qryBooks.ID1, qryBooks.Pages, qryBooks.Subject, qryBooks.Subject2, qryBooks.Subject3, qryBooks.[A+T], "Book - Chapter", Topics.ID, [Sub-Topics].ID, "", qryBooks.Priority, qryBooks.Difficulty, qryBooks.Status, qryBooks.[Source Read], "", "", "", qryBooks.Title HAVING (((qryBooks.Author)<>"Admin") AND ((qryBooks.Title)<>"Zzzz (Dummy)") AND ((([qryBooks].[Pages])=0 Or ([qryBooks].[Pages]) Is Null)=False) AND ((Sum(Papers.Pages)) Is Null)) ORDER BY qryBooks.Location, qryBooks.Author;
Link To Column Definitions: Books_Versus_Papers_Add

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_Additions
Query_Type: Append
Query_DateCreated: 06/09/2015 23:43:09
Query_DateChanged: 07/09/2015 00:02:12
Query_SQL: INSERT INTO Cross_Reference_Changes ( Calling_Type, Calling_ID, Calling_Timestamp, Called_Type, Called_ID, Called_Timestamp, Calling_NameRef, Cross_Reference_Timestamp, [Action], [Timestamp] ) SELECT Cross_Reference.Calling_Type, Cross_Reference.Calling_ID, Cross_Reference.Calling_Timestamp, Cross_Reference.Called_Type, Cross_Reference.Called_ID, Cross_Reference.Called_Timestamp, Cross_Reference.Calling_NameRef, Cross_Reference.Timestamp, "Added" AS [Action], Now() AS Now FROM Cross_Reference_Latest INNER JOIN (Cross_Reference_Zapper RIGHT JOIN Cross_Reference ON (Cross_Reference_Zapper.Called_Timestamp = Cross_Reference.Called_Timestamp) AND (Cross_Reference_Zapper.Called_Type = Cross_Reference.Called_Type) AND (Cross_Reference_Zapper.Called_ID = Cross_Reference.Called_ID) AND (Cross_Reference_Zapper.Calling_Timestamp = Cross_Reference.Calling_Timestamp) AND (Cross_Reference_Zapper.Calling_ID = Cross_Reference.Calling_ID) AND (Cross_Reference_Zapper.Calling_Type = Cross_Reference.Calling_Type)) ON (Cross_Reference_Latest.Calling_Timestamp = Cross_Reference.Calling_Timestamp) AND (Cross_Reference_Latest.Calling_ID = Cross_Reference.Calling_ID) AND (Cross_Reference_Latest.Calling_Type = Cross_Reference.Calling_Type) WHERE (((Cross_Reference_Zapper.Timestamp) Is Null));
Link To Column Definitions: Cross_Reference_Additions

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_Deletions
Query_Type: Append
Query_DateCreated: 06/09/2015 23:41:39
Query_DateChanged: 13/04/2020 19:42:09
Query_SQL: INSERT INTO Cross_Reference_Changes ( Calling_Type, Calling_ID, Calling_Timestamp, Called_Type, Called_ID, Called_Timestamp, Calling_NameRef, Cross_Reference_Timestamp, [Action], [Timestamp] ) SELECT Cross_Reference_Zapper.Calling_Type, Cross_Reference_Zapper.Calling_ID, Cross_Reference_Zapper.Calling_Timestamp, Cross_Reference_Zapper.Called_Type, Cross_Reference_Zapper.Called_ID, Cross_Reference_Zapper.Called_Timestamp, Cross_Reference_Zapper.Calling_NameRef, Cross_Reference_Zapper.Timestamp, "Deleted" AS [Action], Now() AS Now FROM Cross_Reference_Zapper LEFT JOIN Cross_Reference ON (Cross_Reference_Zapper.Called_Timestamp = Cross_Reference.Called_Timestamp) AND (Cross_Reference_Zapper.Called_Type = Cross_Reference.Called_Type) AND (Cross_Reference_Zapper.Called_ID = Cross_Reference.Called_ID) AND (Cross_Reference_Zapper.Calling_Timestamp = Cross_Reference.Calling_Timestamp) AND (Cross_Reference_Zapper.Calling_ID = Cross_Reference.Calling_ID) AND (Cross_Reference_Zapper.Calling_Type = Cross_Reference.Calling_Type) WHERE (((Cross_Reference.Timestamp) Is Null));
Link To Column Definitions: Cross_Reference_Deletions

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_Add
Query_Type: Append
Query_DateCreated: 06/07/2013 22:59:03
Query_DateChanged: 07/07/2013 19:02:12
Query_SQL: INSERT INTO Paper_Actuals ( ID, [Year], Hours ) SELECT qryPapers.ID, Next_Reporting_Month.[Reporting Year], Actual_Hours_Temp.[Actual Hours] FROM Next_Reporting_Month, qryPapers INNER JOIN Actual_Hours_Temp ON qryPapers.IDs = Actual_Hours_Temp.ID WHERE (((Actual_Hours_Temp.[Actual Hours])>0));
Link To Column Definitions: Current_Year_Papers_Actuals_Add

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_Add
Query_Type: Append
Query_DateCreated: 25/01/2011 18:20:46
Query_DateChanged: 28/06/2013 08:17:34
Query_SQL: INSERT INTO Directory_Structure SELECT Directory_Structure_Temp.* FROM Directory_Structure_Temp LEFT JOIN Directory_Structure ON Directory_Structure_Temp.Directory = Directory_Structure.Directory WHERE (((Directory_Structure.Directory) Is Null));
Link To Column Definitions: Directory_Structure_Add

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_GEN
Query_Type: Append
Query_DateCreated: 25/05/2020 12:21:24
Query_DateChanged: 25/05/2020 12:27:45
Query_SQL: INSERT INTO Functor_Descriptions ( Procedure_Name, Functor_Description ) SELECT Code_Table.Procedure_Name, "Description to be supplied" AS Functor_Description FROM Code_Table LEFT JOIN Functor_Descriptions ON Code_Table.Procedure_Name = Functor_Descriptions.Procedure_Name WHERE (((Code_Table.Procedure_Name) Like "Functor_*") AND ((Functor_Descriptions.Procedure_Name) Is Null));
Link To Column Definitions: Functor_Descriptions_GEN

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


Query_Name: Hits_Bots_Total_GEN
Query_Type: Append
Query_DateCreated: 26/07/2019 18:06:27
Query_DateChanged: 26/07/2019 18:06:27
Query_SQL: INSERT INTO Hits_Bots_Total ( URL, Hits, KBytes, Months, Files, Visits ) SELECT Hits_Bots.URL, Sum(Hits_Bots.Hits) AS SumOfHits, Sum(Hits_Bots.KBytes) AS SumOfKBytes, Count(Hits_Bots.Month) AS CountOfMonth, Sum(Hits_Bots.Files) AS SumOfFiles, Sum(Hits_Bots.Visits) AS SumOfVisits FROM Hits_Bots GROUP BY Hits_Bots.URL;
Link To Column Definitions: Hits_Bots_Total_GEN

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_Total_GEN
Query_Type: Append
Query_DateCreated: 26/07/2019 18:06:27
Query_DateChanged: 26/07/2019 18:06:27
Query_SQL: INSERT INTO Hits_Pages_Total ( URL, Hits, KBytes, Months ) SELECT Hits_Pages.URL, Sum(Hits_Pages.Hits) AS SumOfHits, Sum(Hits_Pages.KBytes) AS SumOfKBytes, Count(Hits_Pages.Month) AS CountOfMonth FROM Hits_Pages GROUP BY Hits_Pages.URL;
Link To Column Definitions: Hits_Pages_Total_GEN

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


Query_Name: Maintainable_Archived_Objects_GEN
Query_Type: Append
Query_DateCreated: 07/09/2015 15:52:52
Query_DateChanged: 11/09/2015 15:31:47
Query_SQL: INSERT INTO Maintainable_Archived_Objects ( Object_Type, Object_ID, Object_Timestamp, Other_Type ) SELECT Cross_Reference.Calling_Type, Cross_Reference.Calling_ID, Cross_Reference.Calling_Timestamp, Cross_Reference.Called_Type FROM Cross_Reference, Maintenance_Dates WHERE (((Cross_Reference.Timestamp)>[Webref_Date]) AND ((Maintenance_Dates.Object_Code)="Z")) GROUP BY Cross_Reference.Calling_Type, Cross_Reference.Calling_ID, Cross_Reference.Calling_Timestamp, Cross_Reference.Called_Type HAVING (((Cross_Reference.Calling_Timestamp)<>0) AND ((Cross_Reference.Called_Type)="W"));
Link To Column Definitions: Maintainable_Archived_Objects_GEN

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


Query_Name: Maintainable_Objects_GEN
Query_Type: Append
Query_DateCreated: 07/09/2015 10:47:57
Query_DateChanged: 11/09/2015 15:32:15
Query_SQL: INSERT INTO Maintainable_Objects ( Object_Type, Object_ID, Other_Type ) SELECT Cross_Reference.Calling_Type, Cross_Reference.Calling_ID, Cross_Reference.Called_Type FROM Maintenance_Dates INNER JOIN Cross_Reference ON Maintenance_Dates.Object_Code = Cross_Reference.Calling_Type WHERE (((Cross_Reference.Timestamp)>[Webref_Date]) AND ((Cross_Reference.Calling_Timestamp)=0)) GROUP BY Cross_Reference.Calling_Type, Cross_Reference.Calling_ID, Cross_Reference.Called_Type HAVING (((Cross_Reference.Called_Type)="W"));
Link To Column Definitions: Maintainable_Objects_GEN

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


Query_Name: Missing_PI_PI
Query_Type: Append
Query_DateCreated: 16/07/2006 08:36:04
Query_DateChanged: 16/07/2006 09:14:57
Query_SQL: INSERT INTO Philosophers_Index ( Category, TI, AU, SO, JN, DE, LA, DT, AN, PS, [IS], PB, AB, PY, IB, RV, UD ) SELECT Philosophers_Index_Identity.Category, Philosophers_Index_Identity.TI, Philosophers_Index_Identity.AU, Philosophers_Index_Identity.SO, Philosophers_Index_Identity.JN, Philosophers_Index_Identity.DE, Philosophers_Index_Identity.LA, Philosophers_Index_Identity.DT, Philosophers_Index_Identity.AN, Philosophers_Index_Identity.PS, Philosophers_Index_Identity.[IS], Philosophers_Index_Identity.PB, Philosophers_Index_Identity.AB, Philosophers_Index_Identity.PY, Philosophers_Index_Identity.IB, Philosophers_Index_Identity.RV, Philosophers_Index_Identity.UD FROM Philosophers_Index_Identity LEFT JOIN Philosophers_Index ON Philosophers_Index_Identity.AN = Philosophers_Index.AN WHERE (((Philosophers_Index.AN) Is Null) AND ((Philosophers_Index_Identity.LA)="English"));
Link To Column Definitions: Missing_PI_PI

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_ADD
Query_Type: Append
Query_DateCreated: 03/10/2010 18:30:39
Query_DateChanged: 03/10/2010 18:56:25
Query_SQL: INSERT INTO Year_Crosstab_Prime ( Task_Group, [Group], Subgroup, Period, Hours ) SELECT New_Year_Crosstab_Prime_NewYear_SubList.Task_Group, New_Year_Crosstab_Prime_NewYear_SubList.Group, New_Year_Crosstab_Prime_NewYear_SubList.Subgroup, Reporting_Months.Month_Text, 0 AS Hours FROM Reporting_Months, New_Year_Crosstab_Prime_NewYear_SubList ORDER BY New_Year_Crosstab_Prime_NewYear_SubList.Task_Group, New_Year_Crosstab_Prime_NewYear_SubList.Group, New_Year_Crosstab_Prime_NewYear_SubList.Subgroup, Reporting_Months.Month_Text;
Link To Column Definitions: New_Year_Crosstab_Prime_NewYear_ADD

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


Query_Name: New_Year_Crosstab_Prime_OldYear_ADD
Query_Type: Append
Query_DateCreated: 03/10/2010 17:47:33
Query_DateChanged: 01/10/2019 18:30:43
Query_SQL: INSERT INTO Year_Crosstab_Prime ( [Group], Subgroup, Task_Group, Period, Hours ) SELECT IIf(InStr([Subject]," ")=0,[Subject],Left([Subject],InStr([Subject]," ")-1)) AS [Subject Group], IIf(InStr([Subject],"-")=0,[Subject],Left([Subject],InStr([Subject],"-")-2)) AS [Subject SubGroup], Timesheet_Old.Subject, "2018/19" AS Period, Sum(Timesheet_Old.Hours) AS SumOfHours FROM Timesheet_Old GROUP BY IIf(InStr([Subject]," ")=0,[Subject],Left([Subject],InStr([Subject]," ")-1)), IIf(InStr([Subject],"-")=0,[Subject],Left([Subject],InStr([Subject],"-")-2)), Timesheet_Old.Subject, "2018/19" HAVING (((Timesheet_Old.Subject)<>"Subject"));
Link To Column Definitions: New_Year_Crosstab_Prime_OldYear_ADD

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


Query_Name: Note_Alternates_Add
Query_Type: Append
Query_DateCreated: 31/10/2017 20:02:19
Query_DateChanged: 31/10/2017 20:03:57
Query_SQL: INSERT INTO Note_Alternates ( Item_Title, ID, Item_Alt_Title ) SELECT Notes.Item_Title, Notes.ID, Notes.Item_Title FROM Notes LEFT JOIN Note_Alternates ON (Notes.Item_Title = Note_Alternates.Item_Alt_Title) AND (Notes.Item_Title = Note_Alternates.Item_Title) AND (Notes.ID = Note_Alternates.ID) WHERE (((Note_Alternates.ID) Is Null));
Link To Column Definitions: Note_Alternates_Add

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


Query_Name: Note_Book_Link_Latest_Add
Query_Type: Append
Query_DateCreated: 20/02/2009 08:37:27
Query_DateChanged: 25/07/2010 19:00:16
Query_SQL: INSERT INTO Note_Book_Links ( [Note], Note_Ref, Book, [Timestamp], Origin, Date_Created ) SELECT Note_Book_Links.Note, Note_Book_Links.Note_Ref, Note_Book_Links.Book, 0 AS Expr1, "Note" AS Expr2, Now() AS Expr3 FROM Notes_Archive_Latest_Time INNER JOIN Note_Book_Links ON (Notes_Archive_Latest_Time.MaxOfTimestamp = Note_Book_Links.Timestamp) AND (Notes_Archive_Latest_Time.ID = Note_Book_Links.Note);
Link To Column Definitions: Note_Book_Link_Latest_Add

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


Query_Name: Note_Book_Link_Latest_Add1
Query_Type: Append
Query_DateCreated: 24/07/2010 08:46:36
Query_DateChanged: 25/07/2010 19:00:42
Query_SQL: INSERT INTO Note_Book_Links ( [Note], Note_Ref, Book, [Timestamp], Origin, Date_Created ) SELECT Note_Book_Links.Note, Note_Book_Links.Note_Ref, Note_Book_Links.Book, 0 AS Expr1, "Note" AS Expr2, Now() AS Expr3 FROM Note_Book_Links LEFT JOIN Note_Book_Link_Latest_Add2 ON (Note_Book_Links.Origin = Note_Book_Link_Latest_Add2.Origin) AND (Note_Book_Links.Book = Note_Book_Link_Latest_Add2.Book) AND (Note_Book_Links.Note = Note_Book_Link_Latest_Add2.Note) WHERE (((Note_Book_Link_Latest_Add2.Note) Is Null) AND ((Note_Book_Links.Timestamp)=1));
Link To Column Definitions: Note_Book_Link_Latest_Add1

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


Query_Name: Note_Paper_Link_Latest_Add
Query_Type: Append
Query_DateCreated: 20/02/2009 10:43:48
Query_DateChanged: 25/07/2010 19:01:01
Query_SQL: INSERT INTO Note_Paper_Links ( [Note], Note_Ref, Paper, [Timestamp], Origin, Date_Created ) SELECT Note_Paper_Links.Note, Note_Paper_Links.Note_Ref, Note_Paper_Links.Paper, 0 AS Expr1, "Note" AS Expr2, Now() AS Expr3 FROM Notes_Archive_Latest_Time INNER JOIN Note_Paper_Links ON (Notes_Archive_Latest_Time.ID = Note_Paper_Links.Note) AND (Notes_Archive_Latest_Time.MaxOfTimestamp = Note_Paper_Links.Timestamp);
Link To Column Definitions: Note_Paper_Link_Latest_Add

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


Query_Name: Note_Paper_Link_Latest_Add1
Query_Type: Append
Query_DateCreated: 23/07/2010 20:23:15
Query_DateChanged: 25/07/2010 19:01:14
Query_SQL: INSERT INTO Note_Paper_Links ( [Note], Note_Ref, Paper, [Timestamp], Origin, Date_Created ) SELECT Note_Paper_Links.Note, Note_Paper_Links.Note_Ref, Note_Paper_Links.Paper, 0 AS Expr1, "Note" AS Expr2, Now() AS Expr3 FROM Note_Paper_Links LEFT JOIN Note_Paper_Link_Latest_Add2 ON (Note_Paper_Links.Origin = Note_Paper_Link_Latest_Add2.Origin) AND (Note_Paper_Links.Paper = Note_Paper_Link_Latest_Add2.Paper) AND (Note_Paper_Links.Note = Note_Paper_Link_Latest_Add2.Note) WHERE (((Note_Paper_Links.Timestamp)=1) AND ((Note_Paper_Link_Latest_Add2.Note) Is Null));
Link To Column Definitions: Note_Paper_Link_Latest_Add1

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


Query_Name: Note_Usage_Temp_Zapper_GEN
Query_Type: Append
Query_DateCreated: 19/08/2007 17:12:15
Query_DateChanged: 19/08/2007 17:12:15
Query_SQL: INSERT INTO Note_Usage_Temp_Zapper SELECT Note_Usage_Temp.* FROM Note_Usage_Temp INNER JOIN Note_Usage_Temp_MinLevel ON Note_Usage_Temp.Note_ID = Note_Usage_Temp_MinLevel.Note_ID WHERE (((Note_Usage_Temp.Note_Level)>[MinOfNote_Level]));
Link To Column Definitions: Note_Usage_Temp_Zapper_GEN

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


Query_Name: Note_Usage_Temp_Zapper_GEN2
Query_Type: Append
Query_DateCreated: 20/08/2007 09:46:54
Query_DateChanged: 20/08/2007 09:53:25
Query_SQL: INSERT INTO Note_Usage_Temp_Zapper SELECT Note_Usage_Temp.* FROM Note_Usage_Temp INNER JOIN Note_Usage_Temp_MinLevel_Dups ON Note_Usage_Temp.Note_ID = Note_Usage_Temp_MinLevel_Dups.Note_ID WHERE (((Note_Usage_Temp.Note_Usage)>[MinOfNote_Usage]));
Link To Column Definitions: Note_Usage_Temp_Zapper_GEN2

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


Query_Name: Notes_Archive_GEN
Query_Type: Append
Query_DateCreated: 18/06/2007 13:20:11
Query_DateChanged: 23/07/2017 12:58:13
Query_SQL: INSERT INTO Notes_Archive SELECT Notes_Archive_Temp.* FROM Notes_Archive_Temp;
Link To Column Definitions: Notes_Archive_GEN

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


Query_Name: Notes_Cited_By_All_List_Gen
Query_Type: Append
Query_DateCreated: 13/04/2020 15:57:42
Query_DateChanged: 13/04/2020 15:58:18
Query_SQL: INSERT INTO Notes_Cited_By_All_List ( Author, Title, Medium, Display_Text, Icon, [Read?], Calling_ID, Calling_NameRef, Note_ID ) SELECT Notes_Cited_By_All_List_Query.Author, Notes_Cited_By_All_List_Query.Title, Notes_Cited_By_All_List_Query.Medium, Notes_Cited_By_All_List_Query.Display_Text, Notes_Cited_By_All_List_Query.Icon, Notes_Cited_By_All_List_Query.[Read?], Notes_Cited_By_All_List_Query.Calling_ID, Notes_Cited_By_All_List_Query.Calling_NameRef, Notes_Cited_By_All_List_Query.Note_ID FROM Notes_Cited_By_All_List_Query;
Link To Column Definitions: Notes_Cited_By_All_List_Gen

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


Query_Name: Notes_to_Print_Add
Query_Type: Append
Query_DateCreated: 21/05/2010 10:42:29
Query_DateChanged: 09/01/2016 16:11:56
Query_SQL: INSERT INTO Notes_to_Print ( Note_ID, Max_Depth, Private, Print_ReadingList, Print_DupNoteRefs, [Current] ) SELECT Notes_to_Print_Add1.ID, Useful_Lists.Item_Value_1 AS Depth, "Yes" AS Private, Useful_Lists.Item_Value_2 AS Print_ReadingList, "No" AS Print_DupNoteRefs, Yes AS [Current] FROM Notes_to_Print_Add1, Useful_Lists WHERE (((Useful_Lists.Item)="Notes_to_Print_Items"));
Link To Column Definitions: Notes_to_Print_Add

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


Query_Name: Oboe_Latest_Lesson_GEN
Query_Type: Append
Query_DateCreated: 06/10/2019 15:41:48
Query_DateChanged: 06/10/2019 16:08:06
Query_SQL: INSERT INTO Oboe_Latest_Lesson ( Latest_Lesson ) SELECT Max(Oboe_Timesheet.Date) AS MaxOfDate FROM Oboe_Timesheet WHERE (((Oboe_Timesheet.Lesson)="Lesson"));
Link To Column Definitions: Oboe_Latest_Lesson_GEN

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


Query_Name: Oboe_Practice_Hours_ADD
Query_Type: Append
Query_DateCreated: 04/10/2019 18:39:39
Query_DateChanged: 06/10/2019 17:00:00
Query_SQL: INSERT INTO Oboe_Practice_Hours ( Subject, Topic, [19/20] ) SELECT Oboe_Practice_Hours_Temp.Subject, Oboe_Practice_Hours_Temp.Topic, Sum(Oboe_Practice_Hours_Temp.Hours) AS SumOfHours FROM Oboe_Practice_Hours_Temp LEFT JOIN Oboe_Practice_Hours ON (Oboe_Practice_Hours_Temp.Topic = Oboe_Practice_Hours.Topic) AND (Oboe_Practice_Hours_Temp.Subject = Oboe_Practice_Hours.Subject) GROUP BY Oboe_Practice_Hours_Temp.Subject, Oboe_Practice_Hours_Temp.Topic, Oboe_Practice_Hours.Subject HAVING (((Oboe_Practice_Hours.Subject) Is Null));
Link To Column Definitions: Oboe_Practice_Hours_ADD

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


Query_Name: Oboe_Practice_Hours_Temp_Dated_GEN
Query_Type: Append
Query_DateCreated: 04/10/2019 18:25:18
Query_DateChanged: 06/10/2019 20:29:05
Query_SQL: INSERT INTO Oboe_Practice_Hours_Temp_Dated ( Subject, Topic, Practice_Date, Latest_Lesson, Hours ) SELECT Timesheet.Subject, Timesheet.Topic, Int([Date]) AS Expr1, Oboe_Latest_Lesson.Latest_Lesson, Sum(Timesheet.Hours) AS SumOfHours FROM Timesheet, Oboe_Latest_Lesson GROUP BY Timesheet.Subject, Timesheet.Topic, Int([Date]), Oboe_Latest_Lesson.Latest_Lesson HAVING (((Timesheet.Subject)="Music - Oboe")) ORDER BY Timesheet.Topic;
Link To Column Definitions: Oboe_Practice_Hours_Temp_Dated_GEN

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


Query_Name: Oboe_Practice_Hours_Temp_Dated_LastYear_GEN
Query_Type: Append
Query_DateCreated: 06/10/2019 20:53:27
Query_DateChanged: 07/10/2019 17:45:55
Query_SQL: INSERT INTO Oboe_Practice_Hours_Temp_Dated ( Subject, Topic, Practice_Date, Latest_Lesson, Hours ) SELECT [Timesheet_Last Year].Subject, [Timesheet_Last Year].Topic, Val([Date]) AS Expr2, Oboe_Latest_Lesson.Latest_Lesson, Sum([Timesheet_Last Year].Hours) AS SumOfHours FROM Oboe_Latest_Lesson, [Timesheet_Last Year] WHERE (((Val([Date] & ""))>0)) GROUP BY [Timesheet_Last Year].Subject, [Timesheet_Last Year].Topic, Val([Date]), Oboe_Latest_Lesson.Latest_Lesson HAVING ((([Timesheet_Last Year].Subject)="Music - Oboe")) ORDER BY [Timesheet_Last Year].Topic;
Link To Column Definitions: Oboe_Practice_Hours_Temp_Dated_LastYear_GEN

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


Query_Name: Oboe_Practice_Hours_Temp_GEN
Query_Type: Append
Query_DateCreated: 06/10/2019 17:22:00
Query_DateChanged: 06/10/2019 20:43:41
Query_SQL: INSERT INTO Oboe_Practice_Hours_Temp ( Subject, Topic, Hours ) SELECT Oboe_Practice_Hours_Temp_Dated.Subject, Oboe_Practice_Hours_Temp_Dated.Topic, Sum(Oboe_Practice_Hours_Temp_Dated.Hours) AS SumOfHours FROM Oboe_Practice_Hours_Temp_Dated GROUP BY Oboe_Practice_Hours_Temp_Dated.Subject, Oboe_Practice_Hours_Temp_Dated.Topic;
Link To Column Definitions: Oboe_Practice_Hours_Temp_GEN

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


Query_Name: Page_Regen_GEN
Query_Type: Append
Query_DateCreated: 13/09/2015 20:09:42
Query_DateChanged: 15/09/2015 08:45:48
Query_SQL: INSERT INTO Page_Regen ( Called_Type, Called_ID, Calling_Type, Records, Earliest_Change ) SELECT Cross_Reference_Changes.Called_Type, Cross_Reference_Changes.Called_ID, Cross_Reference_Changes.Calling_Type, Count(Cross_Reference_Changes.ID) AS Records, Min(Cross_Reference_Changes.Timestamp) AS Earliest_Change FROM Cross_Reference_Changes GROUP BY Cross_Reference_Changes.Called_Type, Cross_Reference_Changes.Called_ID, Cross_Reference_Changes.Calling_Type HAVING (((Cross_Reference_Changes.Called_Type)<>"W"));
Link To Column Definitions: Page_Regen_GEN

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


Query_Name: Paper_Books_GEN
Query_Type: Append
Query_DateCreated: 17/11/2007 17:05:29
Query_DateChanged: 28/06/2011 17:32:08
Query_SQL: INSERT INTO Paper_Books ( ID, Book, Book_ID, [Timestamp] ) SELECT Papers.ID, qryBooks.IDs, qryBooks.ID1, Now() AS Expr1 FROM Papers INNER JOIN qryBooks ON Papers.Book = qryBooks.[Book IDs];
Link To Column Definitions: Paper_Books_GEN

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


Query_Name: Paper_Citings_List_New_Gen
Query_Type: Append
Query_DateCreated: 12/04/2020 15:02:03
Query_DateChanged: 12/04/2020 15:03:46
Query_SQL: INSERT INTO Paper_Citings_List_New ( Paper_ID, Author, Title, Pages, [Read?], [Further Information], Object_ID, Medium, Calling_NameRef ) SELECT Paper_Citings_List_New_Query.Paper_ID, Paper_Citings_List_New_Query.Author, Paper_Citings_List_New_Query.Title, Paper_Citings_List_New_Query.Pages, Paper_Citings_List_New_Query.[Read?], Paper_Citings_List_New_Query.[Further Information], Paper_Citings_List_New_Query.Object_ID, Paper_Citings_List_New_Query.Medium, Paper_Citings_List_New_Query.Calling_NameRef FROM Paper_Citings_List_New_Query;
Link To Column Definitions: Paper_Citings_List_New_Gen

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


Query_Name: Paper_Summary_GEN
Query_Type: Append
Query_DateCreated: 09/06/2007 17:07:45
Query_DateChanged: 09/06/2007 17:08:10
Query_SQL: INSERT INTO Paper_Summary SELECT Paper_Summary_Temp.* FROM Paper_Summary_Temp;
Link To Column Definitions: Paper_Summary_GEN

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


Query_Name: Paper_Summary_Temp_GEN
Query_Type: Append
Query_DateCreated: 04/12/2007 15:05:45
Query_DateChanged: 02/09/2015 23:24:25
Query_SQL: INSERT INTO Paper_Summary_Temp ( ID, [Key], [TimeStamp] ) SELECT Papers.ID, [Author] & [Title] & [Subject] & [Subject2] & [Subject3] & [Location] & [Medium] & [Book] & [Topic] & [Topic2] & [Topic3] & [Sub-Topic] & [Sub-Topic2] & [Sub-Topic3] & [Source] & [Pages] & [Priority] & [Difficulty] & [Estimate] & Nz([Actual - Total]) & [Read?] & [Precis?] & [Referenced?] & [On_Laptop?] & [Photopcopy?] & IIf([Abstract] & ""="","No","Yes") & IIf([Comments] & ""="","No","Yes") & [Write_Up_Note_ID] AS [Key], Now() AS [TimeStamp] FROM Papers LEFT JOIN Paper_Summary ON Papers.ID = Paper_Summary.ID WHERE ((([Author] & [Title] & [Subject] & [Subject2] & [Subject3] & [Location] & [Medium] & [Book] & [Topic] & [Topic2] & [Topic3] & [Sub-Topic] & [Sub-Topic2] & [Sub-Topic3] & [Source] & [Pages] & [Priority] & [Difficulty] & [Estimate] & Nz([Actual - Total]) & [Read?] & [Precis?] & [Referenced?] & [On_Laptop?] & [Photopcopy?] & IIf([Abstract] & ""="","No","Yes") & IIf([Comments] & ""="","No","Yes") & [Write_Up_Note_ID])<>[Paper_Summary]![Key])) OR (((Paper_Summary.ID) Is Null));
Link To Column Definitions: Paper_Summary_Temp_GEN

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


Query_Name: Paper_Summary_Temp_GEN_All
Query_Type: Append
Query_DateCreated: 09/06/2007 16:51:47
Query_DateChanged: 16/03/2014 20:25:20
Query_SQL: INSERT INTO Paper_Summary_Temp ( ID, [Key], [TimeStamp] ) SELECT Papers.ID, [Author] & [Title] & [Subject] & [Subject2] & [Subject3] & [Location] & [Medium] & [Book] & [Topic] & [Topic2] & [Topic3] & [Sub-Topic] & [Sub-Topic2] & [Sub-Topic3] & [Source] & [Pages] & [Priority] & [Difficulty] & [Estimate] & Nz([Actual - Total]) & [Read?] & [Precis?] & [Referenced?] & [On_Laptop?] & [Photopcopy?] & IIf([Abstract] & ""="","No","Yes") & IIf([Comments] & ""="","No","Yes") AS [Key], Now() AS [TimeStamp] FROM Papers, Paper_Summary_Ranges INNER JOIN Current_ID ON Paper_Summary_Ranges.Range_ID = Current_ID.Range_ID WHERE (((Papers.ID)>=[Paper_Summary_Ranges]![ID_Start]) AND ((Papers.ID)<=[Paper_Summary_Ranges]![ID_End]) AND ((Paper_Summary_Ranges.[Select?])=True));
Link To Column Definitions: Paper_Summary_Temp_GEN_All

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


Query_Name: Paper_Summary_Temp_GEN_New
Query_Type: Append
Query_DateCreated: 17/12/2008 08:39:31
Query_DateChanged: 18/11/2009 09:09:45
Query_SQL: INSERT INTO Paper_Summary_Temp ( ID, [TimeStamp] ) SELECT Papers.ID, Now() AS [TimeStamp] FROM Papers WHERE (((Papers.[Actual - Intermission Year 2])>0));
Link To Column Definitions: Paper_Summary_Temp_GEN_New

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


Query_Name: Paper_Summary_Temp_GEN_Quality
Query_Type: Append
Query_DateCreated: 11/04/2009 00:02:26
Query_DateChanged: 03/10/2010 13:31:49
Query_SQL: INSERT INTO Paper_Summary_Temp ( ID, [Key], [TimeStamp] ) SELECT Papers.ID, [Author] & [Title] & [Subject] & [Subject2] & [Subject3] & [Location] & [Medium] & [Book] & [Topic] & [Topic2] & [Topic3] & [Sub-Topic] & [Sub-Topic2] & [Sub-Topic3] & [Source] & [Pages] & [Priority] & [Difficulty] & [Estimate] & (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])) & [Read?] & [Precis?] & [Referenced?] & [On_Laptop?] & [Photopcopy?] & IIf([Abstract] & ""="","No","Yes") & IIf([Comments] & ""="","No","Yes") AS [Key], Now() AS [TimeStamp] FROM Papers WHERE (((Papers.Abstract_Quality) Is Not Null));
Link To Column Definitions: Paper_Summary_Temp_GEN_Quality

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


Query_Name: Papers - All - Categorised - Sub_Table_GEN
Query_Type: Append
Query_DateCreated: 15/12/2010 15:37:44
Query_DateChanged: 04/12/2011 17:54:29
Query_SQL: INSERT INTO [Papers - All - Categorised - Sub_Table] ( Category, Author, Title, Priority, Abstract, Source, Pages, [Read?], ID2, ID ) SELECT [Sub-Topics]![Sub-Topic] AS Category, 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, Papers.ID FROM (Papers INNER JOIN Paper_SubTopic_All ON Papers.ID = Paper_SubTopic_All.ID) INNER JOIN [Sub-Topics] ON Paper_SubTopic_All.[Sub-Topic] = [Sub-Topics].ID WHERE (((Papers.Author)<>"Admin") AND (([Sub-Topics].[Sub-Topic])<>"Unclassified")) ORDER BY [Sub-Topics]![Sub-Topic];
Link To Column Definitions: Papers - All - Categorised - Sub_Table_GEN

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


Query_Name: Philosophy Papers - All - Categorised (Titles) - Solitons_GEN
Query_Type: Append
Query_DateCreated: 13/05/2014 13:05:53
Query_DateChanged: 13/05/2014 13:07:47
Query_SQL: INSERT INTO [Philosophy Papers - All - Categorised (Titles) - Solitons_Table] ( Top_ID, ID ) SELECT [Philosophy Papers - All - Categorised (Titles) - Solitons1].Top_ID, [Philosophy Papers - All - Categorised (Titles)1].ID FROM [Philosophy Papers - All - Categorised (Titles) - Solitons1] INNER JOIN [Philosophy Papers - All - Categorised (Titles)1] ON [Philosophy Papers - All - Categorised (Titles) - Solitons1].Top_ID = [Philosophy Papers - All - Categorised (Titles)1].Top_ID;
Link To Column Definitions: Philosophy Papers - All - Categorised (Titles) - Solitons_GEN

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


Query_Name: Philosophy Papers - All - Categorised (Titles) - Top_Table_GEN
Query_Type: Append
Query_DateCreated: 12/05/2014 23:47:24
Query_DateChanged: 12/05/2014 23:49:56
Query_SQL: INSERT INTO [Philosophy Papers - All - Categorised (Titles) - Top_Table] ( Legend, ID2, CountOfID ) SELECT [Philosophy Papers - All - Categorised (Titles) - Top1].Legend, IIf([ID] Is Null,[Philosophy Papers - All - Categorised (Titles) - Top1]![ID2],[ID]) AS ID2, [Philosophy Papers - All - Categorised (Titles) - Counter].CountOfID FROM ([Philosophy Papers - All - Categorised (Titles) - Top1] INNER JOIN [Philosophy Papers - All - Categorised (Titles) - Counter] ON [Philosophy Papers - All - Categorised (Titles) - Top1].ID2 = [Philosophy Papers - All - Categorised (Titles) - Counter].[Top ID]) LEFT JOIN [Philosophy Papers - All - Categorised (Titles) - Solitons] ON [Philosophy Papers - All - Categorised (Titles) - Counter].[Top ID] = [Philosophy Papers - All - Categorised (Titles) - Solitons].Top_ID GROUP BY [Philosophy Papers - All - Categorised (Titles) - Top1].Legend, IIf([ID] Is Null,[Philosophy Papers - All - Categorised (Titles) - Top1]![ID2],[ID]), [Philosophy Papers - All - Categorised (Titles) - Counter].CountOfID ORDER BY [Philosophy Papers - All - Categorised (Titles) - Top1].Legend;
Link To Column Definitions: Philosophy Papers - All - Categorised (Titles) - Top_Table_GEN

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


Query_Name: Philosophy Papers - All - Categorised (Titles)_Table_GEN
Query_Type: Append
Query_DateCreated: 12/05/2014 18:10:20
Query_DateChanged: 12/05/2014 23:49:42
Query_SQL: INSERT INTO [Philosophy Papers - All - Categorised (Titles)_Table] ( Category, ID, Top_ID ) SELECT [Philosophy Papers - All - Categorised (Titles)1].Category, IIf([Philosophy Papers - All - Categorised (Titles) - Solitons]![ID] Is Null,[Philosophy Papers - All - Categorised (Titles)1]![ID],[Philosophy Papers - All - Categorised (Titles) - Solitons]![ID]) AS ID, [Philosophy Papers - All - Categorised (Titles)1].Top_ID FROM [Philosophy Papers - All - Categorised (Titles)1] LEFT JOIN [Philosophy Papers - All - Categorised (Titles) - Solitons] ON [Philosophy Papers - All - Categorised (Titles)1].Top_ID = [Philosophy Papers - All - Categorised (Titles) - Solitons].Top_ID;
Link To Column Definitions: Philosophy Papers - All - Categorised (Titles)_Table_GEN

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


Query_Name: Philosophy Papers - All - Categorised_Table_GEN
Query_Type: Append
Query_DateCreated: 12/04/2009 17:22:14
Query_DateChanged: 14/09/2012 12:32:10
Query_SQL: INSERT INTO [Philosophy Papers - All - Categorised_Table] ( Category, Author, Title, Priority, Abstract, Source, Pages, [Read?], ID2, ID, Topic ) SELECT GetCategory([Topics]![ID],[Topics]![Topic],[Subjects]![ID],[Subjects]![Subject],[Sub-Topics]![ID],[Sub-Topics]![Sub-Topic]) AS Category, 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?], GetCategoryID([Topics]![ID],[Topics]![Topic],[Subjects]![ID],[Subjects]![Subject],[Sub-Topics]![ID],[Sub-Topics]![Sub-Topic]) AS ID2, Papers.ID, Topics.ID FROM (((Papers INNER JOIN Paper_Subject_Topic_Subtopic_List ON Papers.ID = Paper_Subject_Topic_Subtopic_List.ID) INNER JOIN Subjects ON Paper_Subject_Topic_Subtopic_List.Subject = Subjects.ID) INNER JOIN Topics ON Paper_Subject_Topic_Subtopic_List.Topic = Topics.ID) INNER JOIN [Sub-Topics] ON Paper_Subject_Topic_Subtopic_List.[Sub-Topic] = [Sub-Topics].ID WHERE (((Topics.Topic)<>"Identity" And (Topics.Topic)<>"Admin")) GROUP BY GetCategory([Topics]![ID],[Topics]![Topic],[Subjects]![ID],[Subjects]![Subject],[Sub-Topics]![ID],[Sub-Topics]![Sub-Topic]), Papers.Author, Papers.Title, Papers.Priority, IIf([Papers]![Abstract] & ""<>"",[Papers]![ID],0), Papers.Source, Papers.Pages, IIf([Papers]![Read?]=Yes,"Yes",IIf([Hours Left]>=[Estimate],"",Str(Round((([Estimate]-[Hours Left])/[Estimate])*100)) & "%")), GetCategoryID([Topics]![ID],[Topics]![Topic],[Subjects]![ID],[Subjects]![Subject],[Sub-Topics]![ID],[Sub-Topics]![Sub-Topic]), Papers.ID, Topics.ID HAVING (((Papers.Author)<>"Admin")) ORDER BY GetCategory([Topics]![ID],[Topics]![Topic],[Subjects]![ID],[Subjects]![Subject],[Sub-Topics]![ID],[Sub-Topics]![Sub-Topic]), Papers.Author, Papers.Title;
Link To Column Definitions: Philosophy Papers - All - Categorised_Table_GEN

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


Query_Name: Photo_Raw_Excluded_Link_KeysQ
Query_Type: Append
Query_DateCreated: 09/02/2019 12:06:19
Query_DateChanged: 09/02/2019 12:41:55
Query_SQL: INSERT INTO Photo_Raw_Excluded_Link_Keys ( Link_Key, Photo_Type ) SELECT Photos_Raw.Link_Key, Photos_Raw.Photo_Type FROM Photos_Raw WHERE (((Photos_Raw.[Exclude?])=True)) GROUP BY Photos_Raw.Link_Key, Photos_Raw.Photo_Type ORDER BY Photos_Raw.Link_Key;
Link To Column Definitions: Photo_Raw_Excluded_Link_KeysQ

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


Query_Name: Photo_Raw_Non_Excluded_Triplets
Query_Type: Append
Query_DateCreated: 16/02/2019 21:38:13
Query_DateChanged: 16/02/2019 21:41:00
Query_SQL: INSERT INTO Photo_Raw_Excluded_Link_Keys ( Link_Key, Photo_Type ) SELECT Photos_Raw.Link_Key, Photos_Raw.Photo_Type FROM Photos_Raw WHERE (((Photos_Raw.[Exclude?])=False)) GROUP BY Photos_Raw.Link_Key, Photos_Raw.Photo_Type HAVING (((Count(Photos_Raw.Photo_FileName))>2)) ORDER BY Photos_Raw.Link_Key;
Link To Column Definitions: Photo_Raw_Non_Excluded_Triplets

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


Query_Name: Photo_Type_Goup_Mismatch_Gen
Query_Type: Append
Query_DateCreated: 11/02/2019 14:52:30
Query_DateChanged: 11/02/2019 14:55:02
Query_SQL: INSERT INTO Photo_Raw_Excluded_Link_Keys ( Link_Key, Photo_Type ) SELECT Photos_Raw.Link_Key, Photos_Raw.Photo_Type FROM Photos_Raw INNER JOIN Photo_Type_Goup_Counts ON Photos_Raw.Link_Key = Photo_Type_Goup_Counts.Link_Key ORDER BY Photos_Raw.Link_Key, Photos_Raw.Photo_Type;
Link To Column Definitions: Photo_Type_Goup_Mismatch_Gen

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


Query_Name: Project_Plans_NextYear_Add
Query_Type: Append
Query_DateCreated: 07/10/2014 21:10:39
Query_DateChanged: 07/10/2014 21:10:39
Query_SQL: INSERT INTO Project_Plans ( Project, Period, Weekly_Hours ) SELECT Project_Plans.Project, Val(Left([Period],4))+1 & Mid([Period],5) AS Period1, Project_Plans.Weekly_Hours FROM Project_Plans, Next_Reporting_Month WHERE (((Left([Period],4))=[Reporting Year]) AND ((Right([Period],2))>"09")) OR (((Left([Period],4))>[Reporting Year]));
Link To Column Definitions: Project_Plans_NextYear_Add

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


Query_Name: Query_Definitions_Archive
Query_Type: Append
Query_DateCreated: 18/06/2013 08:12:15
Query_DateChanged: 23/06/2013 18:41:20
Query_SQL: INSERT INTO Query_Definitions_Historic ( Query_Name, Query_Type, Query_DateCreated, Query_DateChanged, Query_SQL ) SELECT Query_Definitions.Query_Name, Query_Definitions.Query_Type, Query_Definitions.Query_DateCreated, Query_Definitions.Query_DateChanged, Query_Definitions.Query_SQL FROM Query_Definitions LEFT JOIN Query_Definitions_Historic ON (Query_Definitions.Query_DateChanged = Query_Definitions_Historic.Query_DateChanged) AND (Query_Definitions.Query_Name = Query_Definitions_Historic.Query_Name) WHERE (((Query_Definitions_Historic.Query_Name) Is Null));
Link To Column Definitions: Query_Definitions_Archive

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


Query_Name: Query1
Query_Type: Append
Query_DateCreated: 17/05/2018 09:07:37
Query_DateChanged: 17/05/2018 09:07:37
Query_SQL: INSERT INTO Raw_Links_Temp ( Directory, File_Name, Raw_Link ) SELECT Raw_Links_Temp_Temp.Directory, Raw_Links_Temp_Temp.File_Name, Raw_Links_Temp_Temp.Raw_Link FROM Raw_Links_Temp_Temp GROUP BY Raw_Links_Temp_Temp.Directory, Raw_Links_Temp_Temp.File_Name, Raw_Links_Temp_Temp.Raw_Link;
Link To Column Definitions: Query1

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


Query_Name: Raw_Broken_Links_Old_Updt
Query_Type: Append
Query_DateCreated: 18/08/2018 11:58:23
Query_DateChanged: 18/08/2018 11:58:23
Query_SQL: INSERT INTO Raw_Broken_Links_Old SELECT Raw_Broken_Links.* FROM Raw_Broken_Links;
Link To Column Definitions: Raw_Broken_Links_Old_Updt

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


Query_Name: Raw_Links_Add
Query_Type: Append
Query_DateCreated: 25/01/2011 18:26:31
Query_DateChanged: 28/06/2013 12:01:58
Query_SQL: INSERT INTO Raw_Links SELECT Raw_Links_Temp.* FROM Raw_Links_Temp LEFT JOIN Raw_Links ON (Raw_Links_Temp.Raw_Link = Raw_Links.Raw_Link) AND (Raw_Links_Temp.File_Name = Raw_Links.File_Name) AND (Raw_Links_Temp.Directory = Raw_Links.Directory) WHERE (((Raw_Links.Directory) Is Null));
Link To Column Definitions: Raw_Links_Add

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


Query_Name: Raw_Links_Zapper_GEN
Query_Type: Append
Query_DateCreated: 13/09/2014 18:08:56
Query_DateChanged: 13/09/2014 18:08:56
Query_SQL: INSERT INTO Raw_Links_Temp ( Directory, File_Name, Raw_Link, Full_Link, Timestamp_Logged, Link_Type, Link_Count ) SELECT Raw_Links.Directory, Raw_Links.File_Name, Raw_Links.Raw_Link, Raw_Links.Full_Link, Raw_Links.Timestamp_Logged, Raw_Links.Link_Type, Raw_Links.Link_Count FROM Raw_Links LEFT JOIN Site_Map ON (Raw_Links.File_Name = Site_Map.FIle_Name) AND (Raw_Links.Directory = Site_Map.Directory) WHERE (((Site_Map.Directory) Is Null));
Link To Column Definitions: Raw_Links_Zapper_GEN

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


Query_Name: Site_Map_Add
Query_Type: Append
Query_DateCreated: 25/01/2011 18:12:20
Query_DateChanged: 13/09/2014 17:24:54
Query_SQL: INSERT INTO Site_Map ( Directory, FIle_Name, Timestamp_Logged, [Size], Block_Update, Time_To_Update, Full_File_Name, File_Timestamp ) SELECT Site_Map_Temp.Directory, Site_Map_Temp.FIle_Name, Site_Map_Temp.Timestamp_Logged, Site_Map_Temp.Size, Site_Map_Temp.Block_Update, Site_Map_Temp.Time_To_Update, Site_Map_Temp.Full_File_Name, Site_Map_Temp.File_Timestamp FROM Site_Map_Temp LEFT JOIN Site_Map ON (Site_Map_Temp.FIle_Name = Site_Map.FIle_Name) AND (Site_Map_Temp.Directory = Site_Map.Directory) WHERE (((Site_Map.Directory) Is Null));
Link To Column Definitions: Site_Map_Add

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


Query_Name: Spider_Missing_Internal_Links_Add
Query_Type: Append
Query_DateCreated: 16/08/2018 13:18:48
Query_DateChanged: 16/08/2018 13:25:08
Query_SQL: INSERT INTO Raw_Broken_Links ( Directory, File_Name, Raw_Link, Full_Link, Timestamp_Logged, Link_Type, Link_Count, Section_Link ) SELECT Raw_Links.Directory, Raw_Links.File_Name, Raw_Links.Raw_Link, Raw_Links.Full_Link, Raw_Links.Timestamp_Logged, Raw_Links.Link_Type, Raw_Links.Link_Count, Raw_Links.Section_Link FROM Raw_Links LEFT JOIN Site_Map ON Raw_Links.Full_Link = Site_Map.Full_File_Name WHERE (((Raw_Links.Raw_Link)<>"Null" And (Raw_Links.Raw_Link)<>"Defective") AND ((Raw_Links.Full_Link) Is Not Null) AND ((Site_Map.Full_File_Name) Is Null)) ORDER BY Raw_Links.Directory, Raw_Links.File_Name, Raw_Links.Raw_Link;
Link To Column Definitions: Spider_Missing_Internal_Links_Add

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


Query_Name: Spider_Weblinks_Add
Query_Type: Append
Query_DateCreated: 26/09/2012 12:10:10
Query_DateChanged: 12/10/2017 13:10:31
Query_SQL: INSERT INTO WebLinkCheck ( Directory, File_Name, Raw_Link, Full_Link, Timestamp_Logged, Link_Type ) SELECT Mid([Directory],Len("C:\Theo's Files\Websites\Theo's Website\")+1,Len([Directory])) AS SubDirectory, Raw_Links.File_Name, Raw_Links.Raw_Link, Raw_Links.Full_Link, Raw_Links.Timestamp_Logged, Raw_Links.Link_Type FROM Raw_Links WHERE (((Raw_Links.Link_Type) Like "Web*") AND ((Left([File_Name],Len("WebLinks_Tester")))<>"WebLinks_Tester"));
Link To Column Definitions: Spider_Weblinks_Add

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


Query_Name: Time_By_Weekday_Prelist_GEN
Query_Type: Append
Query_DateCreated: 09/01/2009 11:28:01
Query_DateChanged: 08/03/2015 14:59:27
Query_SQL: INSERT INTO Time_By_Weekday_Prelist ( Week_Day, Hours_Worked, [Date], Days_This_Year ) SELECT Timesheet.Day AS Week_Day, Val([Hours]) AS Hours_Worked, Val([Date]) AS Expr1, (Now()-#10/1/2014#) AS Days_This_Year FROM Timesheet WHERE (((Timesheet.Day)<>"Day")) ORDER BY Timesheet.Day, Val([Date]);
Link To Column Definitions: Time_By_Weekday_Prelist_GEN

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


Query_Name: Time_This_Month_List_Gen
Query_Type: Append
Query_DateCreated: 22/12/2010 14:05:26
Query_DateChanged: 01/01/2011 19:08:20
Query_SQL: INSERT INTO Time_This_Month_List ( Subject, Topic, Hours, Reference, [Read?], [Write?] ) SELECT Time_This_Month_List_Temp.Subject, Time_This_Month_List_Temp.Topic, Sum(Time_This_Month_List_Temp.Hours) AS SumOfHours, Time_This_Month_List_Temp.ID, Min(Time_This_Month_List_Temp.[Read?]) AS [MinOfRead?], Min(Time_This_Month_List_Temp.[Write?]) AS [MinOfWrite?] FROM Time_This_Month_List_Temp, Next_Reporting_Month WHERE (((Time_This_Month_List_Temp.Month)>=[Start_Reporting_Month] And (Time_This_Month_List_Temp.Month)<=[Current_Reporting_Month])) GROUP BY Time_This_Month_List_Temp.Subject, Time_This_Month_List_Temp.Topic, Time_This_Month_List_Temp.ID;
Link To Column Definitions: Time_This_Month_List_Gen

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


Query_Name: Time_This_Month_List_Temp_Gen
Query_Type: Append
Query_DateCreated: 16/01/2010 11:02:15
Query_DateChanged: 06/07/2013 17:21:44
Query_SQL: INSERT INTO Time_This_Month_List_Temp ( Subject, Topic, Hours, [Month], ID ) SELECT Timesheet.Subject, Timesheet.Topic, Timesheet.Hours, Timesheet.Month, Timesheet.ID FROM Timesheet WHERE (((Timesheet.Subject)<>"Subject" Or (Timesheet.Subject) Is Null) AND ((Timesheet.Hours)<>"-")) ORDER BY Timesheet.Subject, Timesheet.Topic;
Link To Column Definitions: Time_This_Month_List_Temp_Gen

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


Query_Name: Time_This_Month_List_YTD_Gen
Query_Type: Append
Query_DateCreated: 21/06/2018 18:18:56
Query_DateChanged: 19/01/2020 10:56:28
Query_SQL: INSERT INTO Time_This_Month_List ( Subject, Topic, Hours, Reference, [Read?], [Write?] ) SELECT Time_This_Month_List_Temp.Subject, Time_This_Month_List_Temp.Topic, Sum(Time_This_Month_List_Temp.Hours) AS SumOfHours, Time_This_Month_List_Temp.ID, Min(Time_This_Month_List_Temp.[Read?]) AS [MinOfRead?], Min(Time_This_Month_List_Temp.[Write?]) AS [MinOfWrite?] FROM Time_This_Month_List_Temp, Next_Reporting_Month WHERE (((Time_This_Month_List_Temp.Month)>9)) OR (((Time_This_Month_List_Temp.Month)<=-[Current_Reporting_Month]*([Current_Reporting_Month]<>12))) GROUP BY Time_This_Month_List_Temp.Subject, Time_This_Month_List_Temp.Topic, Time_This_Month_List_Temp.ID;
Link To Column Definitions: Time_This_Month_List_YTD_Gen

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


Query_Name: Time_This_Month_New_GEN
Query_Type: Append
Query_DateCreated: 18/03/2013 12:06:56
Query_DateChanged: 08/02/2017 20:14:04
Query_SQL: INSERT INTO Time_This_Month_New ( Project, Subjects, [Project Hours], Subject, [Subject Hours], Book, Topic, [Read/Write], Hours, Type, Paper, Paper_Or_Book ) SELECT Time_This_Month_Prelist1_New.Project, Time_This_Month_Grand_Tots_New.Subjects, Time_This_Month_Grand_Tots_New.[Total Hours] AS [Project Hours], Time_This_Month_Prelist1_New.Subject, Time_This_Month_Tots_New.[Total Hours] AS [Subject Hours], Time_This_Month_Prelist1_New.Book, Time_This_Month_Prelist1_New.Topic, Time_This_Month_Prelist1_New.[Read/Write], Time_This_Month_Prelist1_New.Hours, Time_This_Month_Prelist1_New.Type, Time_This_Month_Prelist1_New.Paper, IIf([Paper_Count_For_Book]=1,"B","P") AS Paper_Or_Book FROM (Time_This_Month_Prelist1_New LEFT JOIN Time_This_Month_Grand_Tots_New ON Time_This_Month_Prelist1_New.Project = Time_This_Month_Grand_Tots_New.Project) LEFT JOIN Time_This_Month_Tots_New ON (Time_This_Month_Prelist1_New.Project = Time_This_Month_Tots_New.Project) AND (Time_This_Month_Prelist1_New.Subject = Time_This_Month_Tots_New.Subject) ORDER BY Time_This_Month_Prelist1_New.Project, Time_This_Month_Prelist1_New.Subject, Time_This_Month_Prelist1_New.Topic;
Link To Column Definitions: Time_This_Month_New_GEN

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


Query_Name: Timesheet_Time_Outstanding_GEN
Query_Type: Append
Query_DateCreated: 05/07/2013 00:06:39
Query_DateChanged: 06/07/2013 17:49:38
Query_SQL: INSERT INTO Timesheet_Time_Outstanding ( [Date], Hours, [Month] ) SELECT DateSerial(Year([Date]),Month([Date]),Day([Date])) AS DateAdd, Timesheet.Hours, Timesheet.Month FROM Timesheet WHERE (((Timesheet.Hours)<>"-") AND ((Timesheet.Subject) Is Null)) ORDER BY DateSerial(Year([Date]),Month([Date]),Day([Date])), Timesheet.Subject;
Link To Column Definitions: Timesheet_Time_Outstanding_GEN

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


Query_Name: Webrefs_Add
Query_Type: Append
Query_DateCreated: 29/12/2015 00:47:58
Query_DateChanged: 19/05/2018 00:14:56
Query_SQL: INSERT INTO Webrefs_Table ( Webref, Date_Created, Issue ) SELECT WebLinkCheck.Raw_Link, WebLinkCheck.Timestamp_Logged, "Created by Spider" AS Issue FROM WebLinkCheck LEFT JOIN Webrefs_Table ON WebLinkCheck.Raw_Link = Webrefs_Table.Webref WHERE (((Webrefs_Table.ID) Is Null)) GROUP BY WebLinkCheck.Raw_Link, WebLinkCheck.Timestamp_Logged, "Created by Spider" HAVING (((WebLinkCheck.Raw_Link) Not Like "*a href*"));
Link To Column Definitions: Webrefs_Add

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


Query_Name: Year_Crosstab_Add
Query_Type: Append
Query_DateCreated: 05/10/2008 18:54:35
Query_DateChanged: 16/01/2010 10:42:46
Query_SQL: INSERT INTO Year_Crosstab ( [Group], Subgroup, Task_Group, Period, Hours ) SELECT IIf(InStr([Subject]," ")=0,[Subject],Left([Subject],InStr([Subject]," ")-1)) AS [Subject Group], IIf(InStr([Subject],"-")=0,[Subject],Left([Subject],InStr([Subject],"-")-2)) AS [Subject SubGroup], Year_Crosstab_List.Subject, Year_Crosstab_List.Date, Sum(Year_Crosstab_List.[Hours]) AS Total FROM Year_Crosstab_List GROUP BY IIf(InStr([Subject]," ")=0,[Subject],Left([Subject],InStr([Subject]," ")-1)), IIf(InStr([Subject],"-")=0,[Subject],Left([Subject],InStr([Subject],"-")-2)), Year_Crosstab_List.Subject, Year_Crosstab_List.Date;
Link To Column Definitions: Year_Crosstab_Add

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


Query_Name: Year_Crosstab_GEN
Query_Type: Append
Query_DateCreated: 05/10/2008 19:11:08
Query_DateChanged: 13/10/2010 20:26:40
Query_SQL: INSERT INTO Year_Crosstab ( Task_Group, [Group], Subgroup, Period, Hours ) SELECT Year_Crosstab_Prime.Task_Group, Year_Crosstab_Prime.Group, Year_Crosstab_Prime.Subgroup, Year_Crosstab_Prime.Period, Year_Crosstab_Prime.Hours FROM Year_Crosstab_Prime;
Link To Column Definitions: Year_Crosstab_GEN

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


Query_Name: Year_Crosstab_List_Add
Query_Type: Append
Query_DateCreated: 26/10/2008 13:35:22
Query_DateChanged: 06/07/2013 17:25:31
Query_SQL: INSERT INTO Year_Crosstab_List ( Subject, Location, [Date], Hours ) SELECT Timesheet.Subject, Timesheet.[Location ], Year([Date]) & "-" & Right(Str(Month([Date])+100),2) AS Period, Timesheet.Hours FROM Timesheet WHERE (((Timesheet.Subject)<>"Subject") AND ((Timesheet.[Location ]) Is Not Null));
Link To Column Definitions: Year_Crosstab_List_Add

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


Query_Name: Year_Crosstab_List_GEN
Query_Type: Append
Query_DateCreated: 15/10/2011 18:49:21
Query_DateChanged: 15/10/2011 18:54:26
Query_SQL: INSERT INTO Year_Crosstab_List SELECT Year_Crosstab_List_Prime.* FROM Year_Crosstab_List_Prime;
Link To Column Definitions: Year_Crosstab_List_GEN

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


Query_Name: Year_Crosstab_Old_GEN
Query_Type: Append
Query_DateCreated: 02/10/2019 22:01:32
Query_DateChanged: 02/10/2019 22:01:32
Query_SQL: INSERT INTO Year_Crosstab_Old SELECT Year_Crosstab.* FROM Year_Crosstab;
Link To Column Definitions: Year_Crosstab_Old_GEN

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


Query_Name: Year_Crosstab_Prime_Add
Query_Type: Append
Query_DateCreated: 24/10/2009 11:42:30
Query_DateChanged: 24/10/2009 11:45:25
Query_SQL: INSERT INTO Year_Crosstab_Prime ( Task_Group, [Group], Subgroup, Period, Hours ) SELECT Year_Crosstab_Prime_Task_Periods.Task_Group, Year_Crosstab_Prime_Task_Periods.Group, Year_Crosstab_Prime_Task_Periods.Subgroup, Year_Crosstab_Prime_Task_Periods.Period, 0 AS Hours FROM Year_Crosstab_Prime_Task_Periods LEFT JOIN Year_Crosstab_Prime ON (Year_Crosstab_Prime_Task_Periods.Period = Year_Crosstab_Prime.Period) AND (Year_Crosstab_Prime_Task_Periods.Subgroup = Year_Crosstab_Prime.Subgroup) AND (Year_Crosstab_Prime_Task_Periods.Group = Year_Crosstab_Prime.Group) AND (Year_Crosstab_Prime_Task_Periods.Task_Group = Year_Crosstab_Prime.Task_Group) WHERE (((Year_Crosstab_Prime.Task_Group) Is Null));
Link To Column Definitions: Year_Crosstab_Prime_Add

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





© Theo Todman, June 2007 - May 2020. Please address any comments on this page to theo@theotodman.com. File output:
Website Maintenance Dashboard
Return to Top of this Page Return to Theo Todman's Philosophy Page Return to Theo Todman's Home Page