-
MSACCESS Query
Dear Friends,
Please help me to find the solution for the below data. I am using MSAccess Database and Active Server Pages.
A table consists of few records, given below, I have to get output in a single row.
ClassName Date Time Description
---------- ------ ------ -----------
K-11 10/10 08:30 Exam Hall
K-11 10/10 10:00 PGP Room
K-11 10/10 11:00 FPM Room
K-12 10/10 10:00 Audioturium
Output I should get as below using single sql command
ClassName 08:00 08:30 09:00 09:30 10:00 10:30 11:00
--------- ---- ----- ----- ---- --- ---- ----
K-11 08:30 10:00 11:00
Thanking you,
With Regards,
Asif
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules