I think I am fine now - I needed a relationship between tables. Once I did that I could use the second table as text and I added the leading zeros. Thanks for all of the help. Seems to be working great now.
The problem stems from the fact that I am trying to do UPC codes. Some of them have leading zeros and the type is a numeric. I am bringing one table from an external source and it will not allow me to change the type. I have tried the STR command and I tried to change the format within the...
I noticed how most of the answers on here are designed for people that have been into this for some time. I want them to explain to me they would a 5 year old. I thought it would be funnier to say 40 year old since most 5 year olds can program a VCR and most 40 year olds cannot.
I think my real problem is the database is web based. I'm not sure this is what the problem is since I have yet to have it work. :)
but I do get the message "the expression you entered is not valid for web-compatible forms" or something like that.
how do I change a form to a non web based...