Date Problem

[dinadvani via AccessMonster.com]

Hi,

I have a Query in which there is a projected date and projected revenue. Now
these details are daywise details but what i want is monthwise details and
then when a user clicks it shows the details.

I tried changing the date formats to month format it was done but when i made
a query wherein i grouped Projected Date and sum of revenue. That didn't made
any difference and output was as below

January-2007 1000
January-2007 50
January-2007 25
Feb-2007 10
Feb-2007 5

Please advice
Thanks
DA

--
Message posted via http://www.accessmonster.com

[Allen Browne]

Re: Date Problem

Use a Totals query:

1. Create a query using this table.

2. Depress the Total button on the toolbar.
Access adds a Total row to the grid.

3. In the first column of the Field row, enter this expression:
TheYear: Year([projected date])
Accept Group By in the Total row under this field.

4. In the next column, type this into the Field row:
TheMonth: Month([projected date])
Accept Group By under this field again.

5. Drag the projected revenue field into the next column.
In the Total row under this field, choose Sum.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dinadvani via AccessMonster.c om" <u22798@uwewrot e in message
news:6bad7ee028 75b@uwe...

Hi,
>
I have a Query in which there is a projected date and projected revenue.
Now
these details are daywise details but what i want is monthwise details and
then when a user clicks it shows the details.
>
I tried changing the date formats to month format it was done but when i
made
a query wherein i grouped Projected Date and sum of revenue. That didn't
made
any difference and output was as below
>
January-2007 1000
January-2007 50
January-2007 25
Feb-2007 10
Feb-2007 5
>
Please advice
Thanks
DA