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