>Hi SQL gurus
>I have the following fields:
>CDate(D), CTime (C5), Patient (C30)
>As you may have understood, CDate holds dates, ctime times ( military ) and patient holds names.
>I am trying to get to the following, but since i think i may use only one UNION per select, i don't know if it's possible in one select command:
>

>CTime   Sunday    Monday   Tuesday    Wednesday
>-----   -------   ------   -------    ---------
>10:00   Sergio             Ken         Alfred
>10:15                                  Joseph
>10:15                                  Kim
>10:30   Fabio
>

>Well, you get the drill...
>
>TIA
>Jaime

It's a cross tab query. Get FastXTab from Downloads section here. You need data like this grouped by cdow, time, name. Once you have this, you can apply cross-tab.