Combining 84 tables with one query...help!

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,

I'm making a database for my college's radio station. They want each
DJ to have his/her own little table to keep track of which songs are
played on each show.


The problem is that I need to combine all these tables to be able to
sort them.

In each table, I have an autonumber assigned for the song number
(purely because access put it there), fields for the artist's name,
song name, album name, track number; then a yes/no box for whether the
song is in "rotation" or not (our DJs must play 4 of these "rotation"
songs per hour of their show). Is combining necessary? All I need to
do is compile a list of how many times each "rotation" song was played
accross all the tables...I'm more than willing to do any tweaks to the
table layouts to get this to work.

Thanks!
Rick Heil

.

Relevant Pages

  • HOW DO i MAKE A LIST FOR SONGS?
    ... The "database" I have created is very ... in my collection I have a song title: ... that appears on 3 different albums and by 2 ... the "search criteria". ...
    (microsoft.public.excel.worksheet.functions)
  • Re: WMP 10 and Playlist
    ... Congributing Artist is most likely NOT the main singer of the song. ... on the internet to fill WMP fields when a CD is ripped) to the WMP fields. ... when you rip a CD unknown to the internet database you can ...
    (microsoft.public.windowsmedia.player)
  • Re: Classes required for an application
    ... the database before the business objects. ... an application supports the business objects, ... of song information," you should think of the application as a tool for ... can be desrcribed by a user making a rating for a song. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Music site - Music Genome Project!
    ... > the artist and song. ... You can stump it with obscurity, but the database ... Taj Mahal ... Mahal's recording of Statesboro Blues with Ry Cooder on slide, ...
    (alt.guitar.amps)
  • Re: WMP 10 and Playlist
    ... Album artist MIGHT be the same as the artist singing the song. ... on the internet to fill WMP fields when a CD is ripped) to the WMP fields. ... when you rip a CD unknown to the internet database you can input the info manually. ...
    (microsoft.public.windowsmedia.player)