1. A query is written in the SQL language and is a request for information from data in a database.
2. Microsoft SQL Server uses the Transact Structured Query Language (T-SQL)
3. The percent % symbol is the most common …
Posts By: jiangws
Move your iPhone Contacts to Google Contacts with the Google Drive app
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)
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)
- run cmd in Administrator
- 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?
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
Buffalo NAS external drives & Windows 10 will not connect
Control Panel – Programs and Features – Turn Windows features on and off and enabled:
SMB 1.0/CIFS File Sharing Support
Restarted and everything worked.
https://docs.microsoft.com/en-us/windows-server/storage/file-server/troubleshoot/detect-enable-and-disable-smbv1-v2-v3…
Pad single-digit numbers with a zero
VBA has a Format() function that you can use to pad numbers.
animal = “sinani-” & Format$(i, “00”)
This will pad single-digit numbers with a 0. Your two- and three-digit numbers will continue to work as expected.
From:https://stackoverflow.com/questions/31628535/pad-single-digit-numbers-with-a-zero…
Strings and Manipulations(VBA)
Text Functions, Workbook
Before continuing please be aware of the following information available in Excel HELP
FIND(find_text,within_text,start_num)
Worksheet Description VBA
CHAR Returns the character specified by the code number CHR
CLEAN Removes all nonprintable characters from text
Characters 0-31, 129, …
标准差和方差
标准差
标准差是数值分散的测量。
标准差的符号是 σ (希腊语字母 西格马,英语 sigma)
公式很简单:方差的平方根。那么…… “方差是什么?”
方差
方差的定义是:
离平均的平方距离的平均。
按照以下的步骤来计算方差:
例子
你和朋友们量度了狗狗的身高(毫米):
身高(到肩膀)是:600mm、470mm、170mm、430mm 和 300mm。
求平均、方差和标准差。
第一步是求平均:
答案:
平均 = 600 + 470 …
Sniptool – Screen Capture
…