00. Intro (1:59)
01. Simple Fiscal Year Query (9:17)
Create Order Table
Simple Fiscal Year starting 6/1
YEAR function
MONTH function
IIF function
02. Sales Totals by Fiscal Year (5:47)
Aggregate Query
SUM of Sales by Fiscal Year
Order Totals
Order Report
Group and Sort
Group, Sort, and Total
03. Fiscal Not 1st of Month (10:19)
Create your own Function
Public Function MyFiscalYear
Function Parameters
Function Return Value
IF THEN statement
DAY function
Nested IF statements
04. Multiple Companies (9:50)
Variable Fiscal Start Month Day
Additional VBA Parameters
Tables Joined in Query
Orders By Company By Fiscal Year
05. Review (2:17)