Hi,
Hopefully a quick problem to solve but I've been struggling for past few hours.
All I want to do is count how many records (within a set of grouped records) are between 18 months and 6 months old and ALSO count how many records are less than 6 months old
eg. My query "B4Q0_RSR_2FnCalcs_D_A_T_E" generates the following rows using the expression CtHrsY: IIf([B4Q0_RSR_2HistValues]![HDateH]>=(Date()-180),1,0):
HDateH TrkTo TimeTo HorseTo CtHrsY
20/08/2018 Fontwell 14:45 Ace Combat 0
05/12/2018 Fontwell 14:45 Ace Combat 0
25/04/2019 Fontwell 14:45 Ace Combat 0
15/10/2018 Fontwell 14:45 Ace Combat 0
27/12/2018 Fontwell 14:45 Ace Combat 1
15/04/2019 Fontwell 14:45 Ace Combat 0
26/05/2019 Fontwell 14:45 Ace Combat 0
12/09/2018 Fontwell 14:45 Ace Combat 0
23/03/2019 Fontwell 14:45 Ace Combat 0
I just can't understand why the expression doesn't work.
I have also made another query "B4Q0_RSR_2FnSc_Cnts" which goups TrkTo TimeTo HorseTo
and I have tried the following expressions:
CtHrsY: Count([B4Q0_RSR_2FnCalcs_D_A_T_E]![HDateH]>(Date()-548) And [B4Q0_RSR_2FnCalcs_D_A_T_E]![HDateH]<(Date()-183))...... this gives the answer "9"
Sum(IIf([B4Q0_RSR_2FnCalcs_D_A_T_E]![HDateH]>(Date()-548) And [B4Q0_RSR_2FnCalcs_D_A_T_E]![HDateH]<(Date()-183),1,0))...... this gives the answer "0"
Any advice would be most welcome.
Cheers
Hopefully a quick problem to solve but I've been struggling for past few hours.
All I want to do is count how many records (within a set of grouped records) are between 18 months and 6 months old and ALSO count how many records are less than 6 months old
eg. My query "B4Q0_RSR_2FnCalcs_D_A_T_E" generates the following rows using the expression CtHrsY: IIf([B4Q0_RSR_2HistValues]![HDateH]>=(Date()-180),1,0):
HDateH TrkTo TimeTo HorseTo CtHrsY
20/08/2018 Fontwell 14:45 Ace Combat 0
05/12/2018 Fontwell 14:45 Ace Combat 0
25/04/2019 Fontwell 14:45 Ace Combat 0
15/10/2018 Fontwell 14:45 Ace Combat 0
27/12/2018 Fontwell 14:45 Ace Combat 1
15/04/2019 Fontwell 14:45 Ace Combat 0
26/05/2019 Fontwell 14:45 Ace Combat 0
12/09/2018 Fontwell 14:45 Ace Combat 0
23/03/2019 Fontwell 14:45 Ace Combat 0
I just can't understand why the expression doesn't work.
I have also made another query "B4Q0_RSR_2FnSc_Cnts" which goups TrkTo TimeTo HorseTo
and I have tried the following expressions:
CtHrsY: Count([B4Q0_RSR_2FnCalcs_D_A_T_E]![HDateH]>(Date()-548) And [B4Q0_RSR_2FnCalcs_D_A_T_E]![HDateH]<(Date()-183))...... this gives the answer "9"
Sum(IIf([B4Q0_RSR_2FnCalcs_D_A_T_E]![HDateH]>(Date()-548) And [B4Q0_RSR_2FnCalcs_D_A_T_E]![HDateH]<(Date()-183),1,0))...... this gives the answer "0"
Any advice would be most welcome.
Cheers