Search results

Isskint, Can you help me out a tiny bit more if possible? The first critical step in your method is determining if the expenditure occurs within the start and end dates- is it possible to slightly modify this? I would like calculate all possible expenditures given the data set until the end...

Finally got around to working on this, works great! Thank you so much for your help! You made my weekend.

Isskint, Generating a table seems to most appropriate approach, I agree after more reading online. Yes, the logic makes perfect sense and is what Im after. One small change (if possible) would be that the origin year doesn't need to be within the start and end date, just the expenditures...

Makes sense, I am guessing an SQL query could also be a bit slow. How does one even start with the vba macro to develop this ? Can you point me in the right direction? Should I post a sample db?

I have a pile of varying data all the time that once all the expenditures are generated, make using access for reporting so much sweeter....that why im trying to use access

Some additional explanation..... I'm trying to build a query which lists all expenditures associated with multiple items, within a time period. The time period is the defined by the start year (BaseYear) and the period of analysis (AnalysisPeriod) + BaseYear. Thus is the base year is 2000, and...

Some additional explanation..... I'm trying to build a query which lists all expenditures associated with multiple items, within a time period. The time period is the defined by the start year (BaseYear) and the period of analysis (AnalysisPeriod) + BaseYear. Thus is the base year is 2000, and...

Anyone have an idea for this?

Isskint, Thank you very much! I sincerely appreciate it. J

Hi All, Very new, but I thought I would post here as I imagine a solution would be a macro that one passes variables to... Hi All, I am a huge NOOB here, so please bare with me I have Query1 which I would like to add a record set called Expenditure Years to. The Expenditure Years are...

Anyone out there whom may lend a very much appreciated helping hand?

Hi All, I am a huge NOOB here, so please bare with me ;) First post and Im really hoping that someone can help me out. I have Query1 which I would like to add a record set called Expenditure Years to. The Expenditure Years are calculated based on multiples of the YearReplace record set...