@Uddin wrote:
Hi Paige,
Thank you so much for your kind response. I tried with both ways as you suggested but it shows all group without WHERE statement like this:
[cid:5ecd9f9b-14d3-4c85-b2ad-520051335356]
And with WHERE statement it shows error in WHER statement. Looking forward to your kind response.
As others have said, its time for you to stop saying you get errors, and SHOW US the log, including your code as it appears in the log.
In my earlier comment, I said you need to delete the WHERE and add the FORMAT statement, which would work.
--
Paige Miller