Dates using where exists and group by

[bobbydave]

I have an app where I can get Fiscal Year and Fiscal Period to pull a Record Count.

However, when i use the same thing to do a Fiscal Week Record Count I get zero.

I've attached the app.

I'm guessing its got something to do with the fiscal week calendar.

The next post will have the calendar attached also.

[bobbydave]

Calendar attached