begin with letter only

[geebee]

hi,

i would like to add a condition to my query which states that a field begins
with a letter only. and not with a number. what would this condition look
like?

thanks in advance,
geebee

 

[Michel Walsh]

WHERE NOT ISNUMERIC( LEFT(yourFieldNameHere, 1))


will be a condition which will pick only records where the first character,
Left( ...,1) is not numerical, or where the value in the field is null.



IsNumeric and Left are VBA functions.



Vanderghast, Access MVP

 

[John Spencer]

Use criteria on the field of

Like "[a-z]*"

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Michel Walsh]

Much better than my suggestion


Vanderghast, Access MVP

Use criteria on the field of

Like "[a-z]*"

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

hi, i would like to add a condition to my query which states that a field
begins with a letter only. and not with a number. what would this
condition look like?

thanks in advance,
geebee