data entry through the form (1 Viewer)

MajP

You've got your good things, and you've got mine.
Local time
Today, 18:12
Joined
May 21, 2018
Messages
8,463
Code:
SELECT 
 tblA.D, 
 Sum(tblA.S) AS SumOfS
FROM 
 tblA
GROUP BY 
 tblA.D;

Yields
Code:
D	SumOfS
1	14
2	12
3	781
4	150
5	30
 

AccessLastHope

Registered User.
Local time
Today, 15:12
Joined
Jun 11, 2019
Messages
14
Code:
SELECT 
 tblA.D, 
 Sum(tblA.S) AS SumOfS
FROM 
 tblA
GROUP BY 
 tblA.D;

Yields
Code:
D	SumOfS
1	14
2	12
3	781
4	150
5	30
Thanks, but I had the same request. I meant how to get data from it and put data from it with each new record in another table. it is necessary so that, for example, when we issue a train ticket, we could not issue the same ticket again
 

AccessLastHope

Registered User.
Local time
Today, 15:12
Joined
Jun 11, 2019
Messages
14
I don't understand the question: "I need pre-configured real-time requests"

As to articles, you can Google-search (or pick your other favorite web crawler) for:

Database Normalization
ACCESS Action Queries (more specifically, INSERT INTO)

Mike's reluctance to answer - and mine - is that without some better knowledge of your data layout we are likely to give you very bad advice. I am not clear on that layout and from his answers, I would say Mike is confused, too.
You see, it is better to give something bad but working, than a beautiful but don`t working
 
Last edited:

AccessLastHope

Registered User.
Local time
Today, 15:12
Joined
Jun 11, 2019
Messages
14
Code:
SELECT 
 tblA.D, 
 Sum(tblA.S) AS SumOfS
FROM 
 tblA
GROUP BY 
 tblA.D;

Yields
Code:
D	SumOfS
1	14
2	12
3	781
4	150
5	30

can you tell how to display the value of the field D of table A by pressing Enter?
 
Last edited:

Users who are viewing this thread

Top Bottom