Hi. I have a form with a grid. The grid shows products. I want to add a column to show the average days in the warehouse. My warehouse data contains a date so I want the SQL to be:
select cpartno, avg(date()-indate) as avgdays from whcuinvbin group by 1 having cpartno = THISFORM.THISGRID.COLUMN1.txtPart.Value

I do not want to change this grid to be based on a view, because of the way I need the whole thing to operate. I think I could fool foxpro by creating a combobox but can I do this with a textbox?

Thanks for the help

Sandi