Hi Micah,

I've encountered this problem before - entirely my own fault; tried to launch a query without the table links and as expected - Expr1  AS Expr2  AS Expr3   etc. etc. I'm still a novice so what I did was made the decision to document everything in my database. You name it - even command buttons - just everything. Now if I pick up a problem (and these are becoming less frequent now 'touch wood') I refer to my documented library and am able to quickly copy paste those values back in where ever needed. So for instance - if the query shows Expr1 or Expr2 etc., I open the query in SQL view, delete everyting that shows Expr and re-add the values, aliases and sql(code) that way.

My apologies if this is off on a tangent but it has certianly worked for me. I know it's a bit of a 'schlep' to document the database but the rewards far outweigh the penalties of having to do it all over again.

Happy 'Accessing' now,

Deon