Skip to content

Monthly Archives: July 2020

MS Access Select top n query grouped by multiple fields

26-Jul-20
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 

对数据进行分组的SQL

26-Jul-20

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 , 

Move your iPhone Contacts to Google Contacts with the Google Drive app

25-Jul-20

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

transfering an export/import specification from one database to another (1 Viewer)

24-Jul-20

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 …

How to solve: chm can’t be open in windows 10 over network(NAS or Shared folder)

20-Jul-20
  1. run cmd in Administrator
  2. use mklink from NAS to local
    • For examples: mklink /d d:\jiangws \NASnew\jiangws

How do I simulate Excel’s Ceiling/Floor Functions in VBA?

18-Jul-20

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