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 = Cross-Tab (44 items)

Authors_Summary_CountsCode_Archive_XtabCode_Archive_Xtab_RecentCross_Reference_By_Type
Cross_Reference_Changes_By_TypeHits_Bots_Total_Crosstab_DescendingHits_Pages_Total_CrosstabHits_Pages_Total_Crosstab_Descending
Identity Sources - By Author (Summary)Identity Sources - By Author Within Priority (Summary)Kaprekar_Counts_CountsLanguage_Animadversions_XTab
Language_Animadversions_XTab_Pri2Language_Animadversions_XTab_Pri3Language_Animadversions_XTab_Pri4Ling_Database_Summary_XTab_Dialogue_Latin
Ling_Database_Summary_XTab_Dialogue_NonLatinLing_Database_Summary_XTab_Vocabulary_LatinLing_Database_Summary_XTab_Vocabulary_NonLatinLing_Language_Dialogue_List_All
Ling_Language_Dialogue_List_All_ru_ukLing_Language_Vocab_List_AllLing_Language_Vocab_List_All_LessonSeqLing_Language_Vocab_List_All_LessonSeq_ru_uk
Ling_Language_Vocab_List_All_ru_ukLing_Language_Vocab_Phrase_List_AllLing_Language_Vocab_Phrase_List_All_LessonSeqLing_Language_Vocab_Phrase_List_All_LessonSeq_ru_uk
Ling_Language_Vocab_Phrase_List_All_ru_ukPhotos_Raw_Excluded_InconsistenciesPID_Notes_RL_Category_XtabPID_Notes_Used_By_Thesis_Chapter_List_XTab
PID_Notes_Used_By_Thesis_Chapter_XTabqryPastActualsQuery15Query18
Query4Query5Spider_Scurry_Log_Timings_ListTime_By_Language_Locations
Time_By_LocationsTime_By_MonthTime_By_Month (Grand Summary)Time_By_Month (Summary)

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

Go to top of page

Query_Name: Authors_Summary_Counts
Query_Type: Cross-Tab
Query_DateCreated: 30/12/2014 19:03:38
Query_DateChanged: 30/12/2014 19:03:38
Query_SQL: TRANSFORM Count(Authors_List_Letter_Table.Book_ID) AS CountOfBook_ID SELECT Authors_List_Letter_Table.Author_Name FROM Authors_List_Letter_Table GROUP BY Authors_List_Letter_Table.Author_Name PIVOT Authors_List_Letter_Table.Medium;
Link To Column Definitions: Authors_Summary_Counts

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_Xtab
Query_Type: Cross-Tab
Query_DateCreated: 30/11/2017 17:40:48
Query_DateChanged: 02/12/2017 21:59:36
Query_SQL: TRANSFORM Sum(Len([Code_Archive_Table]![Code])) AS Expr1 SELECT Code_Table.Code_Location, Code_Archive_Table.Procedure_Name FROM Code_Archive_Table INNER JOIN Code_Table ON Code_Archive_Table.Procedure_Name = Code_Table.Procedure_Name GROUP BY Code_Table.Code_Location, Code_Archive_Table.Procedure_Name ORDER BY Code_Archive_Table.Procedure_Name, Code_Archive_Table.Archive_Date DESC PIVOT Code_Archive_Table.Archive_Date;
Link To Column Definitions: Code_Archive_Xtab

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


Query_Name: Code_Archive_Xtab_Recent
Query_Type: Cross-Tab
Query_DateCreated: 01/12/2017 00:20:31
Query_DateChanged: 26/06/2018 19:12:34
Query_SQL: TRANSFORM Sum(Len([Code_Archive_Table]![Code])) AS Expr1 SELECT Code_Table.Code_Location, Code_Archive_Table.Procedure_Name FROM Code_Archive_Table INNER JOIN Code_Table ON Code_Archive_Table.Procedure_Name = Code_Table.Procedure_Name WHERE (((Code_Archive_Table.[Archive_Date])>Now()-365)) GROUP BY Code_Table.Code_Location, Code_Archive_Table.Procedure_Name ORDER BY Code_Archive_Table.Procedure_Name, Int([Archive_Date]) DESC PIVOT Int([Archive_Date]);
Link To Column Definitions: Code_Archive_Xtab_Recent

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_Type
Query_Type: Cross-Tab
Query_DateCreated: 27/08/2015 13:13:46
Query_DateChanged: 25/06/2020 13:59:50
Query_SQL: TRANSFORM Count(Cross_Reference.Calling_NameRef) AS CountOfCalling_NameRef SELECT [Calling_Type] & IIf([Calling_Timestamp]=0,"","_A") AS [Type_Calling ↓], "" AS [Type_Called →] FROM Cross_Reference GROUP BY [Calling_Type] & IIf([Calling_Timestamp]=0,"","_A"), "" PIVOT [Called_Type] & IIf([Called_Timestamp]=0,"","_A");
Link To Column Definitions: Cross_Reference_By_Type

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_Type
Query_Type: Cross-Tab
Query_DateCreated: 24/05/2020 22:26:51
Query_DateChanged: 25/06/2020 13:40:16
Query_SQL: TRANSFORM Count(Cross_Reference_Changes.Calling_NameRef) AS CountOfCalling_NameRef SELECT [Calling_Type] & IIf([Calling_Timestamp]=0,"","_A") AS [Type_Calling ↓], "" AS [Type_Called →] FROM Cross_Reference_Changes GROUP BY [Calling_Type] & IIf([Calling_Timestamp]=0,"","_A"), "" PIVOT [Called_Type] & IIf([Called_Timestamp]=0,"","_A");
Link To Column Definitions: Cross_Reference_Changes_By_Type

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_Crosstab_Descending
Query_Type: Cross-Tab
Query_DateCreated: 29/03/2019 00:34:00
Query_DateChanged: 17/10/2022 17:55:50
Query_SQL: TRANSFORM Sum(Hits_Bots_By_URL_Key.Hits) AS SumOfHits SELECT Hits_Bots_Total.URL_Key, Round([Hits_Bots_Total]![Hits]/[Months],0) AS [Average Hits], Hits_Bots_Total.Months, Hits_Bots_Total.Hits, Hits_Bots_Total.KBytes FROM Hits_Bots_By_URL_Key INNER JOIN Hits_Bots_Total ON Hits_Bots_By_URL_Key.URL_Key = Hits_Bots_Total.URL_Key WHERE (((Hits_Bots_Total.Hits)>99)) GROUP BY Hits_Bots_Total.URL_Key, Round([Hits_Bots_Total]![Hits]/[Months],0), Hits_Bots_Total.Months, Hits_Bots_Total.Hits, Hits_Bots_Total.KBytes ORDER BY Round([Hits_Bots_Total]![Hits]/[Months],0) DESC , IIf([Year]=Year(Now()),[Year] & "-" & Right(100+[Month],2),[Year]) DESC PIVOT IIf([Year]=Year(Now()),[Year] & "-" & Right(100+[Month],2),[Year]);
Link To Column Definitions: Hits_Bots_Total_Crosstab_Descending

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_Crosstab
Query_Type: Cross-Tab
Query_DateCreated: 29/03/2019 00:34:00
Query_DateChanged: 29/03/2019 00:34:01
Query_SQL: TRANSFORM Sum(Hits_Pages.Hits) AS SumOfHits SELECT Hits_Pages_Total.URL, Hits_Pages_Total.Months, Hits_Pages_Total.Hits, Hits_Pages_Total.KBytes FROM Hits_Pages_Total INNER JOIN Hits_Pages ON Hits_Pages_Total.URL = Hits_Pages.URL GROUP BY Hits_Pages_Total.URL, Hits_Pages_Total.Months, Hits_Pages_Total.Hits, Hits_Pages_Total.KBytes ORDER BY Hits_Pages_Total.URL, [Year] & "-" & Right(100+[Month],2) DESC PIVOT [Year] & "-" & Right(100+[Month],2);
Link To Column Definitions: Hits_Pages_Total_Crosstab

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


Query_Name: Hits_Pages_Total_Crosstab_Descending
Query_Type: Cross-Tab
Query_DateCreated: 29/03/2019 00:34:01
Query_DateChanged: 17/10/2022 17:46:31
Query_SQL: TRANSFORM Sum(Hits_Pages.Hits) AS SumOfHits SELECT Hits_Pages_Total.URL, Hits_Pages_Total.Months, Hits_Pages_Total.Hits, Hits_Pages_Total.KBytes FROM Hits_Pages_Total INNER JOIN Hits_Pages ON Hits_Pages_Total.URL = Hits_Pages.URL WHERE (((Hits_Pages_Total.Hits)>99)) GROUP BY Hits_Pages_Total.URL, Hits_Pages_Total.Months, Hits_Pages_Total.Hits, Hits_Pages_Total.KBytes ORDER BY Hits_Pages_Total.Hits DESC , IIf([Year]=Year(Now()),[Year] & "-" & Right(100+[Month],2),[Year]) DESC PIVOT IIf([Year]=Year(Now()),[Year] & "-" & Right(100+[Month],2),[Year]);
Link To Column Definitions: Hits_Pages_Total_Crosstab_Descending

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


Query_Name: Identity Sources - By Author (Summary)
Query_Type: Cross-Tab
Query_DateCreated: 24/09/2006 12:13:32
Query_DateChanged: 24/09/2006 12:19:10
Query_SQL: TRANSFORM Sum(qrySources.Estimate) AS SumOfEstimate SELECT qrySources.Author, qrySources.Priority FROM qrySources LEFT JOIN [Books - Papers Catalogued] ON (qrySources.IDs = [Books - Papers Catalogued].IDs) AND (qrySources.[A+T] = [Books - Papers Catalogued].[A+T]) WHERE (((qrySources.Topic)="identity") AND (([Books - Papers Catalogued].IDs) Is Null)) OR ((([Books - Papers Catalogued].IDs) Is Null) AND ((qrySources.Topic2)="identity")) OR ((([Books - Papers Catalogued].IDs) Is Null) AND ((qrySources.Topic3)="identity")) GROUP BY qrySources.Author, qrySources.Priority ORDER BY qrySources.Author, qrySources.Priority PIVOT IIf([Status] Is Null Or [Status]="","To Read",[Status]);
Link To Column Definitions: Identity Sources - By Author (Summary)

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


Query_Name: Identity Sources - By Author Within Priority (Summary)
Query_Type: Cross-Tab
Query_DateCreated: 09/10/2005 14:16:05
Query_DateChanged: 24/09/2006 12:19:25
Query_SQL: TRANSFORM Sum(qrySources.Estimate) AS SumOfEstimate SELECT qrySources.Priority, qrySources.Author FROM qrySources LEFT JOIN [Books - Papers Catalogued] ON (qrySources.IDs = [Books - Papers Catalogued].IDs) AND (qrySources.[A+T] = [Books - Papers Catalogued].[A+T]) WHERE (((qrySources.Topic)="identity") AND (([Books - Papers Catalogued].IDs) Is Null)) OR ((([Books - Papers Catalogued].IDs) Is Null) AND ((qrySources.Topic2)="identity")) OR ((([Books - Papers Catalogued].IDs) Is Null) AND ((qrySources.Topic3)="identity")) GROUP BY qrySources.Priority, qrySources.Author ORDER BY qrySources.Priority, qrySources.Author PIVOT IIf([Status] Is Null Or [Status]="","To Read",[Status]);
Link To Column Definitions: Identity Sources - By Author Within Priority (Summary)

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


Query_Name: Kaprekar_Counts_Counts
Query_Type: Cross-Tab
Query_DateCreated: 04/06/2020 20:54:55
Query_DateChanged: 04/06/2020 20:54:55
Query_SQL: TRANSFORM Count(Kaprekar_Counts.ID) AS CountOfID SELECT Kaprekar_Counts.Length, Kaprekar_Counts.Final_Number FROM Kaprekar_Counts GROUP BY Kaprekar_Counts.Length, Kaprekar_Counts.Final_Number PIVOT Kaprekar_Counts.Iteration_Count;
Link To Column Definitions: Kaprekar_Counts_Counts

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


Query_Name: Language_Animadversions_XTab
Query_Type: Cross-Tab
Query_DateCreated: 07/11/2020 11:41:17
Query_DateChanged: 26/11/2020 13:34:37
Query_SQL: TRANSFORM Count(Language_Animadversions.ID) AS CountOfID SELECT "Counts →" AS [Language →], Language_Animadversions_Counts.CountOfLanguage AS [Total Languages], Count(Language_Animadversions.ID) AS [Total Animadversions] FROM Language_Animadversions_Counts, Language_Animadversions INNER JOIN Language_Location_Primer ON Language_Animadversions.Language = Language_Location_Primer.Language_Key WHERE (((Language_Location_Primer.Priority)=1) AND ((Language_Animadversions_Counts.Priority)=1)) GROUP BY "Counts →", Language_Animadversions_Counts.CountOfLanguage PIVOT [Language_Animadversions]![Language] & "++1313#" & [Language_Animadversions]![Language] & "++";
Link To Column Definitions: Language_Animadversions_XTab

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_XTab_Pri2
Query_Type: Cross-Tab
Query_DateCreated: 26/11/2020 13:36:41
Query_DateChanged: 26/11/2020 13:36:50
Query_SQL: TRANSFORM Count(Language_Animadversions.ID) AS CountOfID SELECT "Counts →" AS [Language →], Language_Animadversions_Counts.CountOfLanguage AS [Total Languages], Count(Language_Animadversions.ID) AS [Total Animadversions] FROM Language_Animadversions_Counts, Language_Animadversions INNER JOIN Language_Location_Primer ON Language_Animadversions.Language = Language_Location_Primer.Language_Key WHERE (((Language_Location_Primer.Priority)=2) AND ((Language_Animadversions_Counts.Priority)=2)) GROUP BY "Counts →", Language_Animadversions_Counts.CountOfLanguage PIVOT [Language_Animadversions]![Language] & "++1313#" & [Language_Animadversions]![Language] & "++";
Link To Column Definitions: Language_Animadversions_XTab_Pri2

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_XTab_Pri3
Query_Type: Cross-Tab
Query_DateCreated: 02/03/2022 13:04:38
Query_DateChanged: 02/03/2022 13:05:30
Query_SQL: TRANSFORM Count(Language_Animadversions.ID) AS CountOfID SELECT "Counts →" AS [Language →], Language_Animadversions_Counts.CountOfLanguage AS [Total Languages], Count(Language_Animadversions.ID) AS [Total Animadversions] FROM Language_Animadversions_Counts, Language_Animadversions INNER JOIN Language_Location_Primer ON Language_Animadversions.Language = Language_Location_Primer.Language_Key WHERE (((Language_Location_Primer.Priority)=3) AND ((Language_Animadversions_Counts.Priority)=3)) GROUP BY "Counts →", Language_Animadversions_Counts.CountOfLanguage PIVOT [Language_Animadversions]![Language] & "++1313#" & [Language_Animadversions]![Language] & "++";
Link To Column Definitions: Language_Animadversions_XTab_Pri3

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_XTab_Pri4
Query_Type: Cross-Tab
Query_DateCreated: 22/10/2022 18:58:53
Query_DateChanged: 22/10/2022 19:09:04
Query_SQL: TRANSFORM Count(Language_Animadversions.ID) AS CountOfID SELECT "Counts →" AS [Language →], Language_Animadversions_Counts.CountOfLanguage AS [Total Languages], Count(Language_Animadversions.ID) AS [Total Animadversions] FROM Language_Animadversions_Counts, Language_Animadversions INNER JOIN Language_Location_Primer ON Language_Animadversions.Language = Language_Location_Primer.Language_Key WHERE (((Language_Location_Primer.Priority)=4) AND ((Language_Animadversions_Counts.Priority)=4)) GROUP BY "Counts →", Language_Animadversions_Counts.CountOfLanguage PIVOT [Language_Animadversions]![Language] & "++1313#" & [Language_Animadversions]![Language] & "++";
Link To Column Definitions: Language_Animadversions_XTab_Pri4

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


Query_Name: Ling_Database_Summary_XTab_Dialogue_Latin
Query_Type: Cross-Tab
Query_DateCreated: 14/04/2021 15:46:12
Query_DateChanged: 15/04/2021 14:55:46
Query_SQL: TRANSFORM Sum(Ling_Lesson_Counts.Lessons) AS SumOfLessons SELECT Ling_Lesson_Counts.Type FROM Ling_Lesson_Counts INNER JOIN Language_Location_Primer ON Ling_Lesson_Counts.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Lesson_Counts.Type)="Dialogue") AND ((Language_Location_Primer.[Non_Latin_Script?])=False)) GROUP BY Ling_Lesson_Counts.Type PIVOT [Language_Location_Primer]![Language_Key] & "++1323#" & [Language_Location_Primer]![Language_Key] & "Dialogue++";
Link To Column Definitions: Ling_Database_Summary_XTab_Dialogue_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_Database_Summary_XTab_Dialogue_NonLatin
Query_Type: Cross-Tab
Query_DateCreated: 14/04/2021 15:43:48
Query_DateChanged: 16/04/2021 00:04:53
Query_SQL: TRANSFORM Sum(Ling_Lesson_Counts.Lessons) AS SumOfLessons SELECT Ling_Lesson_Counts.Type FROM Ling_Lesson_Counts INNER JOIN Language_Location_Primer ON Ling_Lesson_Counts.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Lesson_Counts.Type)="Dialogue") AND ((Language_Location_Primer.[Non_Latin_Script?])=True)) GROUP BY Ling_Lesson_Counts.Type PIVOT [Language_Location_Primer]![Language_Key] & "++1324#" & [Language_Location_Primer]![Language_Key] & "Dialogue++";
Link To Column Definitions: Ling_Database_Summary_XTab_Dialogue_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_Database_Summary_XTab_Vocabulary_Latin
Query_Type: Cross-Tab
Query_DateCreated: 13/04/2021 23:58:25
Query_DateChanged: 16/04/2021 00:05:41
Query_SQL: TRANSFORM Sum(Ling_Lesson_Counts.Lessons) AS SumOfLessons SELECT Ling_Lesson_Counts.Type FROM Ling_Lesson_Counts INNER JOIN Language_Location_Primer ON Ling_Lesson_Counts.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Lesson_Counts.Type)="Vocabulary") AND ((Language_Location_Primer.[Non_Latin_Script?])=False)) GROUP BY Ling_Lesson_Counts.Type PIVOT [Language_Location_Primer]![Language] & "++1321#" & [Language_Location_Primer]![Language_Key] & "++";
Link To Column Definitions: Ling_Database_Summary_XTab_Vocabulary_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_Database_Summary_XTab_Vocabulary_NonLatin
Query_Type: Cross-Tab
Query_DateCreated: 13/04/2021 23:21:25
Query_DateChanged: 15/04/2021 14:57:15
Query_SQL: TRANSFORM Sum(Ling_Lesson_Counts.Lessons) AS SumOfLessons SELECT Ling_Lesson_Counts.Type FROM Ling_Lesson_Counts INNER JOIN Language_Location_Primer ON Ling_Lesson_Counts.Language = Language_Location_Primer.Language_Key WHERE (((Ling_Lesson_Counts.Type)="Vocabulary") AND ((Language_Location_Primer.[Non_Latin_Script?])=True)) GROUP BY Ling_Lesson_Counts.Type PIVOT [Language_Location_Primer]![Language_Key] & "++1322#" & [Language_Location_Primer]![Language_Key] & "++";
Link To Column Definitions: Ling_Database_Summary_XTab_Vocabulary_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_Dialogue_List_All
Query_Type: Cross-Tab
Query_DateCreated: 16/04/2021 23:36:36
Query_DateChanged: 17/04/2021 00:04:31
Query_SQL: TRANSFORM First(IIf([Non_Latin_Script?]=True,[Transliteration] & "<hr>","") & ([Phrase])) AS y SELECT Ling_Language_Dialogue_List_All_Prelist.Lesson, Ling_Language_Dialogue_List_All_Prelist.Dialogue, Ling_Language_Dialogue_List_All_Prelist.ID, Ling_Language_Dialogue_List_All_Prelist.[A/B], Ling_Language_Dialogue_List_All_Prelist.English FROM Ling_Language_Dialogue_List_All_Prelist GROUP BY Ling_Language_Dialogue_List_All_Prelist.Lesson, Ling_Language_Dialogue_List_All_Prelist.Dialogue, Ling_Language_Dialogue_List_All_Prelist.ID, Ling_Language_Dialogue_List_All_Prelist.[A/B], Ling_Language_Dialogue_List_All_Prelist.English ORDER BY Ling_Language_Dialogue_List_All_Prelist.Lesson, Ling_Language_Dialogue_List_All_Prelist.Dialogue, Ling_Language_Dialogue_List_All_Prelist.ID PIVOT [Lang_Group] & [Language];
Link To Column Definitions: Ling_Language_Dialogue_List_All

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_All_ru_uk
Query_Type: Cross-Tab
Query_DateCreated: 01/04/2022 00:04:26
Query_DateChanged: 22/06/2023 18:09:23
Query_SQL: TRANSFORM First(IIf([Non_Latin_Script?]=True,[Transliteration] & "<hr>","") & ([Phrase])) AS y SELECT Ling_Language_Dialogue_List_All_Prelist.Lesson, Ling_Language_Dialogue_List_All_Prelist.Dialogue, Ling_Language_Dialogue_List_All_Prelist.ID, Ling_Language_Dialogue_List_All_Prelist.[A/B], Ling_Language_Dialogue_List_All_Prelist.English FROM Ling_Language_Dialogue_List_All_Prelist WHERE (((Ling_Language_Dialogue_List_All_Prelist.Language)="Russian" Or (Ling_Language_Dialogue_List_All_Prelist.Language)="Ukrainian" Or (Ling_Language_Dialogue_List_All_Prelist.Language)="Polish")) GROUP BY Ling_Language_Dialogue_List_All_Prelist.Lesson, Ling_Language_Dialogue_List_All_Prelist.Dialogue, Ling_Language_Dialogue_List_All_Prelist.ID, Ling_Language_Dialogue_List_All_Prelist.[A/B], Ling_Language_Dialogue_List_All_Prelist.English ORDER BY Ling_Language_Dialogue_List_All_Prelist.Lesson, Ling_Language_Dialogue_List_All_Prelist.Dialogue, Ling_Language_Dialogue_List_All_Prelist.ID, Ling_Language_Dialogue_List_All_Prelist.Language DESC PIVOT Ling_Language_Dialogue_List_All_Prelist.Language;
Link To Column Definitions: Ling_Language_Dialogue_List_All_ru_uk

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
Query_Type: Cross-Tab
Query_DateCreated: 14/04/2021 21:27:17
Query_DateChanged: 11/05/2021 11:29:15
Query_SQL: TRANSFORM First([Vocabulary] & IIf([Non_Latin_Script?]=True,"<br>" & [Transliteration],"")) AS y SELECT Ling_Language_Vocab_List_All_Prelist.Category, Ling_Language_Vocab_List_All_Prelist.English FROM Ling_Language_Vocab_List_All_Prelist GROUP BY Ling_Language_Vocab_List_All_Prelist.Category, Ling_Language_Vocab_List_All_Prelist.English, Ling_Language_Vocab_List_All_Prelist.Sort ORDER BY Ling_Language_Vocab_List_All_Prelist.Category, Ling_Language_Vocab_List_All_Prelist.Sort PIVOT [Lang_Group] & [Language];
Link To Column Definitions: Ling_Language_Vocab_List_All

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_LessonSeq
Query_Type: Cross-Tab
Query_DateCreated: 27/08/2021 20:44:39
Query_DateChanged: 27/08/2021 20:47:09
Query_SQL: TRANSFORM First([Vocabulary] & IIf([Non_Latin_Script?]=True,"<br>" & [Transliteration],"")) AS y SELECT Ling_Language_Vocab_List_All_Prelist.Lesson, Ling_Language_Vocab_List_All_Prelist.English FROM Ling_Language_Vocab_List_All_Prelist GROUP BY Ling_Language_Vocab_List_All_Prelist.Lesson, Ling_Language_Vocab_List_All_Prelist.Vocab_ID, Ling_Language_Vocab_List_All_Prelist.English, Ling_Language_Vocab_List_All_Prelist.Sort ORDER BY Ling_Language_Vocab_List_All_Prelist.Lesson, Ling_Language_Vocab_List_All_Prelist.Vocab_ID, Ling_Language_Vocab_List_All_Prelist.Sort PIVOT [Lang_Group] & [Language];
Link To Column Definitions: Ling_Language_Vocab_List_All_LessonSeq

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_LessonSeq_ru_uk
Query_Type: Cross-Tab
Query_DateCreated: 28/03/2022 14:31:54
Query_DateChanged: 27/05/2023 20:08:44
Query_SQL: TRANSFORM First([Vocabulary] & IIf([Non_Latin_Script?]=True,"<hr>" & [Transliteration],"")) AS y SELECT Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Lesson, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.English FROM Ling_Language_Vocab_List_All_Prelist_1_ru_uk GROUP BY Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Lesson, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Vocab_ID, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.English, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Sort ORDER BY Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Lesson, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Vocab_ID, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Sort, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Language DESC PIVOT Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Language;
Link To Column Definitions: Ling_Language_Vocab_List_All_LessonSeq_ru_uk

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_ru_uk
Query_Type: Cross-Tab
Query_DateCreated: 28/03/2022 14:37:58
Query_DateChanged: 27/05/2023 20:09:25
Query_SQL: TRANSFORM First([Vocabulary] & IIf([Non_Latin_Script?]=True,"<hr>" & [Transliteration],"")) AS y SELECT Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Category, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.English FROM Ling_Language_Vocab_List_All_Prelist_1_ru_uk GROUP BY Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Category, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.English, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Sort ORDER BY Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Category, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Sort, Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Language DESC PIVOT Ling_Language_Vocab_List_All_Prelist_1_ru_uk.Language;
Link To Column Definitions: Ling_Language_Vocab_List_All_ru_uk

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
Query_Type: Cross-Tab
Query_DateCreated: 16/04/2021 21:43:15
Query_DateChanged: 27/05/2023 20:03:16
Query_SQL: TRANSFORM First([Phrase] & IIf([Non_Latin_Script?]=True,"<hr>" & [Transliteration],"") & IIf([Language]="English Phrase","<hr><b>" & [Transliteration] & "</b>","")) AS y SELECT Ling_Language_Vocab_Phrase_List_All_Prelist.Category, Ling_Language_Vocab_Phrase_List_All_Prelist.[English Vocabulary], Ling_Language_Vocab_Phrase_List_All_Prelist.[English Phrase] FROM Ling_Language_Vocab_Phrase_List_All_Prelist WHERE (((Ling_Language_Vocab_Phrase_List_All_Prelist.[English Phrase])<>"<b></b>")) GROUP BY Ling_Language_Vocab_Phrase_List_All_Prelist.Category, Ling_Language_Vocab_Phrase_List_All_Prelist.[English Vocabulary], Ling_Language_Vocab_Phrase_List_All_Prelist.[English Phrase], Ling_Language_Vocab_Phrase_List_All_Prelist.Sort ORDER BY Ling_Language_Vocab_Phrase_List_All_Prelist.Category, Ling_Language_Vocab_Phrase_List_All_Prelist.Sort PIVOT [Lang_Group] & [Language];
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All

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_LessonSeq
Query_Type: Cross-Tab
Query_DateCreated: 27/08/2021 22:00:32
Query_DateChanged: 27/05/2023 19:44:35
Query_SQL: TRANSFORM First([Phrase] & IIf([Non_Latin_Script?]=True,"<hr>" & [Transliteration],"") & IIf([Language]="English Phrase","<hr><b>" & [Transliteration] & "</b>","")) AS y SELECT Ling_Language_Vocab_Phrase_List_All_Prelist.Lesson, Ling_Language_Vocab_Phrase_List_All_Prelist.[English Vocabulary], Ling_Language_Vocab_Phrase_List_All_Prelist.[English Phrase] FROM Ling_Language_Vocab_Phrase_List_All_Prelist WHERE (((Ling_Language_Vocab_Phrase_List_All_Prelist.[English Phrase])<>"<b></b>")) GROUP BY Ling_Language_Vocab_Phrase_List_All_Prelist.Lesson, Ling_Language_Vocab_Phrase_List_All_Prelist.Vocab_ID, Ling_Language_Vocab_Phrase_List_All_Prelist.[English Vocabulary], Ling_Language_Vocab_Phrase_List_All_Prelist.[English Phrase], Ling_Language_Vocab_Phrase_List_All_Prelist.Sort ORDER BY Ling_Language_Vocab_Phrase_List_All_Prelist.Lesson, Ling_Language_Vocab_Phrase_List_All_Prelist.Vocab_ID, Ling_Language_Vocab_Phrase_List_All_Prelist.Sort PIVOT [Lang_Group] & [Language];
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All_LessonSeq

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_LessonSeq_ru_uk
Query_Type: Cross-Tab
Query_DateCreated: 28/03/2022 19:22:27
Query_DateChanged: 27/05/2023 20:09:52
Query_SQL: TRANSFORM First([Phrase] & IIf([Non_Latin_Script?]=True,"<hr>" & [Transliteration],"") & IIf([Language]="English Phrase","<hr><b>" & [Transliteration] & "</b>","")) AS y SELECT Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Lesson, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Vocabulary], Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Phrase] FROM Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk WHERE (((Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Phrase])<>"<b></b>")) GROUP BY Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Lesson, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Vocab_ID, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Vocabulary], Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Phrase], Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Sort ORDER BY Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Lesson, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Vocab_ID, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Sort, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Language DESC PIVOT Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Language;
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All_LessonSeq_ru_uk

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_ru_uk
Query_Type: Cross-Tab
Query_DateCreated: 28/03/2022 19:52:15
Query_DateChanged: 27/05/2023 20:10:09
Query_SQL: TRANSFORM First([Phrase] & IIf([Non_Latin_Script?]=True,"<hr>" & [Transliteration],"") & IIf([Language]="English Phrase","<hr><b>" & [Transliteration] & "</b>","")) AS y SELECT Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Category, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Vocabulary], Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Phrase] FROM Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk WHERE (((Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Phrase])<>"<b></b>")) GROUP BY Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Category, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Vocabulary], Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.[English Phrase], Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Sort ORDER BY Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Category, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Sort, Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Language DESC PIVOT Ling_Language_Vocab_Phrase_List_All_Prelist_1_ru_uk.Language;
Link To Column Definitions: Ling_Language_Vocab_Phrase_List_All_ru_uk

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


Query_Name: Photos_Raw_Excluded_Inconsistencies
Query_Type: Cross-Tab
Query_DateCreated: 16/02/2019 13:05:01
Query_DateChanged: 16/02/2019 13:07:42
Query_SQL: TRANSFORM Count(Photos_Raw.Photo_FileName) AS CountOfPhoto_FileName SELECT Photos_Raw.Link_Key, Photo_Raw_Excluded_Link_Keys.Photo_Type FROM Photos_Raw INNER JOIN Photo_Raw_Excluded_Link_Keys ON (Photos_Raw.Photo_Type = Photo_Raw_Excluded_Link_Keys.Photo_Type) AND (Photos_Raw.Link_Key = Photo_Raw_Excluded_Link_Keys.Link_Key) GROUP BY Photos_Raw.Link_Key, Photo_Raw_Excluded_Link_Keys.Photo_Type ORDER BY Photos_Raw.Link_Key PIVOT Photos_Raw.[Exclude?];
Link To Column Definitions: Photos_Raw_Excluded_Inconsistencies

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: PID_Notes_RL_Category_Xtab
Query_Type: Cross-Tab
Query_DateCreated: 31/03/2021 09:51:16
Query_DateChanged: 31/03/2021 11:07:26
Query_SQL: TRANSFORM Count(PID_Note_Reading_Lists.Note_ID) AS CountOfNote_ID SELECT "[" & [Note_Title] & "]++" & [Note_ID] & "++" AS [Note] FROM PID_Note_Reading_Lists WHERE (((PID_Note_Reading_Lists.[Suppress?])=False)) GROUP BY "[" & [Note_Title] & "]++" & [Note_ID] & "++" ORDER BY "[" & [Note_Title] & "]++" & [Note_ID] & "++" PIVOT IIf([Category] Is Null,"Null",IIf([Category] & ""="","Blank",IIf([Category] & ""="Uncategorised","'Uncategorised'",IIf([Category] & ""="General","'General'","Other"))));
Link To Column Definitions: PID_Notes_RL_Category_Xtab

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


Query_Name: PID_Notes_Used_By_Thesis_Chapter_List_XTab
Query_Type: Cross-Tab
Query_DateCreated: 11/03/2021 15:45:34
Query_DateChanged: 11/08/2021 19:51:56
Query_SQL: TRANSFORM Count(Thesis_Chapters.ID) AS CountOfID SELECT "[" & [Notes_1]![Item_Title] & "]++" & [Notes_1]![ID] & "++" AS [Called Note] FROM (Thesis_Note_XRef INNER JOIN Thesis_Chapters ON Thesis_Note_XRef.Thesis_Chapter_Note_ID = Thesis_Chapters.ID) INNER JOIN Notes AS Notes_1 ON Thesis_Note_XRef.PID_Note_ID = Notes_1.ID WHERE (((Notes_1.Item_Title) Not Like "*thesis*") AND ((Thesis_Note_XRef.[Exclude?])=False)) GROUP BY "[" & [Notes_1]![Item_Title] & "]++" & [Notes_1]![ID] & "++" ORDER BY "[" & [Notes_1]![Item_Title] & "]++" & [Notes_1]![ID] & "++" PIVOT [Chapter] & "++" & [Thesis_Chapters]![ID] & "++";
Link To Column Definitions: PID_Notes_Used_By_Thesis_Chapter_List_XTab

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


Query_Name: PID_Notes_Used_By_Thesis_Chapter_XTab
Query_Type: Cross-Tab
Query_DateCreated: 04/02/2021 00:58:16
Query_DateChanged: 11/03/2021 19:18:29
Query_SQL: TRANSFORM Max(1) AS ID SELECT "[" & [Notes_1]![Item_Title] & "]++" & [Notes_1]![ID] & "++" AS [Called Note] FROM (Cross_Reference INNER JOIN Notes AS Notes_1 ON Cross_Reference.Called_ID = Notes_1.ID) INNER JOIN Thesis_Chapters ON Cross_Reference.Calling_ID = Thesis_Chapters.ID WHERE (((Notes_1.Item_Title) Not Like "*thesis*") AND ((Cross_Reference.Calling_ID)<>[Called_ID]) AND ((Notes_1.Note_Group)=1) AND ((Cross_Reference.Calling_Type)="N") AND ((Cross_Reference.Called_Type)="N") AND ((Cross_Reference.Calling_Timestamp)=0) AND ((Cross_Reference.Called_Timestamp)=0)) GROUP BY "[" & [Notes_1]![Item_Title] & "]++" & [Notes_1]![ID] & "++" ORDER BY "[" & [Notes_1]![Item_Title] & "]++" & [Notes_1]![ID] & "++" PIVOT [Chapter] & "++" & [Thesis_Chapters]![ID] & "++";
Link To Column Definitions: PID_Notes_Used_By_Thesis_Chapter_XTab

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


Query_Name: qryPastActuals
Query_Type: Cross-Tab
Query_DateCreated: 07/01/2013 16:08:44
Query_DateChanged: 07/01/2013 16:16:27
Query_SQL: TRANSFORM Sum(Year_Crosstab.Hours) AS SumOfHours SELECT Year_Crosstab.Group AS Project, qryActualvsPlan.[YTD Actuals], qryActualvsPlan.[Avge Year Plan Outstanding] FROM Year_Crosstab INNER JOIN qryActualvsPlan ON Year_Crosstab.Group = qryActualvsPlan.Project WHERE (((Year_Crosstab.Period) Like "*/*")) GROUP BY Year_Crosstab.Group, qryActualvsPlan.[YTD Actuals], qryActualvsPlan.[Avge Year Plan Outstanding] ORDER BY Year_Crosstab.Group PIVOT Year_Crosstab.Period;
Link To Column Definitions: qryPastActuals

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


Query_Name: Query15
Query_Type: Cross-Tab
Query_DateCreated: 23/06/2019 23:43:41
Query_DateChanged: 23/06/2019 23:43:41
Query_SQL: TRANSFORM Sum([Year_Crosstab].[Hours ]) AS Hours SELECT Average_Plans.Project, Average_Plans.[Average This Qtr Plan] AS [Planned Weekly Hours], Round([Average YTD Plan],2) AS [Planned YTD %age], 0 AS [Planned QTD %age], Sum(0) AS [QTD Actual %], Sum(0) AS [YTD Actual %], Sum(0) AS [QTD Actual Hours], Sum(Year_Crosstab.Hours) AS [YTD Actual Hours] FROM Average_Plans LEFT JOIN Year_Crosstab ON Average_Plans.Project = Year_Crosstab.Group WHERE (((Year_Crosstab.Period)>="2018-10" And (Year_Crosstab.Period)<="2019-09")) OR (((Year_Crosstab.Period) Is Null)) GROUP BY Average_Plans.Project, Average_Plans.[Average This Qtr Plan], Round([Average YTD Plan],2) ORDER BY Average_Plans.Project PIVOT Year_Crosstab.Period;
Link To Column Definitions: Query15

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


Query_Name: Query18
Query_Type: Cross-Tab
Query_DateCreated: 13/06/2020 00:11:17
Query_DateChanged: 13/06/2020 00:37:33
Query_SQL: TRANSFORM Sum([Year_Crosstab].[Hours ]) AS Hours SELECT Average_Plans.Project, Average_Plans.[Average This Qtr Plan] AS [Planned Weekly Hours], Round([Average YTD Plan],2) AS [Planned YTD %age], 0 AS [Planned QTD %age], Sum(0) AS [QTD Actual %], Sum(0) AS [YTD Actual %], Sum(0) AS [QTD Actual Hours], Sum(Year_Crosstab.Hours) AS [YTD Actual Hours] FROM Average_Plans LEFT JOIN Year_Crosstab ON Average_Plans.Project = Year_Crosstab.Group WHERE (((Year_Crosstab.Period)>="2019-10" And (Year_Crosstab.Period)<="2020-09")) OR (((Year_Crosstab.Period) Is Null)) GROUP BY Average_Plans.Project, Average_Plans.[Average This Qtr Plan], Round([Average YTD Plan],2) ORDER BY Average_Plans.Project PIVOT Year_Crosstab.Period;
Link To Column Definitions: Query18

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


Query_Name: Query4
Query_Type: Cross-Tab
Query_DateCreated: 30/04/2015 10:18:21
Query_DateChanged: 01/05/2015 12:38:54
Query_SQL: TRANSFORM Sum([Year_Crosstab].[Hours ]) AS Hours SELECT Average_Plans.Project, Average_Plans.[Average This Qtr Plan] AS [Planned Weekly Hours], Round([Average YTD Plan],2) AS [Planned YTD %age], 0 AS [Planned QTD %age], Sum(0) AS [QTD Actual %], Sum(0) AS [YTD Actual %], Sum(0) AS [QTD Actual Hours], Sum(Year_Crosstab.Hours) AS [YTD Actual Hours] FROM Average_Plans LEFT JOIN Year_Crosstab ON Average_Plans.Project = Year_Crosstab.Group WHERE (((Year_Crosstab.Period)>="2014-10" And (Year_Crosstab.Period)<="2015-09")) OR (((Year_Crosstab.Period) Is Null)) GROUP BY Average_Plans.Project, Average_Plans.[Average This Qtr Plan], Round([Average YTD Plan],2) ORDER BY Average_Plans.Project PIVOT Year_Crosstab.Period;
Link To Column Definitions: Query4

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


Query_Name: Query5
Query_Type: Cross-Tab
Query_DateCreated: 01/05/2015 16:10:05
Query_DateChanged: 01/05/2015 16:10:05
Query_SQL: TRANSFORM Sum([Year_Crosstab].[Hours ]) AS Hours SELECT Average_Plans.Project, Average_Plans.[Average This Qtr Plan] AS [Planned Weekly Hours], Round(Average_Plans.[Average YTD Plan],4) AS [Planned %age], Sum(0) AS [QTD Actual %], Sum(0) AS [YTD Actual %], Sum(0) AS [QTD Actual Hours], Sum(Year_Crosstab.Hours) AS [YTD Actual Hours] FROM Average_Plans LEFT JOIN Year_Crosstab ON Average_Plans.Project = Year_Crosstab.Group WHERE (((Year_Crosstab.Period)>="2014-10" And (Year_Crosstab.Period)<="2015-09")) OR (((Year_Crosstab.Period) Is Null)) GROUP BY Average_Plans.Project, Average_Plans.[Average This Qtr Plan], Round([Average YTD Plan],4) ORDER BY Average_Plans.Project PIVOT Year_Crosstab.Period;
Link To Column Definitions: Query5

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


Query_Name: Spider_Scurry_Log_Timings_List
Query_Type: Cross-Tab
Query_DateCreated: 08/06/2021 19:32:22
Query_DateChanged: 01/08/2021 22:57:42
Query_SQL: TRANSFORM Sum(Round([Scurry_Time]*24*60*60,0)) AS Seconds SELECT Spider_Scurry_Log_Timings.DirectoryName FROM Spider_Scurry_Log_Timings GROUP BY Spider_Scurry_Log_Timings.DirectoryName ORDER BY Spider_Scurry_Log_Timings.DirectoryName, Spider_Scurry_Log_Timings.Scurry_Start_Date DESC PIVOT Spider_Scurry_Log_Timings.Scurry_Start_Date;
Link To Column Definitions: Spider_Scurry_Log_Timings_List

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_Language_Locations
Query_Type: Cross-Tab
Query_DateCreated: 04/07/2008 21:07:21
Query_DateChanged: 27/10/2011 11:23:41
Query_SQL: TRANSFORM Sum(Time_By_Language_Locations_1.SumOfHours) AS SumOfSumOfHours SELECT Time_By_Language_Locations_1.Language, Sum(Time_By_Language_Locations_1.SumOfHours) AS Total FROM Time_By_Language_Locations_1 WHERE (((Time_By_Language_Locations_1.SumOfHours)>0.000001)) GROUP BY Time_By_Language_Locations_1.Language PIVOT Time_By_Language_Locations_1.[Location ];
Link To Column Definitions: Time_By_Language_Locations

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


Query_Name: Time_By_Locations
Query_Type: Cross-Tab
Query_DateCreated: 24/10/2009 19:57:14
Query_DateChanged: 27/09/2017 09:58:39
Query_SQL: TRANSFORM Round(Sum([Hours]),0) AS SumOfHours SELECT IIf(InStr([Subject]," ")=0,[Subject],Left([Subject],InStr([Subject]," ")-1)) AS [Subject Group], Round(Sum([Hours]),0) AS Total FROM Year_Crosstab_List, Next_Reporting_Month WHERE (((Year_Crosstab_List.Hours)>0) AND ((Year_Crosstab_List.Date)<=Left([Next_Reporting_Month],5) & Right(Right([Next_Reporting_Month],2)+102,2))) GROUP BY IIf(InStr([Subject]," ")=0,[Subject],Left([Subject],InStr([Subject]," ")-1)) PIVOT Year_Crosstab_List.[Location ];
Link To Column Definitions: Time_By_Locations

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_Month
Query_Type: Cross-Tab
Query_DateCreated: 07/04/2007 10:25:05
Query_DateChanged: 07/10/2015 15:51:04
Query_SQL: TRANSFORM Sum(Year_Crosstab.[Hours ]) AS SumOfHours SELECT Year_Crosstab.Task_Group AS Subject, "Dummy" AS [Total This Year], "Dummy" AS [Percentage This Year], "Dummy" AS [Total to Date], "Dummy" AS [Percentage to Date] FROM Year_Crosstab WHERE (((Year_Crosstab.Hours)<0.00000001 Or (Year_Crosstab.Hours)>0.002)) GROUP BY Year_Crosstab.Task_Group, "Dummy", "Dummy", "Dummy", "Dummy" ORDER BY Year_Crosstab.Task_Group PIVOT Year_Crosstab.Period;
Link To Column Definitions: Time_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: Time_By_Month (Grand Summary)
Query_Type: Cross-Tab
Query_DateCreated: 05/10/2008 19:26:14
Query_DateChanged: 07/10/2015 15:27:56
Query_SQL: TRANSFORM Sum(Year_Crosstab.[Hours ]) AS SumOfHours SELECT Year_Crosstab.Group AS [Subject Group], "Dummy" AS [Total This Year], "Dummy" AS [Percentage This Year], "Dummy" AS Total, "Dummy" AS Percentage FROM Year_Crosstab GROUP BY Year_Crosstab.Group, "Dummy", "Dummy", "Dummy", "Dummy" ORDER BY Year_Crosstab.Group PIVOT Year_Crosstab.Period;
Link To Column Definitions: Time_By_Month (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: Time_By_Month (Summary)
Query_Type: Cross-Tab
Query_DateCreated: 05/10/2008 19:24:25
Query_DateChanged: 07/10/2015 15:28:27
Query_SQL: TRANSFORM Sum(Year_Crosstab.[Hours ]) AS SumOfHours SELECT Year_Crosstab.Subgroup AS [Subject Subgroup], "Dummy" AS [Total This Year], "Dummy" AS [Percentage This Year], "Dummy" AS Total, "Dummy" AS Percentage FROM Year_Crosstab GROUP BY Year_Crosstab.Subgroup, "Dummy", "Dummy", "Dummy", "Dummy" ORDER BY Year_Crosstab.Subgroup PIVOT Year_Crosstab.Period;
Link To Column Definitions: Time_By_Month (Summary)

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





© Theo Todman, June 2007 - Sept 2023. 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