Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- show numbers of records as % ???
February 15, 2007, 9:21 pm
rate this thread
I'm migrating from Access til MySQL.
Works fine so far - but one thing is nearly killing me:
I got the count of total records in a variabel - (antalRecords)
I got the count for the Field Q1 where the value value is = 'nej'
Now I just need to calculate how many % of my records have the value 'nej'
I access this worked very fine - but with MySQL ( and ASP) I just cant get
it right!!! I go crazy ....
My code looks like this :
strSQL="SELECT COUNT(Q1) AS Q1_nej FROM Tbl_evaluering " &_
"WHERE Q1 = 'NEJ' "
set RS = connection.Execute(strSQL)
antal_nej = RS("Q1_nej")
procent_nej = formatNumber((antal_nej),2)/antalrecords * 100
Hope ...praying for help ...Please ;-)
best wishes -Otto - Copenhagen
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum