Hi all! I am creating a Disney "Today in History" database, and so
far have about 300 entries in it. Well, my Access database is great,
and my Frontpage form is great, but I want to include a short "On this
date in Disney history....<event>" on my main web page. Basically,
if someone goes to my web page, they'll automatically see this if
there is an event that occurred on this day.
So, my problem is... how do I create an SQL database that shows ONLY
the events from today? Like, "On September 4, 1931, Walt
Disney...yadda yadda yadda." My SQL query must be wrong because
nothing is getting displayed for events on days that I KNOW there are
events.
Here is my query...
SELECT * FROM Results WHERE (Month = '::Month::' AND Day =
'::Day::')
This doesn't display any events on the day I choose (and I've changed
the date a few times on my computer to match days that have data in
them). Can someone help me to make a query that might work to display
the results of the Month and Day only? (They're both separate fields
in my access database).
If you want to check it out, go to http://www.bbdisney.com/tih.asp
Thanks!
Dan
da*******@NOSPAMshaw.ca