Creat a Back order

[Guest]

If I have in stock 20 items, ordered 10 recieved 5 and sold 35 I have created
a back order of 10, How can I have a form automaticall show the backorder
value?
Thank in advance,

 

[John Vinson]

On Sat, 5 Feb 2005 15:15:02 -0800, "Alvin Smith" <Alvin

If I have in stock 20 items, ordered 10 recieved 5 and sold 35 I have created
a back order of 10, How can I have a form automaticall show the backorder
value?
Thank in advance,

By having appropriate fields in your table and writing an appropriate
query.

If you'ld care to post some description of your table structure,
someone may be able to give you a more specific answer.

John W. Vinson[MVP]