spaces in coloumn

dssubhani · Post by **dssubhani** » Tue Aug 10, 2010 5:17 am

HOW CAN WE FIND NO . OF SPACES IN PARTICULAR COLUMN?

priyadarshikunal · Post by **priyadarshikunal** » Tue Aug 10, 2010 5:21 am

All caps is considered as shouting, no need to shout here.

Search is your friend for basic questions.

However, the answer is, use DCount().

ArndW · Post by **ArndW** » Tue Aug 10, 2010 5:59 am

The COUNT() function will count the number of characters, the DCOUNT() function will give you the number of fields delimited by spaces. DCOUNT('XX','X') will return 3, COUNT('XX','X') will return 2.