This hardly could be defined as programming, but I'm not sure it fits into the other threads particularly well either.
I have a query, and I'd like to modify one of the fields to remove the first to characters. Data looks like this:
"D-asdf"
"I-asdf"
"D-poiu"
"I-poiu"
Obviously, I would like to remove the "I-" and "D-" from the fields. The "Replace" function seemed to be the most applicable, so I've come to this formula:
Replace([Desc],"D-","")
But the above returns a "Data Type Mismatch" error. The tables "Data Type" is set to "Text", and the data in it reflects that.
Does anyone have any advice on how to get the results I'm looking for? Obviously I'm only anticipating the above expression to remove the "D-" markers. I could manage this in Excel with a Left() plus a Substitute()--and I could probably do the same with the Replace(), if I could get it working!