Need help with a query plz

[Altamarus]

I have a table like this

//STARTING_DATE//DAY1//DAY2//DAY3//DAY4...//DAY7
////////////////////////////////////////////////
//2005-01-02 // 0 // 1 // ...
//2005-01-09 // 0 // 0 // ...
//2005-01-16 // 0 // 0 // ...
//2005-01-23 // 0 // 1 // ...
//2005-01-30 // 0 // 1 // ...
/////////////////////////////////////////////////
Where day 1 to day 7 are the days worked (1) or not(0) worked in the week for the month. I just cannot figure out how I could count the number of days worked in the month depending on the date entered by the user.

Is there any function to count the number of ones in a certain row?

Thank you =D

 

[PHV]

Have a look here:

http://r937.com/relational.html

Anyway what about simply DAY1+DAY2+...+DAY7 ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Altamarus]

ok thx i'll give it a try....your help is very appreciated!