I am not sure if this is a VBA question or an Access question but I have to create a report that list the data in ascending date order but it has to be broken down by fiscal year instead of calendar year.
Here is an example of what the report need to look like:
Corp Id Corp Name Violation Date Amount
1234 abcd violation1 1/26/1994 $500.00
4567 efgh violation1 3/11/1994 $4,200.00
8910 ijkl violation2 5/24/1994 $1.650.71
Total $6,350.71
1234 abcd violation2 12/26/1994 $1,500.00
4567 efgh violation3 1/05/1995 $6,000.00
8910 ijkl violation1 6/13/1995 $680.00
Total $8,180.00
Do anyone have any idea how I can accomplish this in access or do I need to code with VBA and if so can you give me some idea on how to go about this.