Access is goofing up my query
Posted on 2013-06-14
Hello - I had to work up a query that formats data from an Access app for upload to a SAP database.
Most of the fields are either literal control codes required by SAP, or fields that are set equal to zero-length strings, which I have as Group By's. There are just a few fields of actual data; transaction amounts, summed up to cost identifiers.
After 4 months of working fine, all of a sudden, all the Group By's and Sum's were changed to Expression's. We changed them back like they were, and saved & closed the query.
Then, because I have become very mistrustful of Access, I opened the query back up to make sure it was still as we saved it.
Sure enough, a few of the Group By's had gone back to Expression's, the Sum's were still there, but then there were some new Group By's of just 2 double-quotes together (no "Expr(x)" names like Access puts on expressions by default), with the Show checkboxes un-checked.
Thinking the query was corrupt, I corrected it again, then cut the SQL out, pasted it to NotePad, deleted the query, created a new query, and pasted the SQL back in. I then saved, closed and re-opened it, and it was STILL back to the condition described above.
Any ideas about how this is happening?