As this group of time data, digital as a period of time to statistics such as the 12:00 to thou points is equivalent to the one hour for statistical figures, statistics into 12:00, the following data until 12:00, 9, more than an hour, so on, and finally in chronological order, in turn, save the
The 2013-01-28 22:25:00, 0.5
The 2013-01-30 06:55:00, 1.5
The 2013-01-30 09:10:00, 5.5
The 2013-01-30 10:20:00, 2.5
The 2013-01-30 13:10:00, 3.5
The 2013-01-30 13:15:00, 6.5
The 2013-01-30 18:25:00, 5.5
The 2013-01-31 11:45:00, 2.5
The 2013-01-31 12:00:00, 5.5
The 2013-01-31 12:10:00, 3.5
The 2013-01-31 14:20:00, 0.5
The 2013-01-31 14:25:00, 4.5
The 2013-01-31 14:35:00, 0.5

CodePudding user response:

Seems very simple,

CodePudding user response:

Seems should be a little - qiang

CodePudding user response:

Seemingly keyword queries can use Partition, haven't tried using date/time, an example of digital section below (DAO, SQL string also applies to ADO) :

 Dim db As DAO. The Database 
Dim the rs As DAO. You 

Set the db=DBEngine. OpenDatabase (" C: \ Program Files \ Microsoft Visual Studio \ VB98 \ Nwind MDB ") 

Set the rs=db. OpenRecordset (" SELECT DISTINCTROW Partition (/freight, 0, 500, 50) AS the Range, the Count (Orders. Freight) AS the Count From the Orders GROUP BY Partition ((freight), 0500, 50) ") 
The Set Data1. 
 you=rs
Results: 
The Range Count 
Zero: 49 469 
50:99 174 
100:149 70 
44, 150-199 
25, 200-249 
13, 250-299 
4, 300-349 
11, 350-399 
3, 400-449 
4, 450-499 
501:13 

CodePudding user response:

If the string is equipment receiving, I like to insert data into you (not inserted into the database), direct use can filter and sort out the results you want

CodePudding user response:

A beginner, learning how to learn