caculation in one field after manually putting in amount in another

[Stephanie53]

ok here is the deal -

in our purchasing department every year they get a standard cost of each item to which this is listed with each items...



now sometimes they (the suppliers) that gave the standard cost has now had some sales or they have increased in their prices

so each time an order is placed for the product to go back into inventory we need to be sure that the cost variance is not an issue should it be higher or lower..now hre is the issue

i created another field called Actual PO Cost - now i want to add this field and the quantity and put the total amount in the extended Price field..and have the manually entered in actual cost be listed in this order.

under Purchase Details Extended query this is what it states:

Extended Price: [Quantity]*[Products].[Actual PO Cost]

but since its not really pulling the Actual cost because its manually put in the form its not really creating the extended total - how can i get it to see the cost put in and put the correct price in the extended price field?

i am leaving for the rest of the day and will return by monday - so you all have a great weekend!!

TIA

Stephanie

[rzw0wr]

I had this problem with a swimming pool database I wrote.
I had to keep track of each order, by amount and date.
Make sure that each product was sold for the correct price and reduce the proper order by the proper amount until the order was depleted.
As I read your post, you are entering just 1 price. If this is correct what are you doing about stock that is already in stock.

Try a requery after the Actual PO Cost has been entered.