Future Range - Appointments in Microsoft Access


	Back to Appointments Comments List

Upload Images @Reply Bookmark Link Email

Future Range

Monica Jones

3 years ago

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 @Reply 3 years ago
You have an extra double quote. Also, use And instead of To. `"WHERE StartDateTime = #" & Date & "# And StartDateTime <= #" & Date+7 & "# "`

	Richard Rost @Reply 3 years ago
One minor change to what Kevin has: `"WHERE StartDateTime >= #" & Date & "# And StartDateTime <= #" & Date+7 & "#"`

	Monica Jones OP @Reply 3 years ago
Thank y'all so much! It works perfectly!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Appointments.