F
Frederik Vanderhaeghe
Hi,
I would like to get a datagrid which looks like
Site | Jan | Feb | Maa | Apr | Mei | Jun | Jul | Aug | Sep | Okt
| Nov | Dec
---------------------------------------------------------------------------------
Sitename 1 | | | | | | | |
| | | |
Sitename 2 | | | | | | | |
| | | |
Sitename 3 | | | | | | | |
| | | |
This would show how many times a site has been viewed in the months. What
SQL-string do I have to build to get this automatically filled?
I use the table TBL_Stat_Sites
columns: Datum (datetime, null), Site (varchar(50), null), IP (varchar(15),
null), Connectie (varchar(50), null)
Fré
I would like to get a datagrid which looks like
Site | Jan | Feb | Maa | Apr | Mei | Jun | Jul | Aug | Sep | Okt
| Nov | Dec
---------------------------------------------------------------------------------
Sitename 1 | | | | | | | |
| | | |
Sitename 2 | | | | | | | |
| | | |
Sitename 3 | | | | | | | |
| | | |
This would show how many times a site has been viewed in the months. What
SQL-string do I have to build to get this automatically filled?
I use the table TBL_Stat_Sites
columns: Datum (datetime, null), Site (varchar(50), null), IP (varchar(15),
null), Connectie (varchar(50), null)
Fré