Less than 10 characters in field

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Less than 10 characters in field

Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

December 14th, 2006, 12:44 PM

arholly

arholly is offline

Authorized User

Join Date: Aug 2006

Posts: 85

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Less than 10 characters in field

Hi everyone,
Again, drawing a blank. How do I run a query on a field to know if it has less than 10 characters in the field?

Thanks,
Arholly

Old

December 14th, 2006, 01:54 PM

vemaju

vemaju is offline

Friend of Wrox

Join Date: Oct 2003

Posts: 168

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Hi

Use Len function in your query

Len([Field_name])<10

-vemaju

Old

December 14th, 2006, 01:58 PM

arholly

arholly is offline

Authorized User

Join Date: Aug 2006

Posts: 85

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Thanks, that is exactly what I was looking for. Never knew about the Len function.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace Gridview field if null with new field	Indo77	ASP.NET 2.0 Basics	1	June 18th, 2007 06:22 AM
counting characters in a field	emiminja	SQL Language	1	August 26th, 2006 12:35 AM
Copy previous field record if next field is null	ecampos	Access VBA	6	June 23rd, 2006 12:55 PM
Update city field based on zip field	nganb	SQL Server ASP	0	April 22nd, 2004 10:30 PM