how to count and insert into database by month?

[lyter]

hi..i'm newbie in db access..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..

[PianoMan64]

hi..i'm newbie in db access..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..

To put it simply, you don't want to do that. That is not what is considered to be Good Practice when developing database structure.

If you have the first table, you can use MS Access to create a Cross-Tab Queery with the information that you have. You simply count by Year, Month and you'll get the result you seek.

If you need more help, let me know,

Joe P.

[lyter]

To put it simply, you don't want to do that. That is not what is considered to be Good Practice when developing database structure.

If you have the first table, you can use MS Access to create a Cross-Tab Queery with the information that you have. You simply count by Year, Month and you'll get the result you seek.

If you need more help, let me know,

Joe P.

tq for your suggestion..actually i don't know how to do that because i'm learn the MS Access myself..and i not expert as u..could u help me how to do that? i'm struggling to try anything that u suggest..please help me..