>Edward,
>
>When I tried plgging in the values directly i got the results i was looking for.
>As a matter of fact i tested the SQL queries as a seperate program before i copied them into my app.
>
>Perry

So, make one more test
=messagebox(gstext)
Select .... Where ...=gstext
Select .... Where ...=(type exactly what you see in messagebox here)
If these two Select(s) will give different results I will say: sorry :), if not -you :).