calculation

[volex]

hello guys
can you help me to my problem in my database i have 3 table and to forms in may first form is we have main form and subform that is the sales and the second form is inventory my problem is i want to update the records from the form of inventory when i sale one product will be less in the stock..

[NeoPa]

Hi Volex.

I'm afraid your question is very unclear.

However, I'm guessing you're looking at implementing some sort of application that manages sales and stock etc.

I can tell you there are a number of different ways to update values in a table when data is entered on a form. Without a clearer understanding of what you already understand it's hard to be more precise than that.

I will also mention, that it seems to me that the type of project you're considering is possibly a bit advanced for you if you need to ask such a basic question. I'm really not trying to put you down or be disrespectful. We all started as n00bs at one point after all. I merely make an observation. Related updates and multiple simultaneous updates, are not basic Access.

Welcome to Bytes!

[volex]

sir neopa thank you for your reply,the caculation i put it in query already the may problem is how to update the record from the query..i get the result but when i check the stock will not change but when i check in query its working
sir please help me i need this program for my shop

[volex]

sir its me volex,sir can you help me to my problem i have a 2 forms and 3 table the first one is product inventory then the other one is sales and sales_detail in product inventory i put a stock and last stock then the sales_detail i have quantiy i put in query that to record then i run the query is working but when i put in last stock to lookup the query its working then when i put another record from the sales detail in quatity will not update the last stock in product inventory sir please help me for my program .....


volex

[NeoPa]

I'm afraid that further help is beyond my scope at this stage.

This is for both of the same reasons that I mentioned in my previous post.

• Your posts are not clear. Your later posts are no more clear than your first one was.
• It seems to me that this whole project is too complex for you to deal with. Whether it is a language difficulty or otherwise, you have completely ignored my previous post as far as I can see. It would be impossible to discuss any concepts other than the very basics without a far better level of communication.

Generally, we work on the basis of answering clearly stated questions. Generally of the form "I've tried to do this but I got stuck here with a particular error (including message)". Yours is so open ended and you're clearly not listening to me anyway, that I cannot see that I can possibly help you.

I suggest you check out our FAQ - How to Ask a Question for assistance with how to ask your questions in such a way that they are likely to be answered.

[volex]

result of query put in the textbox

hello guys

can you help me to my problem in access i have 3 table

product inventory
1 product ID
2 product name
3 product model
4 stock
5 stock sale
6 purchace
7 last stock

Sales
1 sales ID
2 Invoice number
3 page number
4 date

Sales_detail
1 Sales Id
2 Product Number
3 Product Name
4 Product model
5 quantity
6 unit price
7 total price

then i create 2 forms, 1 for the frm_product_inv entory then the 2 is frm_sales then subfrm_sales_de tail, i create the query for the computation of quantity and the stock if i sale the product will be automatic less in the stock my problem is how can i put the result in the textbox of the last stock can you help me for my problem..

thank you so much
volex