What's the rest of the code? I would assume this worked. Where are you using your results?
>Hi Claude:
>
>There is no error. There is also no result. It's as if the sql is not executing and is bypassed by the HTML code.
>
>I put the sql statment between <% and
>
><% Select * From showprep Where Day(Date()) = Day(prepdate) And Month(Date()) = Month(prepdate) INTO cursor tempprep
>
>
>I am VERY new to ActiveVFP and this will be one of 'those' new user coding mistakes on my part.
>
>Thanks for getting back to me so quickly.