I have an Access datasource for movie listings. mTitle is the column/field
for the movie's Title. I need to output the records ordered by mTitle,
however I need to ignore the when it is the first word.
For example: The Big Lebowski should be ordered by B in Big, not T in The.
My solution
did you try single quotes?
[EMAIL PROTECTED] wrote:
I have an Access datasource for movie listings. mTitle is the
column/field for the movie's Title. I need to output the records
ordered by mTitle, however I need to ignore the when it is the first
word.
For example: The Big Lebowski
Sorry, the double quotes in the query statements are simply a typo on my
part. I didn't copy and paste the actual query, I simply retyped it as I
wrote the email and out of bad habit used quotes.
The quotes ' or is not the problem. This query and/or using the REPLACE
function works perfectly
I've run into many issues using CF-built queries on an Access db over
the years. I recall one that had about a dozen doublequotes in it. Freaky!
Have you tried including the [] around the field name just for fun?
T
[EMAIL PROTECTED] wrote:
Sorry, the double quotes in the query statements
