Results 1 to 4 of 4

Thread: What function can i use in Access to manupulate a single figure

  1. #1
    Join Date
    Aug 2007
    Posts
    2

    Arrow What function can i use in Access to manupulate a single figure

    Iam currently working on an Access database but am finding it very hard to reduce the Total number of products in the stock table every time a single product is sold. This may be difficult to understand but consider a super market whereby every time a sale is made, the inventory levels reduce. pliz help

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Does access have something like 'update table set col = col - amount where ...'?

  3. #3
    Join Date
    Nov 2007
    Posts
    1
    he is write dear
    update ur table time to time
    by using
    update tab set value=" " where produact="xyz";
    u may use trigger

  4. #4
    Join Date
    Dec 2007
    Location
    Pennsylvania
    Posts
    1
    I recently rejoined the workforce after seven years of being a housewife. I now have a job where I do alot of data entry in Access, Word, Excel, QB, etc. I vaguely recall a feature in Data Entry where if you have a long string of text that you use often, you can program one of your Function Keys to rembember that text string. Does anyone know how to do this? Your help will be greatly apprecitated.

Posting Permissions

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