"TA" <TA@discussions.microsoft.com> wrote in message
news:242E9072-BFAC-4142-AFDA-828F6957D9CC@microsoft.com...
> Hi
>
> I am writing a report that reports on Sales and Budget, of course I can
> filter sales by transaction date, but the budget is a little bit harder.
>
> The buidget covers a hole month, so what I have to do is to calculate the
> budget amount by deviding, but if the month end in the middle of the week,
> there is where my problem starts. how do I work out the difference for the
> week between the two months?
>
> I have not been ableto work out how to handle this.
>
> Has anybody out there doen this before who can help?
>
> King regards
>
> TA