How do I update a database I created for a school which records fees paid and some refunded fees? This a year end closing and carry forward to the next year.Database layout: primary table has student ID (common field throughout tables),& name.
Twosecondary tables: one records fees paid with studentID, fee1, fee2, fee3. Second secondary table records the refunded fee1(which is a deposit given back at yearend or carried forward to next year.
I need to zero out fees except where the refund isnot given. I am not very familar with Visual basic so if this is the direction I would need very clear explanations. This was cut off before 2nd time submitting. Thanks for what-ever help available. Tried update query-came up with errors-I need to update query with primary and both secondary tables because if there is a value in the refunded table it shouldn’t be zeroed.
