Multiple choice technology platforms and products

The output of DCount(Ereplace("AAxxCCCCxxBB",'xx','CC'),'CC') is

  1. 4

  2. 5

  3. 7

  4. 8
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

First, Ereplace replaces 'xx' with 'CC' in 'AAxxCCCCxxBB', resulting in 'AACCCCCCBB'. Then DCount counts the delimited fields using 'CC' as delimiter. The string 'AACCCCCCBB' contains 5 fields when split by 'CC': 'A', '', '', '', 'BB'.

Keep practicing — related questions