Search results

A pleasant day to all. I have these Table queries from Excel Need to have these transferred to Access. hope you can help :) FIELD4 = IF([FIELD1]="",0,1) FIELD5 = COUNTIFS([FIELD1],[@FIELD1],[FIELD2],[@FIELD2]) FIELD6 = COUNTIFS([FIELD1],[@FIELD1],[FIELD2],[@FIELD2],[FIELD3],">1") FIELD7 =...

Hi.. newbie on this site.. refreshing on MS Access since its been decade since I last used it. Thanks in Advance for those who might help me :)