R
Rabbie Williams
I've got myself utterly stumped - in Excel it was reasonable straightforward
but I don't really know where to start now that I need to transfer it over to
Access. Any help would be massively appreciated.
There are 3 variables: week number, Territory area, product group
Basically i'm trying to count the number of times each product group is
spoken about (a boolean value) on each territory area on a specified week as
logged on a seperate sheet.
In excel i've done this by setting up a grid with Product names listed along
the top & territory areas listed down the left so that for productA in
territory 6 the following formula is used:
=SUMPRODUCT((ProdRef=B3)*(areaRef=6)*(WeekRef=$B$1))
I'm assuming it needs multiple count queries with an overriding summary
query but this isn't at all elegant and would be a pain to have to update.
Thanks,
but I don't really know where to start now that I need to transfer it over to
Access. Any help would be massively appreciated.
There are 3 variables: week number, Territory area, product group
Basically i'm trying to count the number of times each product group is
spoken about (a boolean value) on each territory area on a specified week as
logged on a seperate sheet.
In excel i've done this by setting up a grid with Product names listed along
the top & territory areas listed down the left so that for productA in
territory 6 the following formula is used:
=SUMPRODUCT((ProdRef=B3)*(areaRef=6)*(WeekRef=$B$1))
I'm assuming it needs multiple count queries with an overriding summary
query but this isn't at all elegant and would be a pain to have to update.
Thanks,