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.