Products Quantity remaining calculation in Microsoft Access | Simplified Inventory Database

[@miky75168]

very informative and straight to the point

[@datatechstutorials]

Thanks and glad it helped

[@seyaradvids-kl3sz]

Yes it worked thank you I appreciate your work

[@datatechstutorials]

you're welcome

[@biospricularmedia4643]

It's amazing tutorials and useful

[@datatechstutorials]

Glad you think so!

[@akee1618]

Informative. Thanks 👍

[@datatechstutorials]

Glad it was helpful!

[@mohei95]

Very nice video but you need to record in more quiet place.
Also you can solve the remaining quantity by adding nz function to the remaining quantity instead of adding it to stock in and out. Yes it's nice to solve it by adding nz to stock in and out to give you 0 instead of empty transactions but by the way you can add nz to the remaining quantity
Thank you for your effort

[@datatechstutorials]

Thank you for commenting sir.

[@liveoffline4317]

Excellent video very helpful

[@datatechstutorials]

Glad it was helpful!

[@DataPulze]

Salute, Arko!

[@kaziehteshamurrashid5098]

I agreed with Nigel. Also do not use any special character in the table structure under Field Name.

[@datatechstutorials]

I appreciate

[@haaruunhasan2621]

Thanks You helped me

[@datatechstutorials]

glad it helped.

[@sumonshawon8901]

Good Job Sir............Nice Video Sir.............Thanks

[@datatechstutorials]

Most welcome

[@SothearakHeng]

Thank you for the video

[@kaliisaanthony1441]

Thanks you Sir

[@richardmeborg4717]

Hi. Thank you for claryfiying this issue.
I want to know, how can i show the remains in the product form?

[@datatechstutorials]

create a form and place in the product form as a sub-form

[@mohyeeali736]

Excellent work, how can i but a criteria in the remaining query ?

[@datatechstutorials]

Come clearly sir

[@mosjany]

you are gifted
ok I want a data base where you can manage pledges and drediming of the pledges and balances

[@datatechstutorials]

Thanks so much. you can contact me via mail or whatsapp. check the description

[@asaduwilliam8612]

Why did you select "Expression" for the remaining quantity aggregate query please

[@datatechstutorials]

yes expression builder is way more interactive.You can equally use the zoom

[@YousafBaig-wz3ih]

can you share a video on Stock minus using invoic sale,, can you show

[@datatechstutorials]

Hello Baig, thanks for suggesting this. Will work on a new video soon abt the topic. Thx

[@مصنعرمزاحترافللمنتجاتالورقية]

perfect for what im trying to do,
except one tiny problem,
im adding: StockIn from Item A qty of 10000Pcs
then adding stockOut from Item A qty of 7000pcs
now i should have 3000 left (remains) correct
...................
the issue is: now when I add 3000-4000 or any number as STOCKOUT
it substract it from the (10000) not from the 3000 that's left, why ?
each time i add stockOut from item A it dose not update the value,
still removing from the original value

[@datatechstutorials]

Sorry sir. Can you send email?

[@مصنعرمزاحترافللمنتجاتالورقية]

@@datatechstutorials Done.

[@gideonngetich935]

Hello... What if the stock level are at 0 then you continue stocking out, the quantity at hand will be at negative values. How can i solve that issue

[@datatechstutorials]

VBA used to validate quantity input.

[@ezswan]

What version of access is this?

[@datatechstutorials]

2016

[@sudhiryadav1579]

9.01 min not visible what u have done

[@nigelfranco5755]

I highly recommend you do not put spaces in your field names

[@datatechstutorials]

Noted with thanks

[@mikewashington4188]

I suggest using the underscore characters instead of a space in table column names for example zip_code

[@datatechstutorials]

@@mikewashington4188 Thank you contributing sir. it's noted.

[@hengveasna7573]

2

[@shamimtvkids]

Can you help Create User interface this database? An send me my Email. Its very need for my shop management. Plz Email me fully completed database with UI design.

[@datatechstutorials]

I think it's best to check video description and send your request via mail. Thx

[@mahomedjuma]

i need your email so i can contact you

[@datatechstutorials]

Please check the description of any of my videos including this. It's best you WhatsApp me pls. Thx