Jerry,
Not separate tables! I don't know much about song charting in terms of granularity. Are charts/rankings posted only monthly or weekly or other? Are there multiple charts?
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 21 Apr 2015 11:47:18 -0400
Subject: [MS_AccessPros] Monthly Chart Tables ?
I'm working on a database for a publishing company to show their copyrighted songs that charted over a period of years. I'm trying to wrap my brain around the best way to show that the same song charted for multiple months. Is it best to create a date field that will be able to isolate everything in queries, or would it be better to have separate tables for each month, probably not?
Thanks,
Jerry in Michigan, USA
Not separate tables! I don't know much about song charting in terms of granularity. Are charts/rankings posted only monthly or weekly or other? Are there multiple charts?
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 21 Apr 2015 11:47:18 -0400
Subject: [MS_AccessPros] Monthly Chart Tables ?
I'm working on a database for a publishing company to show their copyrighted songs that charted over a period of years. I'm trying to wrap my brain around the best way to show that the same song charted for multiple months. Is it best to create a date field that will be able to isolate everything in queries, or would it be better to have separate tables for each month, probably not?
Thanks,
Jerry in Michigan, USA
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar