DB resaults error2 Drop down problem

[Mettá]

Is the sql on an access db correct as this seems not to be working, however
if I remove the DISTINCT part it seems to work fine except the drop down
then contains multiple same name counties?

SELECT DISTINCT County FROM dbasename WHERE (field1 LIKE '%::field1::%')
ORDER BY County ASC

Thanks
M

FP2002

 

[Mettá]

A bit more in the hope that someone responds...

It seems the DB results work if there are no user variables involved, if
however, results are dependant on other content or user input the results
fail, I have checked that there are defaults etc and all seems well - and
has been working just fine for around 2 years or more.

Has an update in XP, FP or IIS etc changed anything odd or is anyone
experiencing these problems???

Help
Thanks
M