Solved I want a value (id) once inside the query (1 Viewer)

Matin_Murad

Member
Local time
Today, 12:27
Joined
Jul 1, 2020
Messages
37
Hello everyone: Inside a query, a non-repeated record, but the value (id) is duplicate, I want a value (id) once inside the query
 

Attachments

  • one value.accdb
    2.6 MB · Views: 163

pbaldy

Wino Moderator
Staff member
Local time
Today, 12:27
Joined
Aug 30, 2003
Messages
36,126
Is this what you want?

SELECT tabl2.id, tabl2.iname, Sum(tabl2.sales) AS SumOfsales
FROM tabl2
GROUP BY tabl2.id, tabl2.iname;
 

Matin_Murad

Member
Local time
Today, 12:27
Joined
Jul 1, 2020
Messages
37
Thank you: this is what I need
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 12:27
Joined
Aug 30, 2003
Messages
36,126
No problem.
 

Users who are viewing this thread

Top Bottom