Recent content by KLahvic

Thank you...If I knew what exactly I was doing, I wouldn't be coming to these boards for help. I have no clue about SQL?!?! Please don't criticize when I simply asked for help. David - Thank you for your help, I added the nz statement and will try to understand the SQL portion, but I do...

Yes here it is in 2003

David/Peter - Thank you both for your response. I have changed a couple of things. ZipCode is a text field so I added the quotes at the end as in the example you provided. I changed PSTCD to txtpstcd as well as changed the name filed to reflect as well. I do not get the error any longer...

Hello all, this is my first post and hope to get a solution to my inquiry. I have a form where I enter a vendor ID and the form auto populates all vendor information i.e. name address, zip code etc. When the zip code portion populates I have a table with just zip codes and cities and states...