Please help me and let me know how to concatenate text based on some criteria.
ex.
CUSTOMER CODE NO OF TRIPS DELIVERY NOTE NOS DATE OF SERVICE
XYZ 10 123 21 MARCH 13
We have huge database wiht different customers, with the no of trips, delivery note nos and date of services, i want a summary, which totals no of trips for that particular customer in one colum and another colum, concatenate delivery note nos based on date of service.
Best regards,
Shermin
Bookmarks