design/programming help needed

[apryls82]

im building a database, im creating an account ledger to manage members account payments for their memberships.

im currently working with a few different tables:

Player: PlayerID, LastName, FirstName, DOB
MembershipList: MembershipListID, MembershipName, RegFee, MonthlyFee, Term
Memberships: MembershipID, PlayerID, MembershipListID, ContractStart, ContractEnd
AccoutActivity: ActivityID, ActivityName
AccountLedger: AccountID, PlayerID, Date, ActivityID, Amount

Players do not have to be members

The beginning of each month (either by button, or automatically) I need to add record/s to the AccountLedger table for each player where ActivityID="Monthly Fee" and Amount will equal their [MembershipList].[MonthlyFee].



I can not firgure out how to do this, will it be just an append query, or macro?

can someone please help, im using Macros, NO VBA

[pbaldy]

I would simply use an append query that used the member table as its source. You can hard code the relevant values.