I have a report set up that I want to add records to on specific dates. On the first day of the week, ActualSales and all that go in just fine. However, I want to report to enter ActualSales on the next day in the correct spot. I have a field called StartDate, which is the date of the beginning of that week. Boxes on my report then calculate the dates of the rest of the days by using =FirstDate()+1, =FirstDate()+2, etc., etc. Under the second day (=FirstDate()+1), I want sales for that day. I worte this expression, but all I get in the first day's sales:
=IIf([FirstDate]=([FirstDate]+1),[ActualSales],[ActualSales])
What am I missing here? How can I get that to only display the ActualSales for FirstDate+1?
=IIf([FirstDate]=([FirstDate]+1),[ActualSales],[ActualSales])
What am I missing here? How can I get that to only display the ActualSales for FirstDate+1?
