Custom View

[Jim Heavey]

Hello - I am wanting to know if I can create a view of a
table which summarizes information in a table. Say I
have a table which shows the following:

Tape Number=1,ID=90, Title="SomeTitle"
Tape Number=2,ID=90, Title="SomeTitle"
Tape Number=3,ID=91, Title="Freddy"

And I want to display the following in a dataview

ID QTY Title
90 2 SomeTitle
91 1 Freddy

Can this be done within a view of a base table?