V
Veti
I have two questions regarding Cross tab queries.
(1)
I have a table with the following setup
filename filetype filesize created_date
and what I want to do is show
filetype created month
sum of size | number of files
that is have to two main columns, one for filetype and another fo
created month and show the information on sum of size (to show the siz
of all files created in a month) and the number of files created in
month as two SUB-COLUMNs.
-
is this possible?-
(2) would it be possible to show filetype and created month as two mai
columns and then show day as a sub column for each month?
thank you. Vet
(1)
I have a table with the following setup
filename filetype filesize created_date
and what I want to do is show
filetype created month
sum of size | number of files
that is have to two main columns, one for filetype and another fo
created month and show the information on sum of size (to show the siz
of all files created in a month) and the number of files created in
month as two SUB-COLUMNs.
-
is this possible?-
(2) would it be possible to show filetype and created month as two mai
columns and then show day as a sub column for each month?
thank you. Vet