you need a parent/child form.
the child subform will show ONLY records of the parent ID.
then the subform can show the total for K_ID 220.
in the subform footer ,put a blank text box. Set the source of the textbox to =SUM(Kwota)
this will give you the total.
Ok thank you !
I will check it!
Best Wishes,
Jacek Antek
This is what reports using Sorting & Grouping features with aggregate calcs are for. Report allows display of raw data as well as grouped and summarized info.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you June,
so maybe the best option is to use the report here,
Best Wishes,
Jacek