Using Extents to extract data

[BobLoblaws]

Hi, I'm fairly new to progress, can use your help.
I've setup a decimal variable with extent 14 called Sales_qty.

I would like sales information to be separated by item by day for 14 days.
The data is in a table called ih_hist with detail in idh_hist. I have a break by idh_part by ih_inv_date.
The problem i have is that the sales information (ih_qty) is not setup as a extent.

How can I setup my variable with the correct data? If you need any further information, please ask.

Thanks in advance,
TN

 

[HelloMike]

Arrays are horrible things to work with. Have you considered using a temp-table instead ?

Mike.