No Field Edit capability

[WT]

I have a large data file as the parent, left joined to a child table which is
many to one.
and the parent also joined to a sub query that counts the number of records
in the parent that match the child.

when I run the query it delivers all the data in a table but it will not
allow me to edit or change any of the records.
I have tried all the record locking options and also looked in the
Tool/options/Advanced tab for those settings and still I am unable to change
a field.

Help please.......

 

[Dirk Goldgar]

I have a large data file as the parent, left joined to a child table which
is
many to one.
and the parent also joined to a sub query that counts the number of
records
in the parent that match the child.

when I run the query it delivers all the data in a table but it will not
allow me to edit or change any of the records.
I have tried all the record locking options and also looked in the
Tool/options/Advanced tab for those settings and still I am unable to
change
a field.

Without seeing the actual SQL it's hard to be sure, but you've probably run
afoul of the fact that the Jet/ACE database engine considers any query that
includes grouping, or SQL aggregate functions like Count() and Sum(), to be
nonupdatable -- even when it doesn't logically have to be.

One workaround for this, albeit relatively inefficient, is to use a DCount()
expression in your query to get the record count, instead of Count().

 

[WT]

Even when I remove the sub query I am unable to edit or change a field in any
record.

 

[Dirk Goldgar]

Even when I remove the sub query I am unable to edit or change a field in
any
record.

Please post the SQL of the query.