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...
volex
Last Activity: Jan 21 '09, 06:10 PM
Joined: Jan 19 '09
Location:
-
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...Leave a comment:
-
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 shopLeave a comment:
-
calculation
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..
No activity results to display
Leave a comment: