I am doing a schedule report and would like to include different rows on a single line
ie:

Name    Mon        tues              wed     etc
            start time    start time    start time
            end time      end time
  the name , day, start and end time are all one row, so Mon start time & Tues Start time are different rows from the database, but I would like them on the same line on the report

Any Thoughts?
Tia    Pat

I don't know how to do it straight.

But with a little trick, it can be done with a crosstab.
The trick is to split every record into two recors (using joins)
to create separate entries for start time and end time.
Then we can use formulas to create just what you need.

--
Deniss Andrijevski
SKRIINING

I am doing a schedule report and would like to include different rows on a
single line
ie:

Name    Mon        tues              wed     etc
            start time    start time    start time
            end time      end time
  the name , day, start and end time are all one row, so Mon start time &
Tues Start time are different rows from the database, but I would like them
on the same line on the report

Any Thoughts?
Tia    Pat