Totals used in Query

[jamil_786]

Hi Freinds,
I am new in this forum and this is my first question.
I made one query from my table with feilds "Purchase Order#" & "Invoice Amount" and i used totals with order by of "Purchase Order#" and Sum for "Invoice Amount". So this query is giving me the right result. But the problem is when i used this query in a form and try to modify at that time i could not edited and updated the record. when i remove totals from Query at that time i could be modify and update the record. the the result is not according to my needs.
Could you please help me to provide any solution for my problem

Purchase order# Total Invoice Amount
4750001 (PO have 3 record with total amount) 5000
4750005 100
4750004 200

 

[JANR]

TotalsQueries cannot be updated!! You have to go another route for what you want. I suggest the form/subform solution, base your subform on your query without the totalsrow and link purchaseorder with purchaseorder on your main form.

Then set an unbound textbox in your subform footer with its controlsource: =SUM([invoice amount]), if you refrence this textbox with another textbox on your main form and the grantotal will show.

JR