Theres one video missing no.3 how can i get that video to continue  the project

best regards

Mamoun Madi

Auto PO Process Smart Inventory | Master Business Accounting 28

at 30:14 i solved the issue in following way; frm_Stock was bounded with a query "q_Stock". In the expression builder it was StockStatus: IIf(=0,"Zero Stock",IIf(<,"Low Stock","Stock Ok")). I changed it as StockStatus: IIf(=0,"Zero Stock",IIf(<,"Low Stock","Stock Ok")). I applied this change becasue i noticed that in "tbl_Items" we are changing ItmOTotal field througout this tutorial series. It solved the issue and now frm_Stock shows correct StockStatus. I want to know is this method is fine or we have to do some other changes? Is it the correct way?

I just want to share a valueable tip if you want to get the number format as a standard with one digit after decimal place then it can be useful if you write the SQL query in Video No: 20 

SELECT *
FROM (SELECT AcCommonID, AcSubNm AS NM, "G.Account" AS Type, AcCommonID, Nz(format(,"#,##0.0"),0) AS AcB FROM tbl_ChartofAccountsSub UNION SELECT AccCode,CName AS NM, "Customers" AS Type, AccCode, Nz(format(,"#,##0.0"),0) AS AcB FROM tbl_customer UNION SELECT AccCode,SName AS NM, "Suppliers" AS Type, AccCode, Nz(format(,"#,##0.0"),0) AS AcB FROM tbl_supplier) AS ;

I have noticed that int() function outside the format() is destroying the desired output result showing numbers only but not any comma or decimal place. However i used Nz function and format fuction. It worked for me.

I dont know why our tutor used ids fields twice i.e. AcCommonID, AccCode for customers and AccCode for suppliers?