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
