I have a subform that displays dates and points (numbers) fields. I want the textbox in the form footer to display only the total points of the records that are 1 year or newer, however still showing all of the records in the detail section. The textbox control source is;
=Sum(IIf(Date()-[txtPtDate]<365,[Pts],0))
I have tried the syntax a couple different ways, but still get an error in the textbox in form view. I'm hoping it's something simple, but haven't figured it out yet. Can someone please help?
Thank you in advance.