W
W
Hi,
I want to be able to see which customers bought in the course of ten
consecutive days, where the BeginDate can be whatever date and which can vary
for each customer, how many products b, e, f one bought out of a range of
products a, b, c, d, e, f, g.
I’ve already tried many queries, amongst others with the Max and Min
function for the date of purchase, but that returns effectively the first and
last possible days. So, if someone buys 5 times on Jan 1st, Jan 3rd, Jan
9th, February 11th, March 3rd, I’ll get for the MinDate Jan 1st and for the
MaxDate March 3rd, regardless of the fact that I have a period of 3
consecutive days which correspond to the criteria, namely : Jan 1st, Jan 3rd,
Jan 9th.
I know this is a difficult one, so any help will be greatly appreciated.
W
I want to be able to see which customers bought in the course of ten
consecutive days, where the BeginDate can be whatever date and which can vary
for each customer, how many products b, e, f one bought out of a range of
products a, b, c, d, e, f, g.
I’ve already tried many queries, amongst others with the Max and Min
function for the date of purchase, but that returns effectively the first and
last possible days. So, if someone buys 5 times on Jan 1st, Jan 3rd, Jan
9th, February 11th, March 3rd, I’ll get for the MinDate Jan 1st and for the
MaxDate March 3rd, regardless of the fact that I have a period of 3
consecutive days which correspond to the criteria, namely : Jan 1st, Jan 3rd,
Jan 9th.
I know this is a difficult one, so any help will be greatly appreciated.
W