View Full Version : Query or Module


smiler07
10-07-2009, 03:41 AM
Hi Thanks in advance for any help.

I am currently trying to concat one of the tables in my database so that it is displayed as Example B.

Example

Original Table

Col1 Col2
1 09:00
1 09:15
1 09:30
2 10:00
2 10:15
2 10:30

Example B

Col1 Col2 Col3 Col4
1 09:00 09:15 09:30
2 10:00 10:15 10:30

Is this possible?

Guus2005
10-09-2009, 01:53 AM
You can accomplish that by using a crosstab query.

HTH:D