Im having difficulty grouping an output of a query so the data appears in one row. The data shows dates/times of when certain actions occurred to an IT request ticket. Perhaps I should show you what I mean. Currently my output looks something like this:
TicketID; Added; InProgress; Closed;
ABC-123456; 03/01/2009; ; ;
ABC-123456; ;04/01/2009; ;
ABC-123456; ; ;09/01/2009;
However, I want it to look like this...
TicketID; Added; InProgress; Closed;
ABC-123456; 03/01/2009; 04/01/2009; 09/01/2009;
The source table also shows the dates a row at a time.
I cant show the sql for the query just yet as its in work, but if it helps... i can provide it later. It is slightly complicated as ive had to determine columns based on "iIf" statements and created ordinary date values from unix timestamps ([datetime]). The formula for the "Added" column for instance, would look a bit like this:
Added : iIf([actionmsg] like "New*",dateadd('s',[datetime],#01/01/1970#))
Im sorry if I've not been very clear!
Any suggestions?
TicketID; Added; InProgress; Closed;
ABC-123456; 03/01/2009; ; ;
ABC-123456; ;04/01/2009; ;
ABC-123456; ; ;09/01/2009;
However, I want it to look like this...
TicketID; Added; InProgress; Closed;
ABC-123456; 03/01/2009; 04/01/2009; 09/01/2009;
The source table also shows the dates a row at a time.
I cant show the sql for the query just yet as its in work, but if it helps... i can provide it later. It is slightly complicated as ive had to determine columns based on "iIf" statements and created ordinary date values from unix timestamps ([datetime]). The formula for the "Added" column for instance, would look a bit like this:
Added : iIf([actionmsg] like "New*",dateadd('s',[datetime],#01/01/1970#))
Im sorry if I've not been very clear!
Any suggestions?
Last edited:
