I have a adp file - with a subform (data sheet view)
The subform contents is based on a SQL Query.
I want to get some group by information to display in main form.
Is there a effecient way to do this??
Can i do the query on the subform(without intergating the sql server)? or do i have to just create reuse the sql string and add some more clauses on it?
The subform contents is based on a SQL Query.
I want to get some group by information to display in main form.
Is there a effecient way to do this??
Can i do the query on the subform(without intergating the sql server)? or do i have to just create reuse the sql string and add some more clauses on it?