Nov 2005
Nov 2006
Nov 2007
|
Guest's Calendar
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #1/1/2006# and #2/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #2/1/2006# and #3/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #3/1/2006# and #4/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #4/1/2006# and #5/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #5/1/2006# and #6/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #6/1/2006# and #7/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #7/1/2006# and #8/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #8/1/2006# and #9/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #9/1/2006# and #10/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #10/1/2006# and #11/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #11/1/2006# and #12/1/2006#) ORDER BY DateAdd DESC;
|
SELECT * FROM Log Where (User='Guest' or Log='Guest' or Share='y') and(DateAdd between #12/1/2006# and #1/1/2007#) ORDER BY DateAdd DESC;
|
|