Thank you Duane. The charts will be monthly covering over a decade and yes, there could be multiple genres and not just a single chart. --Jerry
Tue Apr 21, 2015 9:01 am (PDT) . Posted by:
"Duane Hookom" dhookom
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: Jerry in Michigan <bearjercares@gmail.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar