I'm trying to pull data out of a free table with a sql statement that i copied from a view I made.
When I run the view from the view designer it runs fine, but if i copy the sql statement then run it from my
command button or the command window it wont pull the data out. I don't get any errors it just doesn't
seem to find the data when i know its there. If I have the view designer open and run it there it works. Then
if I copy the statement into the command window it will work, but after I close the view designer it stops working.

here is a sample of what my select statement looks like

select cash.cashadd, cash.cashdep, cash.cashop;
from cash;
where cdate = date()

Thanks Kelly