Centralized data front end.accdb Change Log 2021: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 7: | Line 7: | ||
not rolled yet [[User:Ttenbergen|Ttenbergen]] 11:21, 2021 August 24 (CDT) | not rolled yet [[User:Ttenbergen|Ttenbergen]] 11:21, 2021 August 24 (CDT) | ||
* fixed [[created_AdmitDtTm query]] to explicitly turn the date into date data type; somehow the query turned it into something else that was being sorted differently on Pagasa's computer than on Tina's. [[User:Ttenbergen|Ttenbergen]] 14:06, 2021 August 24 (CDT) | * fixed [[created_AdmitDtTm query]] to explicitly turn the date into date data type; somehow the query turned it into something else that was being sorted differently on Pagasa's computer than on Tina's. [[User:Ttenbergen|Ttenbergen]] 14:06, 2021 August 24 (CDT) | ||
* created crosstab queries to replace pivot tables since 2019 doesnt' support them any more: | |||
** [[CT_Count_of_Admissions query]] to replace old ''P_Count_of_Admissions query'' | |||
=== 2021-08-05 === | === 2021-08-05 === | ||