access query

[sam536]

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

 

[coyote]

Sam to get help in this forum or any forum you have to be clear as to what you are asking.
In your query do you want to total the months entry? or you want the results quarterly.
From what I can get from the post you may require more than one query
Please Sam can you be clearer and you will get an answer

 

[ajetrumpet]

Coyote,

This topic has already been covered here. There was no response to the reply that was given.