cansevin
asked on
Querry Help
I have a querry that I would like to condense to not as many rows... it is attached to the below database.
The end result is I would like it to condense all same BookingID's to one row. For instance, in bookingID 79 all columns are the same except for the last two columns. I would like the new querry to compbine those two columns to one row titled: "Description". That "description" column would combine all the DateAppintments with the appropriate Duration
The end result for BookingID 79 would be one row that looks like this:
BookingID customerID StartDate TutorName TotalPrice StudentName Description
79 AnsevinChris 2/14/2011 Teve 200 Name 2/17/2011 for 1 Hour, 2/18 for 1 Hour, 2/19/2011 for 1 Hour, 2/20/2011 for 2 Hour
Does this make any sense? I hope so, it would be awesome if it works!
Thanks,
Chris
PracticeBMdb.mdb
The end result is I would like it to condense all same BookingID's to one row. For instance, in bookingID 79 all columns are the same except for the last two columns. I would like the new querry to compbine those two columns to one row titled: "Description". That "description" column would combine all the DateAppintments with the appropriate Duration
The end result for BookingID 79 would be one row that looks like this:
BookingID customerID StartDate TutorName TotalPrice StudentName Description
79 AnsevinChris 2/14/2011 Teve 200 Name 2/17/2011 for 1 Hour, 2/18 for 1 Hour, 2/19/2011 for 1 Hour, 2/20/2011 for 2 Hour
Does this make any sense? I hope so, it would be awesome if it works!
Thanks,
Chris
PracticeBMdb.mdb
It can be done but not in a simple query. I would do this in VBA code using recordsets. First populate the Booking recordset with all the bookings then loop through it and create a second recordset with all the appointments. If you have not used recorsets before and need help, let me know and I'll help with the code. I'm going to be interested to see if anyone has a simpler solution.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nice one Capricorn, I have never seen this method but I like it a lot!
ASKER
Wow, thats awesome... thanks!