Using Dbase to spread monthly costs

[Mark]

I have a 10 year program that has monthly charges I want to populate the same
amont every month for 120 months. How do I set-up a query to have months as
column titles and populate the monthly charge.

Thanks....

 

[Mark]

OK...poor explanation on my part.

I have a table with the following fields:

- Monthly amount
- Start date
- End date

I want to create a table that allocates the Monthly amount to each month
starting with the Start date, and ending at the End date.

Mid month start or end is will still occur in that month.

ie: If the monthly amount is $100, the Start date is 5-Jan-05, the End date
is 15-Mar-05, then I need a table output that allocates $100 to January, $100
to February, and $100 to March. There will be hundreds of records spanning
10 years, so the resulting table will be fairly large.

Hope this clears up my cryptic initial question.

Thanks....

I have a 10 year program that has monthly charges I want to populate
the same amont every month for 120 months. How do I set-up a query
to have months as column titles and populate the monthly charge.

Thanks....

Well let's start from the beginning.

dBase is a specific database and is not Access. I will assume you
really wanted to say database.

Databases do not have columns. They may display fields or other data in
columns, but they are not spreadsheets.

You don't populate fields (sort of like a spreadsheet cell) with
computed values, you compute the values when you need them, like on a
report.

In a report, you would use a formula something like " 0.0833 * [Annual
Amount] " where the "Annual Amount" is a field storing the total in a table
for the year.

I know this is not much detail, but frankly learning about databases and
IMO Access in particular has a very steep learning curve. and at this time
it sounds like some general basic database instruction should be your first
goal. The help files are good and the Northwind example can be very
helpful when getting started.

I don't want to discourage you. Access is worth the effort to lean, but
don't expect simple fixes. If you go for it, there are a lot of people here
to help you along the way.

 

[Mark]

I'm pricing a 10 year job. One part of the bid is a long list of SW products
that will be deployed at different times. Thusly, the SW Maintenance will
start a different times depending on the deployment schedule. The figure
that the SW vendor will give me is a monthly maintenance charge. We will
come up with the deployment schedule, but that will also dictate when the
maintenance charges start and end. Thusly, I want a query to analyse when
the monthly charge will start, apply that for every month until the end date.
This will occur for every SW product in our solution.

Thanks....