Show grouped date in Chart (1 Viewer)

[Edwik]

Hi!

I use MS Graph and need show 2 data types:
1. Invoice Value, EUR
2. Date
Date axis group records by month, for Example Period from 2005.01.01 And 2006.01.01 has 12 positions in Date Axis.
Her I have problem: I need show sum of Values for every month.
For example in Period from 2005.01.01 till 2005.02.01 I have 3 Values: 200, 500, 600EUR. Her I need to show 1300EUR, and so every month. Her is my strandart code:

Dim strSQL1 As String
strSQL1 = "SELECT Date As Date, Value FROM Table WHERE (Date BETWEEN 2005.01.01 And 2006.01.01)"
Me!chrStatistik.RowSource = strSQL1

Thank You in advace for help.

 

[namliam]

Try using the Group by option for a select statement....

Select ...
From ...
Where ...
Group by ....
Having ....
Order by....

 

[Edwik]

can You write an exapmple, please?!

 

[Edwik]

How can I give instruction to group by month?

 

[namliam]

can You write an exapmple, please?!

Read a manual....

It is just click click click in Access...

 

[namliam]

How can I give instruction to group by month?

Use functions like format or Year and month