Aggregate Query

[John]

Is there a way to create a grouping query and be allowed to edit the
data. I want to create a query that has a grouping and totals but also
allow the user to edit. Can it be done?

[Tom van Stiphout]

On 14 May 2007 10:39:13 -0700, John <da********@hotmail.comwrote:

No. All queries with Group By are readonly.

Regular Select queries with perhaps a few DSum columns can still be
editable.

-Tom.

>Is there a way to create a grouping query and be allowed to edit the
data. I want to create a query that has a grouping and totals but also
allow the user to edit. Can it be done?

[paii, Ron]

How would Access know which records to update?

Now, you could use your query to fill a temp table to be used in a form. You
would need to supply code to update or append records when the temp table is
changed. Realize the temp table is static, any changes to the underlying
tables by other users would NOT be visible to the form.

"John" <da********@hotmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...

Is there a way to create a grouping query and be allowed to edit the
data. I want to create a query that has a grouping and totals but also
allow the user to edit. Can it be done?

[salad]

John wrote:

Is there a way to create a grouping query and be allowed to edit the
data. I want to create a query that has a grouping and totals but also
allow the user to edit. Can it be done?

You could create a table (MakeTable query). But it wouldn't be dynamic
thus kind of useless.