Producing a report that shows stock in and out, i have set up subtotals to record the actual amount of stock, and i want to show the last date of the stock in.
Now i have used MAX date but that shows the last transaction ( which could be an out not an in).
As the outs are minus and the ins are additions i tried to sety up a WHERE in the expression builder to say WHERE stock is greater than zero, but it doesnt seem to recognise the WHERE, how else can i write this to actually show the last date in.
THanks
Now i have used MAX date but that shows the last transaction ( which could be an out not an in).
As the outs are minus and the ins are additions i tried to sety up a WHERE in the expression builder to say WHERE stock is greater than zero, but it doesnt seem to recognise the WHERE, how else can i write this to actually show the last date in.
THanks