Hi,
I am struggling with a formula to tell me a field is true when it begins with D followed by two numbers - can anyone help?
Hi,
I am struggling with a formula to tell me a field is true when it begins with D followed by two numbers - can anyone help?
Till someone comes along, check out LEFT(), MID(), IIF(), ISNUMERIC(),
Thanks
I would use VBA to assign the value to a string variable. With that, you can evaluate the string using InStr() and some of the functions listed in post #2.
Try something like this:
Assume you have copied the data to a variable called str, for simplicity, and you have a boolean variable called IsValid:
IsValid = left(str,1) = "D" AND isnumeric(mid(str,2,1)) AND isnumeric(mid(str,3,1))
John