ms acess query

[kala536]

Hi,I am new to database work.I have to write a query to design a report basaed on the data coming from raw table.I have a table which contains sales information like deal name,code,closing date of deal,total revenue for the year and probability.I have to write a query to get the new data based on the table containing raw data.
My query should contain monthly revenue and quarterly revenue based on the fields closing date and total revenue.ex:If the closing date for a particular deal is mar-08 then the total revenue entered in revenue field should get updated in a new field [march month].Please help me how to build a logic for the query.I have to design a report based on this information and source should be one table.

Any help would be appreciated...

pls help me thanks in advance...


below table givesidea to build a query:
Closing date Jan Feb Mar Apr May Jun Revenue Q1 Q2 Q3 Q4

Mar-08 1,500 1,500 1,500 0 0 0
Jun-08 4,000 4,000 0 4,000 0 0
Dec-08 6,000 6,000 0 4,500 0 6,000
.............................
..............................

Regards,
Sam

 

[JerryKlmns]

What's wrong with this thread700-1415225 you started yesterday?