begin with letter only

  • Thread starter Thread starter geebee
  • Start date Start date
G

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
 
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
 
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
'====================================================
 
Much better than my suggestion :-)


Vanderghast, Access MVP


John Spencer said:
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
Click to expand...
Click to expand...
 
Back
Top