Having problems with this Ray..
I've tried numerous manual builds of the query but every time get SQL syntax errors.
So I then used the WA query builder and even that gives a syntax error.
the attached screen shot shows 2 queries ( recordsets ) rsActiveApps which is the original setup for the list. And rsActive which is the new one built from the query builder that doesn't work.
Also attached is page with these on.
Where am i going wrong?
Thanks in advance!