I'm at a loss to understand why you would be editing data using EM in the first place. Not because I'd be concerned about the dangers, but because...

I believe the latter of those two is referred to as "certifiable", but I pick nits...

Steve

(aka smunson)

:):):)

GilaMonster (7/23/2008)

---

Jeff Moden (7/23/2008)

---

Wow... That's amazing, Ross... I haven't heard anything like that in...

Sounds to me like an exam question or homework. Otherwise why ask for 2 different answers. I would suggest that the OP read their course...

I think the problem here is knowing exactly where your page starts. If you have no page header, a page break with a group might involve a group...

That figures. Just when I figure out that I didn't need HR as a string, and instead needed it as a number, I forget to remove the initialization...

Ok, but you need to be more detailed about where the table is placed within the report definition. Is it in the page header, page footer, or body? ...

Well, for this purpose, I finally figured out how to overcome the formatting problem using the Format string, so now I don't need this particular solution, however... I...

I'm not sure I understand what your saying... Can you clarify exactly what you mean? Is the table not appearing in the same location on...

Ok then, with so many fields, perhaps you could find some way to narrow it down to just 4 or 5 tables or so? Perhaps find some kind...

Just a thought, and again, testing for performance implications would be essential, but perhaps you just have ONE extra table, capable of accommodating any/all OLD records from the various tables,...

GSquared,

My concern was with any processes that replaced any more than 2 spaces with none, which has a potential problem, as I pointed out previously.

With regard to your example of...

GSquared,

The reason I wasn't all that worried about performance is because this kind of fixing is generally a one-time event, and even if it took an hour, the overall net...

Holy Alphabet, Batman !!!

Ryan, that's one of the slickest routines I've ever seen... Neato, peachy keen, cool, etc., etc. ...

WELL DONE !!!

Steve

(aka smunson)

:):):)

I'm not sure of ALL the implications, but why not have a table dedicated to "old" data, such that after a change, the "old" record is archived to the "old...

There is a potential pitfall here, folks: Any time there are exactly X spaces between words, where X is greater than 2, you have a problem with any...