Great info as always. I haven't taken your VBA course, yet, so I'm stumbling in the dark and Google is giving me conflicting answers. I'm trying to change the Future Only case to be limited to the next seven days. Some places on Google say to use the operator To between the dates and others say it simply can't be done. Here's what I currently have(and it turns red) "WHERE StartDateTime = #" & Date & "# " To StartDateTime <= #" & Date+7 & "# " TIA, Monica
Kevin Robertson 4 months ago
You have an extra double quote. Also, use And instead of To.
"WHERE StartDateTime = #" & Date & "# And StartDateTime <= #" & Date+7 & "# "