Cannot Edit fields in Sum Query

[STEFAN]

When I create a sum query I cannot edit the fields.

I have a query based on a table with invoice information,
and the summary query which sums the payments from the
payment table.

I would like to be able to edit information in the invoice
table (such as payment status)through a form based on the
query.

Is this possible or are sum querys always blocked for
editing?

Thanks in advance

 

[Van T. Dinh]

Totals Queries are NOT updateable!

Try the Query based only on the Invoice Table with a Calculated Field using
DSum to total payments for the Invoice.

 

[John Vinson]

When I create a sum query I cannot edit the fields.

Exactly. No Totals query is ever updateable. The Sum that you see does
not correspond to any single record in the table; which record would
you want to edit!?

I have a query based on a table with invoice information,
and the summary query which sums the payments from the
payment table.

I would like to be able to edit information in the invoice
table (such as payment status)through a form based on the
query.

Use a Form based on the invoice table, and a Subform based on your
totals query.

 

[Kelvin Lu]

A sum query is always uneditable. What you could do is instead of using one
form based on the query, make a form and subform with the form based on the
invoice info and the subform based on the payment info. You could then add
a text box to the footer of the subform set to sum([Payments]) which will
give you your total. Then your main form which is linked to the invoice
info can be edited.

Kelvin Lu

 

[Phobos]

Aggregate queries return recordsets which may not be edited.

P