Phasing of values
- Thread starter IainG
- Start date
Access Hero
Registered User.
- Local time
- Yesterday, 18:17
- Joined
- Oct 29, 2008
- Messages
- 96
Can anyone tell me how I can phase a value (Linear) between 2 dates?
I consider myself a moderately intelligent guy but I have no clue what you're asking for. Can you re-state the problem?
- Local time
- Yesterday, 18:17
- Joined
- Feb 28, 2001
- Messages
- 30,400
If by Phasing you mean that you want to generate records for every day between two different dates so as to populate a table with one record per date, I suggest that this is BEST done using VBA code. However, every time I see such a request, I immediately think that something else is wrong with the structure.
What is the underlying problem that would require you to populate a table with a series of dates between two limiting dates?
What is the underlying problem that would require you to populate a table with a series of dates between two limiting dates?
I am trying to phase a budget across a specific period that I expect the budget to be spent. Say I have £100 and want to phase it between 01/03/09 & 31/12/09. The calc would need to determine the number of days (per month) between the 2 dates and then be used to divide the budget up accordingly and possibly stored by month too!
Hope this explains better.
Cheers
Iain.
Last edited:
