How to grand total in grouping Command in VB 6.0
milon.mahbub.1
0
Newbie Poster
Recommended Answers
Jump to PostHi
What do you mean by grouping command? Are you referring to aggregate functions in a database or something else?
You will need to provide a lot more detail in order to get a relevant answer.
All 2 Replies
djjeavons
113
partis vestri scientia
Hi
What do you mean by grouping command? Are you referring to aggregate functions in a database or something else?
You will need to provide a lot more detail in order to get a relevant answer.
yuvalzak
0
Newbie Poster
some thing like this
SELECT Shippers.ShipperName,COUNT(Orders.OrderID) AS NumberOfOrders FROM Orders
LEFT JOIN Shippers
ON Orders.ShipperID=Shippers.ShipperID
GROUP BY ShipperName;
look here : http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_groupby
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.