'Wrong property setting' message in query 1

[combo]

Scenario, Access 2016:

I have an intermediate query that combines required data, with ~50 kRecords in output. It runs without problem. This query is used as input in two other queries, one with more details, ~100 records, and the second, a copy of the first one and removal of two aggregation fields, ~15 records.

The first query runs fine.

When I run the second query, an ok only info message is displayed stating that for this property setting set is improper, to see proper setting of this property find name of this property in help index. No info about name of the property the message refers to. When I click 'ok', I get required aggregation displayed.
It happens only for fresh run from navigator, after processing data (takes few seconds), but before displaying the result. If I change a view from datasheet to design and back to datasheet, the message is not displayed.

Query syntax:
[tt]SELECT A, B, C, Count(A) AS Calc_1, Sum(D) AS Calc_2
FROM qQueryName
GROUP BY A, B, C;[/tt]

What's wrong here?


combo

 

[dhookom]

I would copy the SQL of all queries to notepad and recreate them to see if the issue exists.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[combo]

Thanks, works!

I made a copy of database and deleted the two queries (intermediate and output), next copied sqls from archived database to fresh queries. I compared properties in the two suspicious queries, global and for fields between the two databases, there were slight differences, but even after adjusting settings in old database and compacting, the message remained. Strange.

combo