MICHELE

[MICHELE]

I have a report with date criteria. The beginning and ending date will usually be in the middle of a month, probably covering2 seperate months. I have weekly and monthly totals.
The weekly totals will occur in the middle of a week if the month ends in the middle of the week and then at the end of the week too. I need a full week total on Saturday which includes both months.
Also, I need to be able to see the total month's total which may include amounts outside my criteria range.
Are these 2 things possible?

 

[The Red Star]

try explaining that again... i can't work out what you're trying to do.

 

[Rich]

You'll need separate queries / subreports to do this, you'll have to have a function to get the first and last days of the months you require from your parameter dates.

 

[MICHELE]

That is kind of what I thought and told my boss. Then someone else told him it could be done. I wanted to see what people on this site said.

Thank you!