You've already received good advice about not using data (month-names) as
field names. Here's one of the reasons why:

Even if you were to find a way to "automate the month fields", you would
still need to modify any/every query that refered to these fields, and
any/every form that refered to these fields, and any/every report that
refered to these fields, and any/every ... ?Get the picture? Adding fields
to add months is how you'd have to do it in a spreadsheet, but it creates a
maintenance nightmare if you try to do it in a relational database like
Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"WR Cheng" wrote in message
news
Hi,

I am creating a table that will allow me to amortize revenue. The fields
I
need for this table a
Invoice #:
Duration:
Invoice Amount:
Aug 07:
Sep 07:
Oct 07:
.....Aug 09:
Is there any ways to automate the month fields based on the duration?

Thanks