I'm in a real crunch, and if you have time, you may want to look at my intro-I'm dumb, know very little about Access (any version-I have 2010) and I really need to replace and ampersand-&-in like a million records (I need not input the data) because I now know that Access doesn't it love it when it's used as text in a text field.....But I can't find out anywhere how to do it.....I've run the query to pull the records that have & in them, but I can't seem to write the criteria correctly to replace it with "and". Can anyone please help me----?????----Please....I'm begging.:banghead::banghead::banghead:
P.S. Just so you know, I'm not even in the realm of writing SQL....I'm using the drop down windows...
P.S. Just so you know, I'm not even in the realm of writing SQL....I'm using the drop down windows...