Is there any way to create sums based on a weekly range?

[plog]

It is suppose to show a week range (e.g. "6/23/2014 - 6/27/2014") based on the date you pass it.

I wouldn't advise trying to shoe horn this into your existing query. You should build a new query using that initial query as its data source.

 

[Kellen]

I did that and it still shows up blank.

Could it be because my dates are converted from 20140101 to 1/1/2014 using Cdate.

Everything else is perfect. I'm so close.

EDIT:
I created a new table with regular dates to test to see if your function works and it still came up blank. How did yours work, can I see it?

 

[plog]

Here's my database that has the query and function in it and it works.

 

[Kellen]

I got it to work once as a test but accidentally deleted it and now I can't do it again. Crap.

 

[Kellen]

Thanks a bunch Plog I got it to work.