data entry through the form

[MajP]

SELECT 
 tblA.D, 
 Sum(tblA.S) AS SumOfS
FROM 
 tblA
GROUP BY 
 tblA.D;

Yields

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

 

[AccessLastHope]

SELECT 
 tblA.D, 
 Sum(tblA.S) AS SumOfS
FROM 
 tblA
GROUP BY 
 tblA.D;

Yields

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]

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

 

[AccessLastHope]

SELECT 
 tblA.D, 
 Sum(tblA.S) AS SumOfS
FROM 
 tblA
GROUP BY 
 tblA.D;

Yields

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?