Table Design

[Sean Franco-Norris]

I am currently developing a report with a form for me to put the start date and end date then it generates a table.

I have no idea what they are called, so I hope I didn't break any rules and ask the same questions that somebody already asked in other posts. If I do, please redirect me to those.

I was wondering if it is possible to do a SQL coding that will show the table looking like this:

|Programs| |Staff| |Total_Enc| |Total_Late| |Total_Not_Late| |Percentage|
"All Program" "null" "null" "null" "null" "null"
"null" "Staff Name Here" "#'s" "#'s" "#'s" "%"

The first row is a header; the second row is only the name of the program, then the rest are nulls, the third row - the first column is null; the second column is the staff's name, then the rest are the #'s using the count and sum.

If I did them in excel, I usually used subtotal to get the grouping based on the program name. I am hoping I can do similar with SQL.

I hope I am making any sense.