Query that joins two tables and determines if there is a new date

[zipaway]

Hello I have the following Query:






I would like to get Expr1 working but it keeps giving me an error (You tried to execute a query that does not include the expression 'Change_Number' as part of an aggregate function).

The query ChangeOrder_CheckForNewDate has multiple entries for each project (Number of shipments). That Expr1 should sum up the Falses/True and if there is at least one True it should output True.

Any help would be greatly appreciated.

[June7]

A query using aggregate functions must be an aggregate (GROUP BY) Totals query.

Summing true/false field will result in either 0 or negative because a true is -1 and false is 0.

Click Totals on the ribbon Design tab. Choose Sum under the NewDate field and criteria: <>0

[zipaway]

A query using aggregate functions must be an aggregate (GROUP BY) Totals query.

Summing true/false field will result in either 0 or negative because a true is -1 and false is 0.

Click Totals on the ribbon Design tab. Choose Sum under the NewDate field and criteria: <>0

Thanks for your help, I fixed it.