Hi Kelly,


>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

Is cash the currently selected alias?
perhaps qualifying cdate as cash.cdate ?