[slinkelist] Help with creating a report

[David Aue]

You want to link the tables on the CDJID field.  You can do this in the
relationships window.  First display both tables and then drap the CDJID
field from one tabel to the other to create a relationship.  Now you can
pick field from both tables in the report wizard with impunity.

David Aue
Nirvis Systems


> -----Original Message-----
> From: slinkelist-admin@nirvis.com [mailto:slinkelist-admin@nirvis.com]On
> Behalf Of Mike Ahrens
> Sent: Saturday, April 01, 2000 8:14 AM
> To: slinkelist@nirvis.com
> Subject: [slinkelist] Help with creating a report
>
>
>
>
> Hello,
>
> I am trying to create a report that lists all tracks sorted by artist.  I
> know I probably can do this by using Microsoft Access (which I
> have), but my
> database skills are somewhat limited.  When I look at the Tracks
> Table, the
> Artist field is not completely filled in.  It appears that only
> Albums that
> have Various Artists fill that field.
>
> Is there someway to join the two tables to create this report?
>
> I would like the format of the report to look something like this:
>
> Artist                    Track                         Album
> AC/DC
>
>                           Back In Black                 Back In Black
>
>                           Given The Dog A Bone          Back in Black
>
>                           Etc,                          Back in Black
>
>
>
> Tommy James
>
>                           Draggin' The Line              Nipper's Greatest
> Hits of the Seventies
>
> Troggs
>
>                           Wild Thing                     Best of the 60's
>
>
>
> Thanks,
>
> Mike
>
>
>
> _______________________________________________
> slinkelist maillist  -  slinkelist@nirvis.com
> http://www.nirvis.com/mailman/listinfo/slinkelist
>
>