From ColinDen
Have single table/entry form financial db. Want one field (already a calculated field) on form to bring forward the record of total costs so to update for new week. Viz. the expression in control source for the field needs to be generally:
=[CostsForWeek]+[CostsForPreviousWeek]
Question: What other data is required in the expression to bring forward the previous record?
Note my knowledge of VBA is extremely limited and therefore answer needs to be an expression!!
Have single table/entry form financial db. Want one field (already a calculated field) on form to bring forward the record of total costs so to update for new week. Viz. the expression in control source for the field needs to be generally:
=[CostsForWeek]+[CostsForPreviousWeek]
Question: What other data is required in the expression to bring forward the previous record?
Note my knowledge of VBA is extremely limited and therefore answer needs to be an expression!!
