<font color=brown>This one works fine without the WHERE clause

SELECT activities.activityID, projectID, contributorID, activities.activityTypeID, detail, duration, dateActivity, activityTypes.activityTypeID, activityType FROM activities INNER JOIN activityTypes ON activities.activityTypeID=activityTypes.activityTypeID WHERE (activities.dateActivity BETWEEN #11/2/2004# AND #10/3/2004#) ORDER BY dateActivity DESC

but not as it is above?</font id=brown>

DMX | ASP | VBScript | ACCESS | IIS5

orphaned post?