D
Dan
Does anyone know how to display JUST the events with a value of
"September" in an Access db using Frontpage 2002?
Here's my query:
fp_sQry="SELECT * FROM Results WHERE (Month = '#::Month::#') ORDER BY
Month DESC"
I get "no results found" when I run this query. I have also tried
'%::Month::%', '::Month::', and "::Month::" but have not had any luck,
and I know I have some events that happened in September.
If you want to see what I'm getting at, go to www.bbdisney.com and
have a look at the bottom of the main page.
Someone told me that if you have defined fields named "Month", "Day"
and "Year", the query won't work. Anyone else had any experience in
that area?
Many thanks,
Dan
"September" in an Access db using Frontpage 2002?
Here's my query:
fp_sQry="SELECT * FROM Results WHERE (Month = '#::Month::#') ORDER BY
Month DESC"
I get "no results found" when I run this query. I have also tried
'%::Month::%', '::Month::', and "::Month::" but have not had any luck,
and I know I have some events that happened in September.
If you want to see what I'm getting at, go to www.bbdisney.com and
have a look at the bottom of the main page.
Someone told me that if you have defined fields named "Month", "Day"
and "Year", the query won't work. Anyone else had any experience in
that area?
Many thanks,
Dan