StupidStudent AGAIN!! please help

[StupidStudent]

I was looking for some help please

I have a customer order form which has a sub form called customer order line.

within customer order line i have the amount of a certain plant needed to compleat that order

I also have a table with all the plants details and the amount in stock

however what i need is, when the order is finished the amount in stock on the plant table to go down according to the amount on the orderline??

Any Ideas?

Thanks people

 

[EdFred]

You need an inventory Query. They can get rather bulky, but basically it ends up being a sum of everything you've bought minus the sum of everything you sold.

 

[StupidStudent]

Thanks for super quick reply!!

How would i go about this as i am new to access??

Is there a simpler way??

Thanks again!

 

[StupidStudent]

Ok Check This Out

Thanks for all your help

However i think i may have found a quicker way of doing this just need a hand to finish it??

Ok here goes I set up a query that looked up the last record number

Then i add 1 to it like this

=[LastOfCustomer_code]+1 //This returns an INT

However when i put this in the control source I need to convert it to a string so that i can place "CO" in front of it

ANY HELP PLEEEEASE???