Hi
This is my first post.
I am creating a DB for the first time, and need some advice please.
I am creating a DB that will be rolling on a month-month basis.
i.e Jan, Feb, Mar etc... and then Year
do I need to create two separate tables one for month and one for Year?
or can I use the a field and just use the date data type and remove the day part? (is this possible)
what would be my ideal way of doing this?
This is my first post.
I am creating a DB for the first time, and need some advice please.
I am creating a DB that will be rolling on a month-month basis.
i.e Jan, Feb, Mar etc... and then Year
do I need to create two separate tables one for month and one for Year?
or can I use the a field and just use the date data type and remove the day part? (is this possible)
what would be my ideal way of doing this?