Recent content by amerifax

Thank you. Bob

Once again...WOW!! I will sit down and give this a try. You make it seem so simple. You have no idea how much you have helped me. I am going to give this a try. So I should create a table with the fields you specified and then run each update query against the data to clean it up. I just...

Would it be a better idea to search on those similar values and replace them all with the proper words to keep things a little more simple. The older data we received from the state was all scanned in so I'm sure they just ran an OCR against it so that's why there are so many misspellings and...

I was just thinking since they all are most likely "See Attachment" would it be a good idea to treat them as that. The "sub-CK" "A" would only be used to exclude the record when doing select searches and fixing of records. Bob

Se At" would be close ok. Where the value has <20 characters with a "space" between the 2 values, I can't see that getting much better. I got the data from state of Wisconsin ,many of the files got ocr , for older files. With the flag Field-sub-ck and a few other fields we will be able to...

Again, I want to thank you so much for all your help. I have just a few more things and I hope I am not pushing it, you have done so much to help me already. One thing for the PropertyDescription_1 Field, if it contains CSM, Section, Township or Parcel, we don't want to transfer any data to...

Wow! That is amazing. I will sit down and look it all over. I can't thank you enough for this help. I know we don't live in a perfect world and the field I am dealing with here is...well you saw it. That is the way the data actually looks. And it probably gets worse than that. I just...

Sorry about the Title. I must have had my mic on. I use Dragon. I can't find a place to edit. It should be "Quary". Bob

I am trying to create a quarry which is totally new to me. I am including a picture that gives a better idea what I'm trying to do. I'm drawing the value from field "PropertyDescription_1". Note: The image shows lot as a field. That was a mistake "Lot" is a vale within "PropertyDescription_1"...

Thanks dhookom soory about the over site. I agree credit due but was not aware about the button. I run a IPBoard and didn't have a clue. Bob

I'm attaching a accdb that has added field's to show what the results should be. They all start with the name value. I also might mention that records 12,13,14 seem so close. I will be running the results against my master file that will pull the three records so they show "Harmony Groved". So...

It's hard to describe what I need to do but I put together a text file that I am attaching to try to help explain. But bottom line I have a field called PropertyDescription_1 where there is a high probability of a Subdivision Name contained within if certain conditions are met. I hope I'm not...

Well that was even easier than your first help. Thank you very much. I really appreciate your help. Access is pretty new to me but with people like you helping me out I am finding my way around really easily! Thanks again! Bob

Wow that was quite simple, thanks soooo much! I do have one more part to it if possible. Some of the LastName (GrantorLastName) fields contain Company information and therefore have nothing in the FirstName field. Is there an easy enough way not add the space if FirstName does not contain...

I am not sure if I am posting this in the correct spot...if not I apologize. I am using Access 2007. I have three columns, fst,lst and name. How do I get the column "name" to contain "fst and last"? So basically I have a table with first name and last name in seperate fields. I would like to...