Visual Basic

shy boi wrote:

I found this it really helped

Imports Word = Microsoft.Office.Interop.Word   
 
Public Class Form1   
  
    ' Find / Replace in Word Document   
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click   
        Dim objWordApp As New Word.Application   
        objWordApp.Visible = True  
  
        'Open an existing document.
'"C:\Trydata\1.doc" is where the document is located  
        Dim objDoc As Word.Document = objWordApp.Documents.Open("C:\Trydata\1.doc")   
        objDoc = objWordApp.ActiveDocument   
  
        'Find and replace some text   
        'Replace 'VB' with 'Visual Basic'   
        objDoc.Content.Find.Execute(FindText:="VB", ReplaceWith:="Visual Basic Express", Replace:=Word.WdReplace.wdReplaceAll)   
        While objDoc.Content.Find.Execute(FindText:="  ", Wrap:=Word.WdFindWrap.wdFindContinue)   
            objDoc.Content.Find.Execute(FindText:="  ", ReplaceWith:=" ", Replace:=Word.WdReplace.wdReplaceAll, Wrap:=Word.WdFindWrap.wdFindContinue)   
        End While  
  
        'Save and close the document   
        objDoc.Save()   
        objDoc.Close()   
        objDoc = Nothing  
        objWordApp.Quit()   
        objWordApp = Nothing  
  
    End Sub  
End Class  

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