What Is Syntax in Microsoft Access?. You can customize your Microsoft Access database by calculating values, setting search criteria and formatting data fields with expressions.

=Count (*) returns #Error instead of 0 when there are no records in the report (MS Access 97). It seems I should test whether Count (*) returns an error state but cannot work out the syntax.

MS Access error 3259, which says "Invalid field data type," often happens when you're updating or accessing fields in an Access database.