N/APosted on - 12/19/2012
I have a little problem using Microsoft Access. How can I count the number of characters using Access query. Please tell me a step by step process on how doing it. I need help using access 2010 and character count.
Thanks a lot.
Using access 2010 and character count
First, I would like to say that I do not have an idea about the Microsoft Access character count.
You can count how many words are there in a word file using Microsoft Word. MS Word provides that facility but not to calculate characters.
If you still want to calculate how many characters in your Access Query, I will clarify a method how to count characters. Just follow steps given below,
1. Export access query into a text file by clicking “Export to text file“, located on the “External Data” tab on the ribbon. (Select the required query before performing this)
2. Then follow the instruction on the “Export-Text file” wizard to export your query. Then you will have a text file with all the data, which was included in the Access Query.
3. Right click on the text file and select “Properties”.
4. In the properties dialog box, find the file size mentioned in KiloBytes (KB) or Bytes.
Now you have a calculation. One byte represents one character in computing. (1 Byte = 1 Character)
As an example, assume that your file size is 257 Bytes. That means there are 257 characters exist in the text file.
If your main purpose is to count characters only, you are able to try this.
Important: Spaces are in the text file is also counted as a character. Pay your attention on it.
Hope this may help.