Thanks Naomi, just downloaded it and testing it as we speak...
Jaime

>>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.