Recent content by Frank64

It looks like I put my question under a wrong heading. Heading should reading something like, Stock Balance query..

I wish my mentors will direct me basically with MS Access instructions as to how to calculate the balance of stock, having the sum of all credits as against the debits on the condition that, stock items that have not been issued will still be output.

Hello Gina: Thanks for the submission. It seemed more of VB instruction or syntax which I am not good at. Hope to get there later. Regards,

Yep! That worked for me. Now that, that hurdle is resolved; Can we find solution to this as well.. I have created an inventory program upto the point where I need a query to calculate the difference between Stocked items and issued items. Per the formula I was able to write, it just substracts...

Thanks. I think this what I am looking for. Though I will have to practice this to see if I get the desired result. I know, I will have to check my relationships as well. Regards, Frank

Hi All: I want to pose a new thread rather: Can one kind person demonstrate how sub forms can be created for a Purchase Order form which have an anticipated fields as PO No, Orderdate,Supplier,ETA, Currency and OrderDetails as the sub menu with fields as PO no, Partno, stockno, Description...

The Doc Man: Thanks a lot for your feedback. I think it makes a lot of sense that the data has to drive the program. After all in our conventional life, one will have to move from the known to the unknown. Regards, Frank

Thanks for the insightful thoughts.

Hi Dave: I must acknowledge, your response makes a lot of sense to me. Others had thought that,the question was irrelevant but I think one's ability to raise any good program will be relative to the workflow chart one is able to draw from the scratch. In view of that, your response appeals...

Please what drives the setup of a database? Is it the desired reports or the readily reachable data for table formulation?

Please my name if Frank Agyemang from Ghana, about 50yrs. I am an Amateur MS Access programmer. I want to learn the application well or polish it up and if possible learn VB well.