Hi,
I'm not sure this is the right forum for this but here goes;
I have some legacy code for displaying dates based on the records in a query.
The DMin function is VERY slow as I would expect but what would be the fastest method to retrieve the lowest date from a bunch of records?
Any help appreciated
Sim
----------------------------------------
It is of interest to note that while some dolphins are reported to have learned English -- up to fifty words used in correct context -- no human being has been reported to have learned dolphinese.
----------------------------------------
I'm not sure this is the right forum for this but here goes;
I have some legacy code for displaying dates based on the records in a query.
Code:
For vWeekday = 2 To 6
'########### label all dates ####################
vDespatch = Null
strCriteria = "WeekDay(IdealDespatchDate) = '" & vWeekday & "'"
vDespatch = DMin("[IdealDespatchDate]", "Q_CDProd", strCriteria)
The DMin function is VERY slow as I would expect but what would be the fastest method to retrieve the lowest date from a bunch of records?
Any help appreciated
Sim
----------------------------------------
It is of interest to note that while some dolphins are reported to have learned English -- up to fifty words used in correct context -- no human being has been reported to have learned dolphinese.
----------------------------------------