Jiangws's Blog

 
 
 
  • About

    夢を叶える為
 
MS Access Select top n query grouped by multiple fields July 26th, 2020
SELECT StudentID, Year, Subject,  AVG(TestScore) AS AvgScore
  FROM
(
  SELECT StudentID, Year, Subject, TestScore
   FROM MyTable t
   WHERE TestID IN
  (
   SELECT TOP 3 TestID 
     FROM MyTable
    WHERE StudentID = t.StudentID
      AND Year = t.Year
      AND Subject = t.Subject
    ORDER 
Posted in Access || Comments Off on MS Access Select top n query grouped by multiple fields
对数据进行分组的SQL July 26th, 2020

Table:

idscore
156
291
367
454
556
669
761
883
999
Subject_table

MS Access

SELECT Switch(score < 60,  "less 60",
        	score < 80,  "60 - 80",
        	score < 100 , 
Posted in Access || Comments Off on 对数据进行分组的SQL
Move your iPhone Contacts to Google Contacts with the Google Drive app July 25th, 2020

https://www.piesync.com/help/want-to-learn-more/setting-up-your-iphone-to-sync-with-google-contacts/…

Posted in Google || Comments Off on Move your iPhone Contacts to Google Contacts with the Google Drive app
transfering an export/import specification from one database to another (1 Viewer) July 24th, 2020

In Access 2007, display the “External Data” tab. Click on the “Access” option.

Use the Browse button to locate the file you want to import the saved import-export specification. Once a database has been specified, the “OK” button will become …

Posted in Access || Comments Off on transfering an export/import specification from one database to another (1 Viewer)
How to solve: chm can’t be open in windows 10 over network(NAS or Shared folder) July 20th, 2020
  1. run cmd in Administrator
  2. use mklink from NAS to local
    • For examples: mklink /d d:\jiangws \NASnew\jiangws
Posted in Uncategorized || Comments Off on How to solve: chm can’t be open in windows 10 over network(NAS or Shared folder)
How do I simulate Excel’s Ceiling/Floor Functions in VBA? July 18th, 2020

To simulate these two Excel functions in Access Visual Basic, paste the following code into a new module and save it:

CODE

Public Function Ceiling(ByVal X As Double, Optional ByVal Factor As Double = 1) As Double
    ' X is 
Posted in Access || Comments Off on How do I simulate Excel’s Ceiling/Floor Functions in VBA?