Data type mismatch in criteria expression (1 Viewer)

[jpl458]

I am building this query in the grid. The table is:

the grid is

If I run this query without the count, it runs fine, but when I add the count function I get

The field in the table is short text. I don't see how there is data type mismatch when I add the count.

 

[June7]

But you are applying "Adam" text criteria to an aggregate calculated number value. If you want to filter by 1stcontactname field, don't do that in the same column you do Count. Use some other field for the Count or use Count(*).

Applying filter criteria to an aggregate calculation field will invoke a HAVING clause. Switch to SQLView to see query SQL statement.

WHERE filters records before aggregation, HAVING filters after aggregation.

 

[GPGeorge]

But you are applying "Adam" text criteria to an aggregate calculated number value. If you want to filter by 1stcontactname field, don't do that in the same column you do Count. Use some other field for the Count or use Count(*).

Applying filter criteria to an aggregate calculation field will invoke a HAVING clause. Switch to SQLView to see query SQL statement.

To further what June7 pointed out, the result of the Count(1stContactName) will be a number, 1, or 2 or 3 or 9,000.

You want to match the selected name "Adam", not the number of Adams.

 

[mike60smart]

You also appear to have Repeating Group ie

1st Contact
2nd Contact
3rd Contact
4th Contact

These Contact Names should be records in a Related table vice Fields in the Table.

 

[jpl458]

But you are applying "Adam" text criteria to an aggregate calculated number value. If you want to filter by 1stcontactname field, don't do that in the same column you do Count. Use some other field for the Count or use Count(*).

Applying filter criteria to an aggregate calculation field will invoke a HAVING clause. Switch to SQLView to see query SQL statement.

WHERE filters records before aggregation, HAVING filters after aggregation.

Thanks