Query with numbers from T1 to Tmax (1 Viewer)

[btamsgn]

Dear Friends,
I want to create a query with numbers from T1 to Tmax in file quiluat.accdb like file book excel
Please find the attachment for your refference.
Looking forwarding to supporting and receiving from your responses.

 

[June7]

I cannot open the zip folder. Get "invalid" error. Review https://stackoverflow.com/questions/32411142/microsoft-access-query-returning-sequential-numbers

 

[The_Doc_Man]

What are you saying is wrong? Describe your problem in words. Don't tell us "make query look like spreadsheet" because Access isn't Excel. They do different things. Based on the query in the .ACCDB, I would say that there is a structural (or structural concept) issue in the table. What is the goal in words?

 

[SHANEMAC51]

Please find the attachment for your refference

renamed RAR archive

Ngay	Tmax	T1	T2	T3	T4		Ngay	T1	T2	T3	T4
10-окт-21	6	3	22	1	3		10-окт-21	3	25	26	29
13-окт-21	23	20	14	3	2		10-окт-21	4	26	27	30
15-окт-21	5	5	8	4	3		10-окт-21	5	27	28	31
17-окт-21	9	4	8	9	1		10-окт-21	6	28	29	32
20-окт-21	5	5	4	24	7		13-окт-21	20	34	37	39
22-окт-21	5	3	2	1	3		13-окт-21	21	35	38	40
24-окт-21	7	6	23	2	1		13-окт-21	22	36	39	41
27-окт-21	19	13	4	9	3		13-окт-21	23	37	40	42
14-ноя-21	5	3	2	13	10		15-окт-21	5	13	17	20
17-ноя-21	14	4	11	10	1		etc
19-ноя-21	11	9	1	16	2
21-ноя-21	1	1	11	17	11
24-ноя-21	11	2	8	8	5
26-ноя-21	15	4	14	7	4
28-ноя-21	21	13	4	9	1
09-фев-22	3	3	17	7	10
11-фев-22	11	10	1	8	19
13-фев-22	14	14	7	1	2
16-фев-22	5	2	3	3	8
18-фев-22	12	3	11	6	6
20-фев-22	5	4	2	10	14

 

[June7]

I very much doubt this can be done with SQL alone and will require VBA writing records to a temp table.

I can't open RAR or WinZip files, only Windows Compression zip.

 

[btamsgn]

Dear All,

File has updated with program "Windows compressed" already
Pls open again, is it ok?
Pls view and advise, thanks.

 

[GPGeorge]

As a general rule, if you want to create Excel spreadsheets, the proper tool is the Excel application.

 

[arnelgp]

How did you get TMax value? what is the secret herbal formula?

 

[Mike Krailo]

Am I missing something here? Wouldn't you just select the data you want and order by Tmax field? Or are you asking something different. Since you never really describe what you are trying to do, we are left to guess what your thinking. T1 to Tmax looking at that spreadsheet doesn't make sense since they are in different columns. Just describe in words what you are trying to accomplish.

 

[June7]

Zip folder now opens. But already saw data in @SHANEMAC51 post. My comment is unchanged. Consider:

Sub CalcT()
Dim db As DAO.Database, rs As DAO.Recordset
Dim n As Integer, j As Integer, w As Integer, x As Integer, y As Integer, z As Integer
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Table1 ORDER BY NGay")
CurrentDb.Execute "DELETE FROM Table2"
Set db = CurrentDb
Do While Not rs.EOF
    n = rs!T1
    j = 0
    Do While n <= rs!TMax
        w = rs!T1 + j
        x = rs!T1 + rs!T2 + j
        y = rs!T1 + rs!T2 + rs!T3 + j
        z = rs!T1 + rs!T2 + rs!T3 + rs!T3 + j
        db.Execute "INSERT INTO Table2(Ngay, T1,T2,T3,T4) VALUES(#" & rs!Ngay & "#," & w & "," & x & "," & y & "," & z & ")"
        n = n + 1
        j = j + 1
    Loop
    rs.MoveNext
Loop
End Sub