If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|