Recent content by SweetAngel007

Thanks a bunch :)

Thanks for the Reply. COUNTIFS are used if you have 2 or more fields you need to check. Sample Table: FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6 FIELD7 FIELD8 FIELD9 12354 IE EAST 1 3 3 1 0 0.00% 12354 SAFARI EAST 1 1 0 0 1 100.00% 12354 IE EAST 1 3 3 1 0 0.00% 5646513 SAFARI WEST 1 1...

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 :)