Using Access 2000. Am familiar with using update queries, but not sure how to enter the information to be updated into the query.
Fields to be worked with:
Member table - Membership#, Dues Next Due date
Dues Payment table - Date dues payment recorded
Dependant table - Next Due
Need to update the Dependant table Next due field with the data entered in Member Dues Next Due field for the day that dues were recorded from Dues Payment Table.
Have the criteria portion down pat, but need to know how to enter the Update To portion into the Dependant Next Due field from the Member table field.
Am unfamiliar with VB or SQL.
Fields to be worked with:
Member table - Membership#, Dues Next Due date
Dues Payment table - Date dues payment recorded
Dependant table - Next Due
Need to update the Dependant table Next due field with the data entered in Member Dues Next Due field for the day that dues were recorded from Dues Payment Table.
Have the criteria portion down pat, but need to know how to enter the Update To portion into the Dependant Next Due field from the Member table field.
Am unfamiliar with VB or SQL.