Querying A form to Append Records

[Lou]

Good Day !

I have a form that has 4 fields I want to append to a
table. How would I do this?

The form name is "frmTracker" the fields are as follows;
[Amount] [Percentage] [Type] [Split][BookedBy] [Date]
35.00 2.50 B 17.50 Beavis =Now()

The table is "tblTracker" with same fields.
[Amount] [Percentage] [Type] [Split] [BookedBy] [Date]

ANy help would be great.
Lou

 

[Guest]

Thank you Ken for the response, I am building a seperate
payment table, that is why I need to append totals to this
other table. The form is based of the detail, and they are
formulated to give me the results I need, but now I need
to transfer the totals to my payment table.

Thank you,.
Lou