Hello,
I'm trying to make the most of a 3-day weekend and hope I can get a definitive answer. I don't know what my next steps are and would like to proceed with development if it's not corrupted.
Problem: I am developing a database and have 2 three-field queries that are giving me fits. When the first field contains the expression
CaseStatusSummary: Sum(IIf((Left([rssid],1)="L") And ([lasampletype]>1),1,0))
or one like that, I get a popup: "Reserved error (-3087); there is no message for this error." However, when I rearrange the query and position this calculated variable to be the second of 3 fields, it works and I get values that I expected.
Is my database corrupted when I have done the following:
1. tried compact and repair
2. tried decompiling the old databse
3. checked my back up which also has the same issues
4. Imported everything except these troublesome queries into a new database.
5. These queries are tied to my main table. In the new database, I created a whole new main table from scratch and I renamed the old main table.
I hope to find out that this is a "feature" and not corruption. If it is corrupted, what are my options? Recreate everything from scratch? Interesting, I have a 3rd query that has a simpler count expression (there is no "and" clause) and it runs no matter what the calculated field's position is in the query. Thanks in advance. I hope you can help.