1 Topic by abouyahya527911 (edited by abouyahya527911 2015-05-10 10:21:46)

  • Registered: 2015-04-24
  • Posts: 85

Topic: need help

how can i do this

exemple :

Type : A         Quantity : 150                Sold out : 10      Came in : 50            Total : 190

Quantity will automaticly become the number left 190 no need to know total ich time just calculate total to know what stock for me left

thanks

  • Registered: 2015-04-24
  • Posts: 85

Re: need help

can anybody answer me !!!

3 Reply by mr_d (edited by mr_d 2015-05-11 09:00:34)

  • mr_d
  • Member
  • Offline
  • Registered: 2014-11-07
  • Posts: 54

Re: need help

I'm not sure what the problem you are having actually is...you have basically already given the solution you want already yourself.
you just need to create a calculated field in your table and make the result (Total) equal to Quantity + (Came in) - (Sold out).
Please have a look at this thread, http://myvisualdatabase.com/forum/viewtopic.php?id=1110, as it looks to be very SIMILAR to what you want to do.

Dennis
  • Registered: 2015-04-24
  • Posts: 85

Re: need help

Thanks this what i need