Visual Basic

sorin_zan wrote:

Please is urgent.

SELECT SUM(total_sales) AS year_1, Client
FROM vanzari_totale
GROUP  by invoice_date, client

TRANSFORM Sum(Vanzari.Valoare) AS SumOfValoare
SELECT Vanzari.Client
FROM Vanzari
GROUP BY Vanzari.Client
PIVOT Month([Data]

SELECT COUNT(1), year(payment_date) as year FROM payments  GROUP BY year(payment_date)

SELECT COUNT(1), datepart("yyyy", payment_date) as year FROM payments GROUP BY datepart("yyyy", payment_date)

SELECT COUNT(1), datepart("yyyy", payment_date) as yr FROM payments  GROUP BY datepart("yyyy", payment_date)

SELECT COUNT(1) as [count], datepart("yyyy", payment_date) as [year] FROM payments GROUP BY datepart("yyyy", payment_date)

SELECT COUNT(1) as [count], datepart("yyyy", payment_date) as [year] FROM payments GROUP BY datepart("yyyy", payment_date)

select SUM([total_sales]) as [Total], [Client],year([invoice_date]) as [InvoDate]
FROM vanzari_totale 
group by [client], year([invoice_date])

3545,3	 2007	client_1	1
433,33	 2008	client_1	1
77756,1	 2009	client_1	1
3423,7	 2010	client_1	1
1234,44	 2011	client_1	1

TRANSFORM Sum(Vanzari.Valoare) AS SumOfValoare
SELECT Vanzari.Client
FROM Vanzari
GROUP BY Vanzari.Client
PIVOT Month([Data]);