Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Amanda2
-
different date criteria for days of week
Thanks Frank, you're right! Now I just have to figure out the week functions. DateAdd("w",-2,[DateField]) ???- Amanda2
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
different date criteria for days of week
I need to get records based on a range of dates that change depending on when I am running the query. ie: If I run it on Monday I need records with dates from between 10 and 16 days ago; if I run it on Tuesday, I need records with dates from between 11 and 17 days ago... DateAdd does not seem...- Amanda2
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Adding working days in SQL
Thanks Leslie, that's what I was afraid of. Guess I'll have to face my fears of the module!- Amanda2
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Adding working days in SQL
I do not know VBA and would like to know if there is a way to get records with a date populated field that is 11 working days ago in SQL. Any help is appreciated. Amanda- Amanda2
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
