I
ifiaz
I have a table that looks like this:
DT, CONTAINERS, FLT_TYPE, ...
01/01/05, 100, I
01/01/05, 100, I
01/01/05, 200, D
02/01/05, 100, I
02/01/05, 1, D
02/01/05, 2, D
....
....
I want a summary query that shows
the date (group), Sum of Containers for that day, Count of 'I' for that
day
01/01/05, 400, 2
02/01/05, 103, 1
....
....
I tried various ways in vain. I managed to accomplish it using VBA
custom function. Is there an efficent way by just using a single query.
Thanks.
DT, CONTAINERS, FLT_TYPE, ...
01/01/05, 100, I
01/01/05, 100, I
01/01/05, 200, D
02/01/05, 100, I
02/01/05, 1, D
02/01/05, 2, D
....
....
I want a summary query that shows
the date (group), Sum of Containers for that day, Count of 'I' for that
day
01/01/05, 400, 2
02/01/05, 103, 1
....
....
I tried various ways in vain. I managed to accomplish it using VBA
custom function. Is there an efficent way by just using a single query.
Thanks.