Results 1 to 2 of 2
  1. #1
    Accessnoob is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2018
    Posts
    9

    Is it be possible to create a date based summary report for this database design?

    Dear Community,


    I'm currently working on my first Access 2010 Database. In the Picture you can see the the essential structure.

    There are two general 'areas' of the database, the tables that are component/part number specific and the ones that are aircraft type specific.
    All tables that contain event related data will contain sine form of date:

    • The fleet data will already be summarized for a time frame that will be identified by the starting and stop date.
    • The part number specific events will have the date of the specific events


    Input:
    • Both part number (or disposet) as well as time frame will be provided


    Question: Will it be possible to create a query that creates a report that is part number (or disposet) specific and fills one row for each pn and month in a timeframe ?
    The report would also need to contain the aircraft specifc data which has timeframes instead of dates.
    This does not necessairly need to be possible in a single step, I'm fine with creating multiple queries that 'feed' into each other for this purpose. Only the end result matters.
    Click image for larger version. 

Name:	Untitled Diagram.jpg 
Views:	25 
Size:	212.6 KB 
ID:	32776

  2. #2
    AccessToGo is offline Novice
    Windows 10 Access 2007
    Join Date
    May 2018
    Location
    UK
    Posts
    15
    Hi, which table contains the data you want to report? Regards Chris

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

Similar Threads

  1. Create Summary Query
    By wdyl121 in forum Access
    Replies: 1
    Last Post: 10-31-2016, 03:03 AM
  2. Replies: 10
    Last Post: 09-25-2015, 05:52 AM
  3. Replies: 1
    Last Post: 11-10-2014, 06:54 AM
  4. Replies: 5
    Last Post: 12-04-2012, 02:46 AM
  5. Create/Use/Design report templates
    By accessn00b2 in forum Reports
    Replies: 7
    Last Post: 09-11-2012, 11:28 PM

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