BAQ query

[techjohnny]

I have several rows of data:

employeenum date payhours
1 10/29/13 8
1 10/30/13 7.5
1 10/31/13 8.25

2 10/29/13 8
2 10/30/13 7.5
2 10/31/13 9

I'm trying to create a single expression that takes a date range and adds up all the payhours. I'm sure a while loop will work, but need a start point.

This is a 4GL language.

Admin, can you please move this post to development?

 

[Rob Fitzpatrick]

I don't know what "BAQ" is. Are you using 4GL (aka ABL) or SQL?

This is really a development task rather than database admin. Whether this thread belongs in Development or SQL-92 depends on what type of client you are using.