I want to create a form in access2000 where i can type (OR SELECT) items where i am looking for. The results must by in a diagram, percentages or data.
example:
a database off misic CD. Items are ; Title, Duration , Artist, CD-number, Numer on CD, Year.
I want to ask different questions to this table. How many CD's do i have from the year 2000 on wich are less then 10 numbers. Or show me a digram from the CD's from the year 2000 by counting the numers.
Hope anybody can help me.
example:
a database off misic CD. Items are ; Title, Duration , Artist, CD-number, Numer on CD, Year.
I want to ask different questions to this table. How many CD's do i have from the year 2000 on wich are less then 10 numbers. Or show me a digram from the CD's from the year 2000 by counting the numers.
Hope anybody can help me.