I have a query that extracts a list of itemcodes
SELECT itemcode FROM tblitem
I will like to display my report in a format of
itemcode1, itemcode2, itemcode3
itemcode4, itemcode5, itemcode6
.... and so on
I have used in formula
{tblitem.itemcode}, Next({tblitem.itemcode), Next(Next(tblitem.itemcode))
But this Next(Next(tblitem.itemcode)) throws me an error. How can I achieve to show the thrid item in the details row of the report?
Please help!
Much thanks!
Chinho