SQL Statement to Update Query Results to a Form Textbox

[RAJESHKUMAR R]

Dear Experts,

I have below SQL Statement to count data from a Table which is working Fine!

SELECT Count(FIRMORDERS.Ref_Date) AS CountOfRef_Date
FROM FIRMORDERS
WHERE (((FIRMORDERS.[Ref_Date])=[Forms]![MENU]![FR_DATE]))
GROUP BY FIRMORDERS.Ref_Date;

The Support I am looking here is, I would want to transfer output of above results to a textbox i.e. named as [MENU]![TEXT15]

Thanks & Regards,
Rajeshkumar R

[ranman256]

redo the sql to just pull the records using the date, (not count them)
put the sql in a query,

txtBox = Dcount("*", "qsMyQuery")

[Micron]

I would want to transfer output of above results to a textbox i.e. named as [MENU]![TEXT15]

To do what? Only look at it, or store the result in a table? Generally speaking, you shouldn't store calculations, but if that's your intent, know that a calculated field (e.g. textbox) cannot be bound to a field.