WOW! You guys are awesome! I have been on vacation for a couple days and will try some of these solutions on my problem. I'm sure one will suit my needs and I'll respond back accordingly over the next few days.
Again, thanks so much for all the suggestions and mad brainiacs out there!
Much...
Good questions!
1. Sometimes there are no alpha characters.
2. They are always on the left.
3. The maximum alpha characters is currently 3 but could change at some point and need to be adjusted.
4. The numeric portion could have preceeding zeros.
Thanks GS.
Hello -
I am working in Access 2007. I have a string field with varying alpha/numeric combinations like:
E123456
BDI14222
RA9871
LIN4420
I need to end up with 3 fields something like this:
E123456 E 123456
BDI14222 BDI 14222
RA9871 RA 9871...
I am getting the following error message when printing via QuickPrint in Sales Order Entry.
Error88 Invalid/unknown program
o/s excep
prog sy_ REPORTENOINE.PVC
88 Error#88 Un/Work
Can anyone help with this?
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.