Record Set not updateable

[Guest]

I have a table with a field Matching where the user has input a Matching
code. I get the Sum total of field Amount for Group on the Matching field in
a query. In another query I want to be able to select all records from the
main table for items that do not Sum to zero in the SumTotal query. I tried
to Sum Total in a query on the Matching Field and relate it back to the table
in another query which worked but then when the query opened and I tried to
make an change in a field it said "Not Updateable". How do I make this work.
Can a do a DLookup from one query to another and make it work? I tried
something like in a query that pulls up the records from the main table ..
and I added a field:
Bal:
DLookup("NetBal","qryTotalsPerMatchField","[qryOnMainTable].[MatchField]=[qryTotalsPerMatchField].[MatchField]")
but received an error. Is the total concept wrong or the DLookup function???
Any direction on this is greatly appreciated.

Thank you,

Steven

 

[Alex Dybenko]

I have a table with a field Matching where the user has input a Matching

code. I get the Sum total of field Amount for Group on the Matching field
in
a query. In another query I want to be able to select all records from
the
main table for items that do not Sum to zero in the SumTotal query. I
tried
to Sum Total in a query on the Matching Field and relate it back to the
table
in another query which worked but then when the query opened and I tried
to
make an change in a field it said "Not Updateable". How do I make this
work.

this is by design - queries with group by is Not Updateable.

Can a do a DLookup from one query to another and make it work? I tried
something like in a query that pulls up the records from the main table ..
and I added a field:
Bal:
DLookup("NetBal","qryTotalsPerMatchField","[qryOnMainTable].[MatchField]=[qryTotalsPerMatchField].[MatchField]")
but received an error. Is the total concept wrong or the DLookup
function???
Any direction on this is greatly appreciated.

you can not refer to other query in DLookup, but if you make a form based
on qryOnMainTable - then you can refer to fields on this form

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com