Hello,
I'm having a bit of a problem with what i would have thought would have been a simple query. I have connected a sharepoint calendar to access and only want to see the appointments for tomorrow. In the query criteria i put in Date()+1 but there are no results. I have tried some experimenting with Between Date()+0 And Date()+1 which works as expected but also gives me today. I tried putting in Between Date()+1 And Date()+1 and that gvies me new returns. What am i doing wrong?
V/R
Archy
I'm having a bit of a problem with what i would have thought would have been a simple query. I have connected a sharepoint calendar to access and only want to see the appointments for tomorrow. In the query criteria i put in Date()+1 but there are no results. I have tried some experimenting with Between Date()+0 And Date()+1 which works as expected but also gives me today. I tried putting in Between Date()+1 And Date()+1 and that gvies me new returns. What am i doing wrong?
V/R
Archy