[AccessDevelopers] Stock Balance Reports

[Bahadhur Shah]

Title: Message

Dear  All.   I want gain some idea regarding running programmed related in maintaining stock report.  For that some of query mentioned below;   1. I have table format in Data base with field containing           ID        Date            ITEM NO.   ITEM NAME        ISSUED_QTY        RECEIVED_QTY     XX        XX/XX/XX         123              ABC                        50                    100         We are entering the Issued_Qty and Received_qty with the help of separate table based form.   Actually in my table there is no balance_qty (quantity) is showed, it is maintained in query itself.  But I would like the query to notify me the balance stock available while making new entry related to issued items in the Issued_qty form.  If the balance is nil related to particular item,  the issued entry should not be acceptable.     Thanking you,   Bahadur Shah     - This message has been scanned by the DBBCG virus protection system - Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.