Recent content by cwindoma

George... Thanks for the info, I kept coming up with a syntax that I need to dig a little deeper to find, so can't tell you if it worked or not yet. However, I did re-try my original on a fresh database and it worked...so something 'unseen' must have been tripping me up on that original...

True that real numbers don't have leading zeros, but you can format them to display leading zeros. That's all I'm trying to do, is retain those leading zeros when I concatenate. So using the example above, I have four fields two of which are formatted to display leading zeros (fields 2 and...

Thanks for trying to help me out Bob....I admit that's over my head though. Is that VBA? I'm not familiar with VBA...not opposed to trying it though....how would I plug this info into that Query Design screen in Access?

Hello All, I have seen some posts regarding this topic, and so far it's not working for me. Hoping someone can help me. Here's the roadblock(s) I'm running into... Ultimate Goal: I need to take an 11 digit numeric code, calculate a MOD10 check digit on it, and store it in the database. (Parts...