|
|
hi coders,
i have an access database with a table called rented
in this table there are 7 different paymethods and 8 different genres.... example
1 sms thriller
2 ideal thriller
3 sms horror
4 0906 romance
what is want to know is the following:
i filter the table by 'sms' then i get back 2 records
one with sms, thriller and one with sms, horror
i want to see how many times horror and thriller are present
with the query 'sms'
i tried looking into count but it gave no results
does anyone know how to achieve these totals
thanks for your help
Sander Kerstens
www.pixellabs.nl
info@pixellabs.nl
|
|
|
|
the following sql would work
select count(*), paymethods, genre
from rented
where paymethods = "sms"
group by paymethods, genre;
or since you already know the paymethod
select count(*), genre
from rented
where paymethods = "sms"
group by genre;
semper fi...
|
|
|
|
|
|
|
|
sanderman
