Query Multiple Tables in Access 2002?

[Josh Davis]

I have a HUGE song collection and would like to set up a database in Access
to help me reference them much more effiecently than looking for a particular
song or song duplicate by the long route. Any suggestions? I already set up a
few of the songs albums in a track list format in tables, one table per album
if that helps.

 

[pietlinden]

I have a HUGE song collection and would like to set up a database in Access
to help me reference them much more effiecently than looking for a particular
song or song duplicate by the long route. Any suggestions? I already set up a
few of the songs albums in a track list format in tables, one table per album
if that helps.

Create a database for it?
very much simplified design...

Artist---(1,M)---Album---(1,M)----SongTitle

not totally accurate, since an album need not be written/performed
entirely by a single artist. Nor does one song necessarily get
released on only one album. (Imagine a Greatest Hits album...)

but that should get you started...

And posting the same question 3 times in 15 minutes is NOT going to
get you help any faster. Nobody here gets PAID for answering
questions, so if you need an answer fast, PAY FOR IT.

 

[Josh Davis]

Thank you for NOT PAYING ATTENTION TO MY POSTS! I only posted it 3 or 4 times
cause when i sent the post to be uploaded it gave me an "error sending post"
no matter what browser i use, so it was not on purpose! Then a few minutes
later all 4 attempts were posted so needless to say i only post one time and
wait for it to post. even with the stupid error i get. If had you taken the
time to READ each post you would see had i posted it 4 times in succession
every post would be identical but for the sake of maybe two are worded
COMPLETELY different. Seeing as how I had to TYPE them MULTIPLE times in an
attempt that maybe the error had self resolved itself. By the way what you
posted was complete nonsense! My advice to you dear sir/madam is to do your
"homework" before ridiculing others instead of assuming they did something
for mear spite or to get their question more exposure. Good Day to you.

 

[Douglas J. Steele]

And if YOU'D taken the time to read Piet's post, you'd see that before he
commented on the multiple posts, he suggested the correct answer to your
question which you completely ignored it in your diatribe.