Ray,
I want a query that will provide one record per event with all times included.
feel free to answer RTFM or STFW as long as you provide the manual section or
key words. ;)
Can be done with a pivot table. Examples under "Pivot tables" at
http://www.artfulsoftware.com/infotree/queries.php. If you get stuck,
pipe up.
PB
-----
Ray wrote:
Hello,
I've tried the manual and google, but I am not even sure what to call what I
want to do.
simplified data example:
I have a table of start and end times for an event, and an id for that event
in a table. each event may occur multiple times, but never more than 5 times
and rarely more than 3.
I want a query that will provide one record per event with all times included.
feel free to answer RTFM or STFW as long as you provide the manual section or
key words. ;)
Thanks,
Ray
chart form follows:
id | event_id | start | end
---------------------------------------
1 | 4 | t1 | t2
2 | 4 | t3 | t4
3 | 4 | t5 | t6
4 | 5 | t1 | t2
5 | 5 | t3 | t4
becomes
id | event_id | start | end | start | end | start | end
---------------------------------------------------------------------------
? | 4 | t1 | t2 | t3 | t4 | t5 | t6
? | 5 | t1 | t2 | t3 | t4
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.50/2150 - Release Date: 06/02/09 06:47:00
