View Single Post
  #1  
Old October 27th, 2009, 07:20 PM posted to microsoft.public.access.tablesdbdesign
Steve D
external usenet poster
 
Posts: 48
Default Organizing Table

Good Afternoon,
I have a very basic question regarding the organization of my table. I
will have monthly data that will be entered and it will be for various years.
Is it better to use one field called month and do a crosstab query or should
I have 12 fields (one for each month)? My thought is that it is cleaner if
each month has its own record but then I will have 12 times the number of
records. Thoughts? Best Practices?
--
Thank You,
Steve