Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005

    How to report data in fical year order

    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.

  2. #2
    Join Date
    Dec 2005
    Wilmington, DE - USA
    What is the first day of your fiscal year?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sorting data in a report
    By rjsiler in forum Reports
    Replies: 1
    Last Post: 08-04-2008, 01:40 AM
  2. inport data into invoice from Purchase order database
    By Wrangler in forum Import/Export Data
    Replies: 2
    Last Post: 10-30-2006, 12:28 PM
  3. Report SQL/Data in Access
    By artfuldodger in forum Access
    Replies: 2
    Last Post: 09-01-2006, 07:38 AM
  4. Finding data between two date for any year
    By gemini2 in forum Access
    Replies: 4
    Last Post: 04-05-2006, 06:20 AM
  5. Run report or sub form during data entry
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 03-09-2006, 05:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums