Chris__T
Posts: 339
|
| Posted: 08/06/2007, 10:52 AM |
|
A question about laying out grids and/or reports.
I'd like to display my users and their hours worked in a grid (or report) with the date as the column, then other fields pertaining to that date below it for each user.
(I don't know if this will format correctly when published)
........................................8/1/07_________8/2/07________8/3/07_______etc...
Joe Smith.....Reg hrs..........8...........................8..........................8
.......................OT hrs........2...........................0..........................0
Jim White.....Reg Hrs..........7...........................8...........................8
.......................OT hrs........0............................1..........................0
etc...
my table consists of these fields:
dte (date), emp_id, reg_hours, ot_hours (emp_id relates to the employee table to get first and last names)
I can't seem to get anything set up to make this format work. How do I get to use my date field as a column heading kind of thing? Do I have to set up some code that just puts the dates up there, then searches the table on that date and inserts into appropriate fields?
Chris
|
 |
 |
|
