Kamis, 29 November 2012

Re: [MS_AccessPros] count

 

Duane-

Brilliant!

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: Duane Hookom <duanehookom@hotmail.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Thursday, November 29, 2012 3:40 AM
To: Access Professionals Yahoo Group
<ms_access_professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] count

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]

------------------------------------

Yahoo! Groups Links

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar