I work in a hospital and I'd like to make a report to take a census for each day given a data range and return the average.

I was thinking if I created a calendar and used that as the table to go against the admission and discharge history table, I could do it.

The problem is, how to make the calendar. I know I need an array, but I haven't made one before. Does this code look correct?

Local numberVar I;
Shared DateVar array opmerking;
Shared NumVar Counter
reDim opmerking{Counter};
Counter := DateDiff("d", {?BeginDate}, {?EndDate}) + 1
for I := 1 to Counter
            opmerking <i>:= {?Beginning_Date} + 1 ;

Yes. command object was the idea.