Select / Iif Statement

[mad-q]

Hello,

I have a list of orders, if the order contains fewer than 5 lines, and doesn't contain a large item (marked in the stock record in a yes/no box), I would like it to group these into 6 orders so I can have 6 orders of 5 lines in a report. If the next order does contain a large item I would like it to just select 1 order.

I am getting rather lost as to where I should go with this one so any help / direction would be very much appreciated.

Yours
Iain

 

[mad-q]

So I was thinking that the code would be written something like this

If Order contains large part,
Print
Else
If Order.OrderLines>5, Print
Else add to list until 5 orders selected
Then Print

Cheers