I am fairly new to access and need help writting code to generate records.
We have a database with customers that are billed monthly and would like to create code (macro?) to write records to a table with data and values obtained from another table.
I would like to run a program that obtains: the "name" of the customer, the "amount", the "subject" they are studying IF the customer is "active" and write those records to a table for later use.
The existing table with the data is called "Students Database Table"
The table to write the new records to is called "Student Payments"
Any help would be much appreciated
thank you
victor