Products Quantity remaining calculation in Microsoft Access | Simplified Inventory Database

Simplified Products Inventory in MS Access
Hello family,
thanks for tuning into this Microsoft Access database tutorial. In this video, I share with you on a simplified Inventory tracking database in Microsoft Access.
How to correctly show Quantity at hand for products in a database.
Subscribe if you are a newbie.
Link to Lesson file:
drive.google.com/file/d/1CDS8...
Follow me on my social media handles at:
Instagram: Arkosmaila
Tiktok: arko smaila
Facebook: Arko Smaila
EMAIL: [e-mail]
Thanks for watching.

[@miky75168]

very informative and straight to the point

[@datatechstutorials]

Thanks and glad it helped

[@DataPulze]

Salute, Arko!

[@seyaradvids-kl3sz]

Yes it worked thank you I appreciate your work

[@datatechstutorials]

you're welcome

[@kaziehteshamurrashid5098]

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

[@datatechstutorials]

I appreciate

[@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.

[@SothearakHeng]

Thank you for the video

[@haaruunhasan2621]

Thanks You helped me

[@datatechstutorials]

glad it helped.

[@kaliisaanthony1441]

Thanks you Sir

[@liveoffline4317]

Excellent video very helpful

[@datatechstutorials]

Glad it was helpful!

[@sumonshawon8901]

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

[@datatechstutorials]

Most welcome

[@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

[@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

[@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

[@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.

[@user-or2if3re3t]

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?

[@user-or2if3re3t]

@@datatechstutorials Done.

[@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

[@ezswan]

What version of access is this?

[@datatechstutorials]

2016

[@hengveasna7573]

2

[@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.

[@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