Sorry, the tables and such are pretty complex. I think this is a classic problem. I need the labor rate ID column from the transaction table row with the most...

Consider using MS SQL Server Migration Assistant. It's free (just google it....)

It seems to work better than the Upgrade Wizard in Access.

Tell it to "link" your tables (of...

Thank you, Divya. You're right!

SS,

Got any liny's to read about Profiler?

Jim

Cool, you've given me two new tools I didn't know anything about. I'll look into 'em. I solved my problem. Turns out you can't set a datetime variable to GetDate()...