Hey, I'm new here. I'm having a problem I don't understand, and I can't see a pattern in when it occurs, as it only happens about half the time. I will add something to a SQL statement in a query, and when I return to the query, every row looks exactly the same as the first row. Is this an error?? What's happening?

Thanks


Edit: I forgot to mention that even after I change the statement back to the way it was, the rows still look the same (wrong).

Have you applied SP2 for Office 2007 yet? Is this even on simple queries? How about an example. Maybe even a sample db.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"