Hi,

My definition of a calculated field is NOT a column in a table.

Eliminate the "Balance" column.

If you need to use sql for reports, I'd create a view using...

When you say you can't find your "Old" sql, is the old computer using a desktop version of SQL2000?

Desktop version db's aren't accessible from other computers. Easier to detach/reattach...

If the columns for the "New Data" are the same as the "Old Data" why are you required to drop an index?

Sounds like a lot of unnecessary work.

Just...

Noel,

I knew there had to be a quicker way. Just couldn't find it.

Thanks,

SAP: Sorry A.. Programming

Mike and Remi,

Thanks for the fast response. I'll check into both of those options. Definitely don't have the time to re-invent any wheels.

Greg

 Hi,

Since I don't know what your error message says, I would suggest you use a CASE instead of the IIf.

(I may be mistaken, but I don't think the IIf function will return...

Hi,

In this case, we were looking for a way to insert an item line count in a way that wouldn't interfere with our primary sort criteria: postal codes. For...