Count the number of E's in a single field or all fields, a single record or multiple records?
Len([YourExpression])-Len(Replace([YourExpression],"E",""))
Duane Hookom MVP
MS Access
> To: MS_Access_Professionals@yahoogroups.com
> From: youssef2309@gmail.com
> Date: Wed, 28 Nov 2012 12:40:59 +0000
> Subject: [MS_AccessPros] count
>
> how to count the number of a certain letter "for example letter E" within a text in the table.
[Non-text portions of this message have been removed]
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar