What is the best way to organize data that is by month and year?

[shelbsassy]

I am building an Access database with data that I have been collecting in Excel spreadsheets. I am uncertain if I am going about this the right way.

I report every month on categories with the total tickets, resolved tickets and dispatched tickets.

I previously had thought that a table with MonthYear (text field of Jan-2011 input mask) would be best in joining it with an Activity table that had MonthYearID in it.

Is this the best way to go about this design? The Activity table has ID, MonthYearID, CategoryID, Total Tickets, Resolved Tickets and Dispatched Tickets.

Right now I am trying to figure out how to get the data in the db without manually entering it. I have done a few imports to a temp table and then an append query but I still end up manually updating the table with the MonthYearID.

I am new to access, this being only my 2nd db, a little more complex than the first. Thanks for any help.

Regards,


Shel

[orange]

Total Tickets, Resolved Tickets , Dispatched Tickets sounds like some sort of Help Desk

There is a free data model here that may help with Tables and layout
http://www.databaseanswers.org/data_...desk/index.htm

There are other models at databaseanswers.org also