Disappearing SQL Code in Queries

[static]

No. If the SQL was how it was originally the OP wouldn't be posting here.

The SQL is invalid!!! That is all we know.

You cannot save SQL like that in Access. Either it is being displayed incorrectly!!!? Which is very unlikely!! (weird bug) ... Or the query(s) are being corrupted. By what/why/how is the question!...

 

[isladogs]

This was the first post by the OP:

Each day, I run a long series of queries, the results of which are e-mailed. Sometimes, most of the SQL code in the query disappears after sending the e-mail. All that remains is the first clause such as "SELECT DISTINCTROW TOP 7" while all the remaining code is gone. The e-mail itself has the correct data.

This is long-standing problem, but it has been getting worse lately. I keep a table that has all the SQL code for queries so I can restore it easily, but it would be better if I did not need to do so. I repair/compact daily.

Does anyone know anything about this bug?

Its now post 46 and the OP has added very little info since post 1
The whole point is that it doesn't make sense to any of us (or the OP)
As he hasn't provided anything substantial since then, we're all basically wasting our time

 

[static]

Agreed.

I do like a weird bug though.