Is there any way to create sums based on a weekly range? (1 Viewer)

plog

Banishment Pending
Local time
Today, 14:59
Joined
May 11, 2011
Messages
11,611
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

Registered User.
Local time
Today, 12:59
Joined
Jun 26, 2014
Messages
44
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?
 
Last edited:

plog

Banishment Pending
Local time
Today, 14:59
Joined
May 11, 2011
Messages
11,611
Here's my database that has the query and function in it and it works.
 

Attachments

  • test.mdb
    288 KB · Views: 88

Kellen

Registered User.
Local time
Today, 12:59
Joined
Jun 26, 2014
Messages
44
I got it to work once as a test but accidentally deleted it and now I can't do it again. Crap.
 

Users who are viewing this thread

Top Bottom