Hi
I am new to the forum so you will have to bear with me ...
I have a table in access with I use Count if formulas in and I was wondering if I could replicate it in access ( I now have to much data for excel to handle)
the formula I currently use in excel is
=COUNTIFS(Sheet1!N:N,'Sheet3'!E4,Sheet1!O:O,Sheet1!$O$7,Sheet1!L:L,Sheet1!$L$2)
is there any way of replicating this in access in either a query, crosstab query, or report ?
Kind Regards
Helen
I am new to the forum so you will have to bear with me ...
I have a table in access with I use Count if formulas in and I was wondering if I could replicate it in access ( I now have to much data for excel to handle)
the formula I currently use in excel is
=COUNTIFS(Sheet1!N:N,'Sheet3'!E4,Sheet1!O:O,Sheet1!$O$7,Sheet1!L:L,Sheet1!$L$2)
is there any way of replicating this in access in either a query, crosstab query, or report ?
Kind Regards
Helen