Cannot Edit fields in Sum Query

  • Thread starter Thread starter STEFAN
  • Start date Start date
S

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
 
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.
 
When I create a sum query I cannot edit the fields.
Click to expand...

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.
Click to expand...

Use a Form based on the invoice table, and a Subform based on your
totals query.
 
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
 
Back
Top