The table name: MyTable
Fields: serial number length


Field length is the text type, has imported the three tables of data, because the format of the original three tables, the import is different also, according to the form data in the table below:


The serial number is
1
10 20 seconds1 hour and 6 minutes and 25 seconds 2

4, and get3 1:06:25
5 620
6 3685
... ...

Serial number 1 and number 2 in the table from A table, shown as hour X X X seconds, serial number 3 and number 4 from table B, is shown as X: X: X, the serial number five and number six table import from C, shown as X, now the unified format into C import table format, namely X (X is the time to display the total number of seconds), how to write SQL statements to pay attention to the database is ACCESS


United now to put the data in the table, if it is

CodePudding user response:

Use SQL statements split string after calculate time

CodePudding user response:

Different formats, to intercept merged again, try to use the format

CodePudding user response:

Can provide code?

CodePudding user response:

Datediff (" s ", "0", "1 minute 2 seconds)"

CodePudding user response:

According to the different situation analysis of string, respectively
1. Take a second word
2. Take:
And, without a second

CodePudding user response:

The length field with character, can appear this problem, change it to type Time again to see see!