A
Ashley
I have a query like
sum(If location = 'USA' or Location = Canada and date > date() or date
is null
then 1, 0)
how do I write this statement correctly in access
sum (IIF ( (location = 'USA' or location = 'CANADA' ) and (date
does not works in access. Is there a way of doing this correctly in
ACCESS.
sum(If location = 'USA' or Location = Canada and date > date() or date
is null
then 1, 0)
how do I write this statement correctly in access
sum (IIF ( (location = 'USA' or location = 'CANADA' ) and (date
date() or IS NULL (date)) , 1 , 0 ))
does not works in access. Is there a way of doing this correctly in
ACCESS.