Hello
I am stumped on how to get a query to do the following:
I need to count the number of days which have fallen between a date range and then work the charges incurred both actual and projected. The date range is >date()-7 and date()+7
Is in basic terms the last seven days and the next seven days
So this is an example:
A box arrives on the 01/01/2006 and has a delivery date of 17/01/2006
I run the report on the 08/01/2006. The number of days I am charged for is 7 to date and the projected charges are 9
So i have a [Query].[Actual] and a [Query].[Future]
How do i get the query to place the number of Actual Days in the Actual Field and also place future days in the future column.
Can anyone assist?
I am stumped on how to get a query to do the following:
I need to count the number of days which have fallen between a date range and then work the charges incurred both actual and projected. The date range is >date()-7 and date()+7
Is in basic terms the last seven days and the next seven days
So this is an example:
A box arrives on the 01/01/2006 and has a delivery date of 17/01/2006
I run the report on the 08/01/2006. The number of days I am charged for is 7 to date and the projected charges are 9
So i have a [Query].[Actual] and a [Query].[Future]
How do i get the query to place the number of Actual Days in the Actual Field and also place future days in the future column.
Can anyone assist?
