Service to Cost by Quarter HELP!!!

[campanellisj]

Thank you all in advance to whom ever can help me with this problem. I have been working on this DB for several weeks and this problem has stumped me.
I have attached a copy of the database as it will be easier to see than just reading text.

I have several tables and will attempt to explain:

(TblsGarrisons) is a list of 15 garrisons
(tblCommonLevelofSupport) is a list of 349 common services provided by each post. With each garrison providing each service. 349*15 = 5235 records
(tblCost) is a table containing each cost catergory
(tblYearList) contains the year value of 2010 and 2011
(tblFiscalQuarter) is a breakdown of the year (2010 & 2011) into 4 Quarters

All the other tables in the DB are fine and from what I can see have no bearing on the cost in anyway so I didn't list them.

I have succesfully linked each garrison with each service (hence the 5235 records) but my problem is somehow connecting each of those cost into each quarter. I have succesfully broke each year (tblYearList) into four quarters (tblfiscalyear) and linked them, I just can't seem to get the middle piece to this puzzle

This is difficult to explain; for instance: Ft. Bragg (tblgarrisons) provides service 8A (tblcommonlevelofsupport) what was his cost breakdown for each quarter for FY2010?



I have tried everything but it al results in duplicating records or an increase in records etc... I know this is a bad example but it's the best I can do at the moment.

[NTC]

I have not looked at your zip.

In regard to your example; "Ft. Bragg (tblgarrisons) provides service 8A (tblcommonlevelofsupport) what was his cost breakdown for each quarter for FY2010?"

why is not the quarter cost simply .25 * the annual cost listed in tblCommonLevelofSupport ?

[campanellisj]

to answer your question... each garrison is given a different amount of money to use each year, per service, per region etc....
If I just took .25 we would be assuming they have budgeted thier total into 4 eaqual parts and that is not the case. I need to know what they spent per quarter not how they broke up the total given.

It's a wierd situation to explain, but my problem still resides that I can not link the cost by quarter by service by garrison

[evander]

Could you give us a spreadsheet layout of the report you want to achieve?
I'm creating a sample DB right now and I'll be uploading it in a few minutes.

[evander]

I'm giving you a sample solution.
Good luck.

[campanellisj]

the DB is attached to the first post.