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

Expert users please help me.

any one can help me here ...


--kal

Sam, I understand the sample table you have provided and how it is structured...what I am not understanding is THIS...

sam536 said:

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.

Click to expand...

Why does it have to correspond to the closing month?? Your example table has numbers in other month's fields as well as the closing month field.

sam536 said:

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.

Click to expand...

I assume this means that the MARCH field AND the "total revenue" field will both hold the sum of all other fields?? That's the way I read it...

By the way, if people don't respond to you here, usually it's because...

A) They don't understand your post, OR
B) It is too long to sift through, OR
C) There is no relevant information or enough information given to help solve the problem.

Just letting you know...

I agree with ajetrumpet, plus they tend to be a little reluctant if they suspect this is a homework assignment. Your tutors get paid to help you, we do it for free.

And please don't post the same question in different parts of the forum. It pi**es people off.