Datasheet

ErrorCode ErrorString

2326 You can’t specify Group By, Expression, or Where in the Total row for

this column. Specify an aggregate function, such as Sum or Count, for

the field or expression you designate as the Value in the crosstab query.

For more information on aggregate functions, click Help.

2327 You must enter Group By in the Total row for a field that has Column

Heading in the Crosstab row. The values derived from the field or

expression that you designate as the Column Heading are used to group

data in the crosstab query.

2328 You can’t run an update query on the asterisk (•). Because the asterisk

represents all the fields in the table, you can’t update it. Remove the

asterisk from the query design grid. Add the fields you want to update

to the design grid.

2329 To create a crosstab query, you must specify one or more Row

Heading(s) options, one Column Heading option, and one Value option.

2330 Microsoft Access can’t represent the join expression | in Design view.

• One or more fields may have been deleted or renamed.

• The name of one or more fields or tables specified in the join expres-

sion may be misspelled.

• The join may use an operator that isn’t supported in Design view,

such as > or <.

2331 You must enter Group By in the Total row for at least one of the Row

Heading options you enter in the Crosstab row.

2332 Microsoft Access can’t match the fields you added using the asterisk

(•) in the append query. Because the asterisk represents all the fields in

the underlying table or query, you can’t append an asterisk to one field

or expression, and you can’t append a single field or expression to an

asterisk. Append an asterisk to an asterisk (for example, a table to a

table), or append specific fields.

2333 You must enter the name of the table you are creating or appending

records to. You tried to define a make-table or append query without

specifying a destination table.

2334 Microsoft Access can’t print ‘|’ because it is an action query. Because

action queries don’t produce a recordset, you can’t print a Datasheet

view of them.

Note that an exclamation point (!) joined to a query icon in the

Database window marks an action query. To print a Datasheet view of

the records that will be selected by the query, display the query in

Design view, click the Datasheet button, and then click the Print

button.

Appendixes for Web Site

ART VI