how to count and insert into database by month
hi..i have a big problem..i'm used db access and asp code in my system..hope someone can help me to fix this issue..:(
here i have two table..1) eachclick 2)month
1st (in table eachclick)
button clicked date time
1 1 19 mac 2008 2:30pm
2 1 19 mac 2008 2:31pm
3 1 19 mac 2008 2:32pm
1 1 19 mac 2008 2:33pm
1 1 19 april 2008 9:00am
2nd(in table month)
button january feb mac april may june
1 0 0 0 0 0 0
2 0 0 0 0 0 0
3 0 0 0 0 0 0
That's the sample table that i've create..
i don't know how to count the clicked and insert it into the table month..
i want to know how much clicked in january,february and so on and separate the button like i draw in table month...
may someone help me to give the code..tq for your honest..:)