Expression for text field query

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Queries / August 2006

Expression for text field query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen - 03 Aug 2006 20:37 GMT

Hi,

I would like to create an expression for citeria in a query. The field is a
text field and I would like to query those records which have >4 characters.
How would I write the expression?

Reply to this Message

Ofer Cohen - 03 Aug 2006 20:43 GMT

Try

Where Len([FieldName]) > 4

Signature

Good Luck
BS"D

> Hi,
>
> I would like to create an expression for citeria in a query. The field is a
> text field and I would like to query those records which have >4 characters.
> How would I write the expression?

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.