I think I'm making progress.

Have a look at query 2:

http://www.aci.on.ca/%7Ecromarty/School/Video Store.mdb

Am I on the right track? Did I miss something? Everyone's help has been really great so far.

Ashley