Re: Combining 84 tables with one query...help!

Tech-Archive recommends: Speed Up your PC by fixing your registry

Are the DJ's working from their own machines, i.e. laptops?

You should have a master database and append each DJ's work. The
synchronising functions of Access are built for this sort of task, or you
could import new data as CSV files.



"refreshingapathy" <refreshingapathy@xxxxxxxxx> wrote in message
news:1160630119.355185.192120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

  • White Album + 40
    ... (Lennon/McCartney) ... PAUL 1968: "Chuck Berry once did a song called 'Back In The USA,' ... And it's a very American sort of thing, ...
    (rec.music.beatles)
  • JWH: INVOKED ALLEGORY
    ... JWH is different. ... The title track is a sort of story about an outlaw, ... It is not as specific a song as Pretty Boy ... allegory, or a strict narrative. ...
    (rec.music.dylan)
  • Re: Change Just One Word
    ... >it comes to "I lost my wife"...but Springsteen's gone ahead and taken care ... A case where real life seems to have improved a song :-) ... > accept that sort of ambiguity and vagueness is Dylan. ... Mansion a nice country feel many times from Joad to ...
    (rec.music.artists.springsteen)
  • Re: Song Display in Library.
    ... You can't sort descending sub-grouped by album or ascending grouped by first letter. ... If I have several collection CDs containing the same song by the same artist, I may want to rate the original higher than the collections because if I have 5 copies of one song I will hear it 5 times more than a song I only have one of. ... Windows Media Player provides a very small set of functionality directed at a very specific technology: ...
    (microsoft.public.windowsmedia.player)
  • Re: The X Factor....(seriously)
    ... song and asked if it was some sort of gospel song or hymn or something ... it's the vintage that surprises me. ...
    (uk.music.folk)