Having trouble with a control on my report

[graeme34 via AccessMonster.com]

HI,

I am trying to create a despatch note report, everything was working fine
until I tried to place a control in the subreport (despatch note detail). The
control is Quantity Outstanding, which allows for any previous part
despatches. i.e. an order only being part sent. The quantity outstanding
control has a calcualted source....Quantity Ordered - Quantity Sent....Where
quantity sent is the sum of any previous despatches. I think my problem is in
the underlying query, because if it is a first despatch i.e. there is no
record of any quantity sent then the queries recordset is empty.
Any suggestions would be greatly appreciated.

 

[Anne]

Yes, you need to test this out in a query.
Lets assume that your query is based on customers. You need create another
query where all customers will be shows. In that query you do your
calculation for the quantities so that a row is created for all your
customers and the calculated field shows up with null values if nothing has
shipped before.
You then link that to your original query and you will have at least an
empty field where no order has been dispatched before.
Anne