Microsoft Office Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications,
Microsoft Access can't display the field for which you entered Where in the Total row.@Clear the Show check box for that field. If you want this field to appear in the query's results, add it to the design grid twice. For the field that will appear in the query's results, don't specify Where in the Total row, and make sure the Show check box is checked.