access 2010
Hi,
I have a table with the following fields:
- From
- To
- TypeOfWork (to be chosen from a combo-box)
- Activity (text field to be filled in freely)
In a table i have a complete day with times (from -> to), the type of work between those times and the activity performed between those times a bit like this:
FROM TO TYPE OF WORK ACTIVITY
00:00 - 11:00 Welding Welding clamps
11:00 - 13:00 Welding Welding anodes
13:00 - 15:00 Cleaning Cleaning pipes
15:00 - 18:00 Cleaning Cleaning floor
I would like it to show in the report like this:
FROM.....TO.......TYPE OF WORK.....ACTIVITY
00:00 - 13:00......Welding............00:00 Welding clamps
...............................................11:00 Welding anodes
13:00 - 18:00......Cleaning...........13:00 Cleaning pipes
...............................................15:00 Cleaning floor
(Sorry for the ... they keep the layout correct)
So it should sort on "From", then group by "TypeofWork" and repeat the "From" field(I think...).
But I now have tried every combination of sorting and grouping I could think of and nothing works! Any thoughts?
Thanks a bunch!
Mark
Hi,
I have a table with the following fields:
- From
- To
- TypeOfWork (to be chosen from a combo-box)
- Activity (text field to be filled in freely)
In a table i have a complete day with times (from -> to), the type of work between those times and the activity performed between those times a bit like this:
FROM TO TYPE OF WORK ACTIVITY
00:00 - 11:00 Welding Welding clamps
11:00 - 13:00 Welding Welding anodes
13:00 - 15:00 Cleaning Cleaning pipes
15:00 - 18:00 Cleaning Cleaning floor
I would like it to show in the report like this:
FROM.....TO.......TYPE OF WORK.....ACTIVITY
00:00 - 13:00......Welding............00:00 Welding clamps
...............................................11:00 Welding anodes
13:00 - 18:00......Cleaning...........13:00 Cleaning pipes
...............................................15:00 Cleaning floor
(Sorry for the ... they keep the layout correct)
So it should sort on "From", then group by "TypeofWork" and repeat the "From" field(I think...).
But I now have tried every combination of sorting and grouping I could think of and nothing works! Any thoughts?
Thanks a bunch!
Mark