Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Unanswered: Help... with my table

    hi there... im creating a database to reduce mistakes for data entry purpose.

    table 1: product code | received quantity etc..
    table 2: product name | vendor name etc..
    form 1: product code | received quantity etc..

    result : product name| product code| received qty| vendor name

    my question;

    the operator will input using form 1. i want that the received quantity is accumulated in table 1, everytime the operator input received quantity for a same code....

    e.g:

    code item qty
    343343 Tshirt 200
    343343 Tshirt 120

    so the result will appear the total as below

    343343 Tshirt 320 and not repeated data...

    please guide..

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Please could you tell us your exact table structures? This will be important to getting the correct answer.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Apr 2009
    Posts
    2
    hello



    im attaching my workbook here...

    the operator will key in entry by using 'Data Update' form.



    i want if the same item key in repeatedly, the received quantity is totalled and not repeated record.



    and, how to add formulas... for example, in 'stock amount', i want to add 'unit price' x 'opening stock'.



    please guide...



    million thanks..
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •