ms 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

 

[statsman]

In your query under the "Closing Date" enter the following in the criteria line:

Between [Start Date] And [End Date]

When you run the query it will prompt you to enter a Start Date and an End Date.

The data returned should only be between those 2 dates.

You can enter it for months - example - Start Date: April 1 - End Date: April 30
or for quarters - Start Date: January 1 - End Date: March 31
or any other time frame you wish to enter.

 

[truhavoc]

In your query under the "Closing Date" enter the following in the criteria line:

Between [Start Date] And [End Date]

When you run the query it will prompt you to enter a Start Date and an End Date.

The data returned should only be between those 2 dates.

You can enter it for months - example - Start Date: April 1 - End Date: April 30
or for quarters - Start Date: January 1 - End Date: March 31
or any other time frame you wish to enter.

This helps with my question as well, but say you need totals for your monthly values (imputed daily by various users). It seems like there should be a fairly easy query to find a total for a date range but I can't seem to get it without being broken down as total for all users per day (ie 31 individual values). Any help would be greatly appreciated.