I applied a validation rule to a database that already contained data. When Access tested the contents of the database against the rule I created, it found that some data violated the rule, but I don't know which records need to be edited.
A1:
Frustrating, isn't it? Testing your validation rule tells you only that a problem exists; it doesn't tell you which records are incorrect. To find and fix the invalid data, copy the contents of the rule and create a query that uses the same criteria. If necessary, edit the values in the query result datasheet, and then re-create the rule.
I created a simple select query without parameters, but when I run it, Access displays an Enter Parameter Value dialog box. Regardless of what I enter, the query doesn't work properly.
A1:
This problem is almost always caused by a typo in a field name. Field names and parameters both appear inside brackets. If you misspell a field name, especially in an expression used with a calculated field, Access can't find the field and therefore assumes you want to display a parameter dialog box. Go through every expression in the query and see whether you can find (and fix!) the typo.
I entered an expression to define a calculated field, and then chose Sum from the Total row. The query displays the results correctly, but when I look back at the query's design, I see that Access changed the Total row to Expression and also changed the syntax of my expression. Is this correct?
A1:
Yes, this is perfectly normal. It's more efficient to perform multiple calculations in one operation, so when you save a query, Access edits it. If you select Sum in the Total row, for instance, Access adds a SUM() function to the formula that defines your calculated field.
