On Thu, 29 Oct 2009 07:58:08 -0700, Steve D
wrote:

I get what you are saying but I would like to understand better how the
database works. Why is it better to use the full date and have many records
than to use one table with 12 months and one table with the years?
I felt like I needed the Year table. I am using the database to manage the
budget and forecast cycles, so I have a table called tblCycle and I wanted to
be able to relate that with a year so I would be able to pull the 2007
budget, etc.., but now I think I could just query using the month field or
Year([dtmMonth)].

Am I on the right path?

Yes... but you need to keep going.

You seem to have a bias that you must have a separate table for everything.
You don't!

With proper indexing and proper query construction, you can *VERY EASILY* and
efficiently construct a query to extract any calendar year, or fiscal year, or
month, or any other time interval from your table, using just a Date/Time
field. You certainly do NOT need a table of months or a table of years to do
this.
--

John W. Vinson [MVP]