editing data in multiple fields in ms access

Discussion in 'MS Access' started by sam536, Oct 5, 2007.

  1. sam536

    sam536 New Member

    Sep 25, 2007
    Likes Received:
    Trophy Points:
    Hi,I have a table which contains sales information like deal name,closing date of deal,Monthly revenue information,total revenue yearly also quarterwise
    information.The below table gives some idea....
    i want to enter data in multiple fileds ex:when I enter revenue amount it should get updated in corresponding month based on the closing date information.Suppose closing date for a particular deal is mar-08 then the total revenue entered in revenue field should get updated in march month field.Please help me how to edit data in multiple field and also logic to apply to solve my problem.I have to design a report based on this information and source should be one table so i want to edit data in main table.

    Any help would be appreciated...

    I am new to ms access database so got stuck..pls help me

    Closing date Jan Feb ar Apr May Jun Revenue Q1 Q2 Q3 Q4

    Mar-08 1,500 1,500 375 0 0 0
    Jun-08 4,000 4,000 0 0 0 0
    Jun-08 6,000 6,000 0 4,500 0 0
    Jun-08 3,000 3,000 0 0 0 0
    Jun-08 1,720 1,720 0 0 0 0
    Jun-08 20,000 20,000 0 0 0 0
    Jun-08 2,000 2,000 0 0 0 0
    Jun-08 20,000 20,000 0 0 0 0

    please help. its urgent.. Thanks in advance.


Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice