I have a DuesTable for an organisation database. Each month I need to create new dues records taking into account members who have resigned etc. The Dues record has a date field, which is in dd/mm/yyyy format. This field holds date as at first of the month. I want to create an append query which will select ONLY those records from the latest month, and using dateadd create a new record for the next month. In testing using a select query, I have tried using max([Month]) as selection criteria in Month field but get error “Cannot have aggregate function in WHERE clause tblDuesRecords.Month=Max([Month])”
Would appreciate being shown the error of my ways!
