×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

'Wrong property setting' message in query

'Wrong property setting' message in query

'Wrong property setting' message in query

(OP)
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:
SELECT A, B, C, Count(A) AS Calc_1, Sum(D) AS Calc_2
FROM qQueryName
GROUP BY A, B, C;


What's wrong here?

combo

RE: 'Wrong property setting' message in query

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

RE: 'Wrong property setting' message in query

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close