Average Days Between Orders (Recordset)

[tennisbuck]

Hi,

Does anyone have or can help to write VBA that would loop through a dataset and figure out days between orders? I posted an example where I can do this easily in excel but in access I'm unsure.

Thanks,



Mike

[ItsMe]

I did not look at your sample but have you considered the DateDiff() function?

[tennisbuck]

Yes, and that would work if I only had 2 dates but there will be multiple orders