Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   editing data in multiple fields in ms access (http://www.go4expert.com/forums/editing-data-multiple-fields-ms-access-t6682/)

sam536 5Oct2007 06:14

editing data in multiple fields in ms access
 
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.


Regards,
kala


All times are GMT +5.5. The time now is 19:54.